Apps DBA Workshop

Detailed article for upgrade Apps R12 database from version 11gR1 to 11gR2 So many individuals keep on requesting me to post an article about - "Upgrade database to 11gR2 in an Oracle E-Business suite R12.1.1 Environment" Oracle E-Business suite R12.1.1 will be shipped with database version 11.1.0.7. Here is the step-by-step approach for upgrading database version from 11.1.0.7 to 11.2.0.1 1) Pre-Upgrade Steps - perform all OS per-requistes for Installing 11gR2 SW - Install 11gR2 database software only - Install 11gR2 examples CD - copy required file from 11gR1 (11.1.0.7) $ORACLE_HOME to 11gR2 (11.2.0.1) $HOME - perform a full system cold backup - Install all required application and database patches - Run pre-upgrade utlu112i.sql and update changes as required 2) Upgrade - execute dbua to perform an database upgrade - verify the upgrade logfile for any errors 3) Post upgrade steps - start database listener - Run scripts (adgrants.sql, adctxprv.sql, wfaqupfix.sql) on ...