This post covers overview/top level steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12/12i (12.0.4).
This post is useful to understand upgrade from Apps DBA point of view and does NOT cover any functional steps in upgrade process.
If you are already on R12 (12.0.0, 12.0.1, 12.0.2 or 12.0.3) and wish to upgrade to 12.0.4 Check Steps Here
Key points with regard to upgrade
– You can upgrade to R12/12i (12.0.4) ONLY from release 11.5.8, 11.5.9.X or 11.5.10.X (For any previous release like 11.5.7 , upgrade them to 188.8.131.52 first)
– You can upgrade database to version 10.2.X during upgrade (11.5.8, 11.5.9.X, 11.5.10.X) or BEFORE R12 upgrade (only for 11.5.9.X and 11.5.10.X)
Upgrade is broadly divided in to three steps
—Preupgrade Step (lay down file system for R12 using rapidwiz/RapidInstall)
—Upgrade Step (Upgrade database to 10gR2 (if not already upgraded), apply R12.AD.A on R12 APPL_TOP and apply 12.0.4 patch database portion only)
—Post Upgrade step (Run rapidwiz/RapidInstall one more time to configure and start services on R12)
A. Pre-Upgrade Process
1.Layout file system for R12 using rapidwiz with option as upgrade.
Run rapidwiz from R12 software >> Select option “Upgrade to Oracle Applications Release 12” (Check Figure)
Follow further screens and installer will install R12 file system (This step will NOT configure and start services in R12, It will only install R12 files)
Note* There are other preupgrade steps as well like migrate backup, TUMS (optional), OATM, convert to multi org, gather stats and functional preupgrade steps (Detailed step by step upgrade doc coming soon …)
B. Upgrade Process
2.Migrate database to 10gR2 – This step is required if you have not upgraded your database with 11i itself. Use ORACLE_HOME (10.2 on database tier) which came as part of R12 upgrade (Create Upgrade file system above in preupgrade step)
Also check following Metalink Notes
403339.1 – Oracle 10g R2 Database preperation Guidelines for Oracle E-Business Suite R12 Upgrade
396009.1 – Database initialization parameters for Oracle apps R12
3. Put your Apps into database in to maintenance mode
4.Run adpatch 6604842 (on R12 appl_top, environment variable at this stage should point to R12 APPL_TOP and ORACLE_HOME in application tier should point to FORMS (10.1.2) in R12) to upgrade AD product of R12 to 12.0.4 (Patch 6604842 is available as R12.AD.A)
5. Run 12.0.4 patch 6394500(u6394500.drv ) which is under $AU_TOP/patch/115/driver (on R12/12.0.4 APPL_TOP). Note* You have to apply this patch on 12.0.4 APPL_TOP.
Apply this with nocopyportion and nogenerateportionas copy and generate portion is already available as part of R12 install done above in preupgarde step.
Apply/Upgrade to 12.0.4 using
6. Disable maintenance mode
C. Post Upgrade Process
Database and database listener should be up at this stage.
7. Run Rapid Install one more time (with different option check figure) to configure and start services on R12/12i.
Run rapidwiz one more time
Select option “Upgrade to Oracle Applications Release 12” (Check Figure)
In Select Upgrade Action screen select “Configure Upgraded Release 12 Instance” (This select is different from selection in Pre-Upgrade Step)
Change file name as shown in figure to your new $APPL_TOP/admin/$CONTEXT_NAME.xml (R12)
There are other finishing tasks which are out of scope of this post like backup, reset password, setup client machines (java plugin), printers, workflow notification mailer and various functional steps
399362.1 E-Business Suite Release 12 Upgrade Sizing and Best Practices
396009.1 Database Initialization Parameter for Oracle Applications R12
Stay tuned for more on Oracle Apps R12/12i upgrade from release 11i
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.