Tuesday, November 10, 2020

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 35:

 

[apdpro@r12upgdb bsu]$ ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=RVBS -prod_dir=$FMW_HOME/wlserver_10.3

Checking for conflicts.....

Conflict(s) detected - resolve conflict condition and execute patch installation again

Conflict condition details follow:

Patch RVBS is mutually exclusive and cannot coexist with patch(es): 2GYW,VKXF,1LRI,FCX7,Y5AP,CW9T,BLTG

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

        at java.util.HashMap.createEntry(HashMap.java:897)

        at java.util.HashMap.addEntry(HashMap.java:884)

        at java.util.HashMap.put(HashMap.java:505)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:778)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDetails(PatchCatalogHelper.java:695)

        at com.bea.plateng.patch.dao.cat.Version.getPatchDetails(Version.java:41)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getFilteredPatchDetailMap(PatchCatalogHelper.java:1202)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDetails(PatchCatalogHelper.java:1398)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getEveryPatchDetail(PatchCatalogHelper.java:767)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1622)

        at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)

        at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)

        at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)

        at com.bea.plateng.patch.Patch.main(Patch.java:306)

[apdpro@r12upgdb bsu]$

 

 

 

Solution:

[apdpro@r12upgdb ~]$ cp -p $FMW_HOME/utils/bsu/bsu.sh $FMW_HOME/utils/bsu/bsu.sh_org

[apdpro@r12upgdb ~]$

 

 

[apdpro@r12upgdb ~]$

[apdpro@r12upgdb ~]$ cat $FMW_HOME/utils/bsu/bsu.sh|grep MEM_ARGS

MEM_ARGS="-Xms512m -Xmx1024m -XX:+UseParallelGC"

"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*

[apdpro@r12upgdb ~]$ vi $FMW_HOME/utils/bsu/bsu.sh

[apdpro@r12upgdb ~]$ diff $FMW_HOME/utils/bsu/bsu.sh $FMW_HOME/utils/bsu/bsu.sh_org

5c5

< MEM_ARGS="-Xms1024m -Xmx2048m -XX:+UseParallelGC"

---

> MEM_ARGS="-Xms512m -Xmx1024m -XX:+UseParallelGC"

[apdpro@r12upgdb ~]$

-          Rerun the failed command again

Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 34:

While applying 12.2.6 RUP patch:

ATTENTION: All workers either have failed or are waiting:

 

           FAILED: file DDR_R_CLNDR_QTR_DN_MV.xdf on worker  1.

           FAILED: file MTH_RESOURCE_COST_MV.xdf on worker  2.

           FAILED: file ozf_earning_summary_mv.xdf on worker  3.

           FAILED: file MSC_PHUB_RESOURCES_MV.xdf on worker  4.

           FAILED: file DDR_R_CLNDR_MNTH_DN_MV.xdf on worker  5.

           FAILED: file MSC_PHUB_SUPPLIERS_MV.xdf on worker  6.

           FAILED: file DDR_R_AOH_LVL_4_ATTR_MV.xdf on worker  7.

           FAILED: file MSC_PHUB_PROJECTS_MV.xdf on worker  8.

           FAILED: file MTH_SHIFT_REFERENCE_MV.xdf on worker  9.

           FAILED: file DDR_BS_INV_SKU_BU_COMBS.xdf on worker 10.

           FAILED: file MSC_PHUB_CATEGORIES_MV.xdf on worker 11.

           FAILED: file DDR_R_CLNDR_PRD_DRTN_DN_MV.xdf on worker 12.

           FAILED: file DDR_R_AOH_LVL_3_ATTR_MV.xdf on worker 13.

           FAILED: file DDR_R_AOH_LVL_1_ATTR_MV.xdf on worker 14.

           FAILED: file DDR_R_AOH_LVL_2_ATTR_MV.xdf on worker 15.

           FAILED: file MTH_EQUIPMENTS_EXT_B_MV.xdf on worker 16.

           FAILED: file MRP_COMPANY_USERS_SN.xdf on worker 17.

           FAILED: file DDR_R_CLNDR_DAY_DN_MV.xdf on worker 18.

           FAILED: file MSC_PHUB_ORGS_MV.xdf on worker 19.

           FAILED: file MSC_PHUB_CUSTOMERS_MV.xdf on worker 20.

           FAILED: file MSC_PHUB_DATES_MV.xdf on worker 21.

           FAILED: file DDR_R_CLNDR_WK_DN_MV.xdf on worker 22.

           FAILED: file DDR_R_CLNDR_YR_DN_MV.xdf on worker 23.

           FAILED: file MTH_EQUIP_SHIFT_HR_PERF_MV.xdf on worker 24.

           FAILED: file MTH_SHIFT_GREGORIAN_DENORM_MV.xdf on worker 25.

           FAILED: file MTH_ITEM_COST_MV.xdf on worker 26.

 

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

 

Worker log:

Start time for statement above is Tue Apr 25 00:08:15 AST 2017

Error while writing error logs to DB

Ignoring the error and continuing ...

Turning off logging errors to DB ...

 

Exception occured  ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater

ORA-00722: Feature "Editions"

ORA-06512: at "APPS.AD_MV", line 183

ORA-06512: at "APPS.AD_MV", line 330

ORA-06512: at line 1

 

Solution:

Stop all workers > adctrl > 3 > all

Change compatibility parameter value:

SQL> sho parameter COMPATIBLE

 

NAME                                                        TYPE VALUE

------------------------------------ ----------- ------------------------------

compatible                                              string                11.2.0

noncdb_compatible                            boolean          FALSE

SQL>

SQL> alter system set compatible='12.1.0' scope=spfile;

 

System altered.

 

SQL> shu immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

 

Total System Global Area 6442450944 bytes

Fixed Size                                4511656 bytes

Variable Size                      2583693400 bytes

Database Buffers             3841982464 bytes

Redo Buffers                        12263424 bytes

Database mounted.

Database opened.

SQL>

 

-          Restart the patch again