So you’re going to patch from 12.0.6 to 12.1.1?  It’s basically like any other major upgrade with Oracle’s e-Business Suite; tons of pieces to upgrade, patch, validate, and a high potential for running into problems.  The documentation for all the “gotchas” is all over the place, but Metalink document 752619.1 is the best place to start and has all the major steps listed.  In general, the following is required:

• Confirm database version
• Upgrade 10.1.3 home to 10.1.3.4
• Upgrade 10.1.2 home to 10.1.2.3
• Apply necessary pre-req patches
• Apply maintenance pack (7303030)
• Apply post-maintenance pack patches
• Do all the post-upgrade steps

Below are some of the lessons learned in an environment in which we patched 12.0.6 to 12.1.1 and along the way, upgraded the 10.2.0.4 database to 11.1.0.7.

Oracle XDB core-dumps (look for ORA-31114)

• Follow Metalink document 760611.1
• We’re not sure exactly why this happened, but something in the XDB upgrade from 10.2.0.4 to 11.1.0.7 failed

AZ tables/objects invalid and workers fail on 7303030 (azR12active.sql)

• Result of XDB core-dump issue above
• Follow Metalink document 832459.1

Worker fails on EGOSILDU.sql

• Per Metalink document 847687.1, this is a bug patched with 8485942.  This patch, 8485942, isn’t available as of 10/10/2009
• Per the recommendation in 847687.1, skipped worked and continued

Relink fails on RAXTRX

• Choose to continue.  This is due to bug
• Look in 841113.1 for patches.  These are the ones I found that fixed this, plus some other issues found during testing …

8239041

7721420
7660309
7673650
8393427
8414254
8414069

Failures during 7303030 compiling multiple forms and libraries

• Choose to continue.  Manually recompile using adadmin after the patch, and if things still fail look for patches

Issues applying 10.1.3.4 IAS_ORACLE_HOME patch (7272722)

• Receive failures trying to start OPMN while at 83% complete on initial screen
• Environment was cloned and adcfgclone’d successfully from a 12.0.6 instance
• adcfgclone.pl will update all the right stuff in $ORA_CONFIG_HOME correctly, but several files in $IAS_ORACLE_HOME will not be updated with the correct environment-specific values
• Change hard-coded paths in the following:

$IAS_ORACLE_HOME/inventory/Clone/clone.xml
$IAS_ORACLE_HOME/config/ias.properties
$IAS_ORACLE_HOME/opmn/bin/opmnctl
$IAS_ORACLE_HOME/Apache/Apache/bin/iasobf

• Make sure you can run $IAS_ORACLE_HOME/opmn/bin/opmnctl startall|stopall|status
• Resume 7272722

Failures with 7303030 doing FndXdfCmp

• I’m pretty sure this was a site-specific issue related to not cloning cleanly
• If the adworkxxx.log file looks like this …

java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.ad.worker.AdJavaWorker.invokeUtility(AdJavaWorker.java:501)
at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:356)
Caused by: java.lang.NoSuchFieldError: mTypeData
at oracle.apps.fnd.odf2.FndInitType.doCmpType(FndInitType.java:156)
at oracle.apps.fnd.odf2.FndXdfCmp.doOdfCmp(FndXdfCmp.java:98)
at oracle.apps.fnd.odf2.FndXdfCmp.applyXDF(FndXdfCmp.java:186)

• … hopefully you’ve got an existing 12.1.1 instance to refer to
• Look in $JAVA_TOP/oracle/apps/odf2 for class files containing mTypeData.  You should see 3 class files
• Restore anything missing from a clean instance
• Generate all JAR Files
• Kill patch
• Resume

Patch takes a very long time on adobjcmp.sql (11.1.0.7)

• This will take a long time, it’s compiling all  invalid objects and there will be 50,000+
• Look for lots of time on “resmgr:cpu quantum” wait event
• Do “alter system set resouce_manager_plan=””
• Bounce the database when everything is done

Are you trying to use RapidWiz to Upgrade to 12.1.1 from 12.0.6?

• Don’t.  This is for an 11.5.x upgrade

More to come as I find them, I’m sure …