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.
For step by step Oracle R12/12i upgrade process follow R12 Upgrade Guide here and R12 Installation Guide Here
If you want to know what is changed in R12 (like technical difference between 11i & R12 Click Here or new TOP INST_TOP click here )
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 11.5.10.2 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)
In Select Upgrade Action screen select “Create Upgrade File System” (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
adpatch options=nocopyportion,nogenerateportion
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
Related Docs
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
Related Posts for Apps R12
- Oracle Apps R12 Forms : Servlet or Socket
- Release Update Pack for Oracle Applications R12
- Difference between Oracle Apps 11i and R12 (Technical)
- Unified APPL_TOP : Changed Feature in Oracle Apps R12
- Oracle R12/12i log file (Patch, Clone, Startup/Shutdown)
- Upgrade Oracle Apps 11i to R12/12i (12.0.4) - Key Points
- Oracle Apps Release 12.1 , Guess official release date ?
- Oracle 12.0.6 R12 RUP6 is Out now
- Application Tier Services in Oracle Apps R12
Popularity: 15% [?]
Download R12 VMware Documentation
Good hands-on exercises (installation, patching, cloning), very experienced trainer worth for Money 
27 users commented in " Upgrade Oracle Apps 11i to R12/12i (12.0.4) - Key Points "
Follow-up comment rss or Leave a Trackbackhey u know what I released the 12.0.4
and contributed for the database prep guidelines ..
i am a release engineer in oracle.
1-should i upgrade mkstoolkit before upgrade to R12, and if i will use Cygwin, should i configure it on the system before upgrade to R12?
2-dose we create another oracle_home for R12 or we use the exist 11i oracle_home?
Does we create another oracle_home for R12 or we use the exist 11i oracle_home?
As a part of first runInstaller you lay down file system for R12 (You can’t use same oracle_home on middle tier)
Thanks Atul so much for the answer.
I am using 11.5.10.2 with 9i and going to upgrade to 12.0.4 with 10.2.0.3 windows system
This the steps which i will do on my system:
1- apply patch# 6502082 AD.I.6
2- apply patch# 6727612 TUMS and generate the report(i did it and there are no settings necessary).
3- Already Converted to Multiple Organizations.
4- Run AD Preparation script patch #5726010.
5- apply patch #4563075 for OPM.
6- Gather schema statistics for CBO.
7- Run R12 Rapid Install and choose upgrade option.
8- Upgrade to oracle portal 10g
9- Deregister the current database server.
10- I want know how to do this steps and what patch # should i apply:
- Perform 10.2.0.3 patch set pre-installation tasks.
Perform 10.2.0.3 patch set installation tasks.
11- Upgrade the database instance (How??).
12- apply patch set 5337014.
13- apply patch #6344567
14- apply patch #4247037
15- apply Oracle Service patch #5880762
16- Shut down application tier listeners and concurrent managers.
17- enable maintenance Mode.
18- Drop MRC schema.
19- Run Rapid Install again and choose the location of the new *.xml file path which created by the first rapid install.
I hope you help me and advice what steps is missing and also answer to my questions which you will find it during the steps.
Thanks
i forgot to tell you that i already have CDs for 12.o.4 with 10.2.0.2 so is it enough or also i will need patch set for 10.2.0.3?
Regards
Ashraf,
10.2.0.2 is certified with 12.0.4 (just double check from certification matrix) and if this is certified 10.2.0.2 is enough
But i still don`t know if there are something missing in this scenario or not?
should i upgrade the oracle portal to 10g before upgrade the database or it will upgrade itself when i use rapidwiz?
Regards
Hi Ashraf,
How far did you reach upgrading to R12i?
Hi Atul Kumar ,
I applied patch 6502082(AD.I.6) then applied patch 5726010( AD Preparation Scripts)then install visual studio 2005 then used sygwin, and start to run r12 stage(12.0.0.21) and choose upgrade option , but it gave me error on during upgrade.
what error ?
You are upgrading from which version ?
i am upgrading from 11i cu2 database 9i to r12 and it give me an error on 66%.
Regards
Is this step at “create or update file system” suring upgrade process ?
What is error message ?
For Oracle apps R12 installtion log directory check
http://onlineappsdba.com/index.php/2007/12/25/oracle-r1212i-log-file-patch-clone-startupshutdown/
Hi Atul,
I want to know the new features of Oracle Projects module in R12. Basically I am finance technical and new to Projects module so it will be very nice if you can brief me on the same on technical side.
Thanks,
Nilam
Hi,
I am upgrading 11i to R12.we have 2 node architecture.Database/CM and on another node Apache/Forms.
I have sucessfully first upgraded the database to 10.2.0.4 and then to OATM and now I have sucessfully applied patch 6394500.
Now what should be the next step.I am following the E12011-01 Docc.
I am at the step configure and start server process.When do i need to run the rapidwiz again.before or after.please advice.
I have taken the backup at this stage.
I just need guidence another 3 steps.
Thanks for your help
Anil Kumar
Hi,
I would like to add.
Should I run the rapidwiz first as mention here pointing to new R12 $APPL_TOP/admin choosing the upgrade to oracle R12 home.
2.Docc says you need to create the new xml file
perl /bin/admkappsutil.pl then copy to the database server and generate the contextfile.I am little confuse here.
Thanks
Anil
Hi,
I am sorry I got the answer.Rapidwiz should be after that.
Thanks
Anil
Hi,
We have implemented Oracle Apps 11i (11.5.10.2) Oracle CRM for our customer and following are the modules we have implemented:
• Oracle Teleservice
• Oracle Service Contracts
• Oracle Field Service
• Oracle Mobile Field Service
• Oracle iSupport
• Oracle Receivables
Now the customer is interested in upgrading to R12 and wants to know if there are known issues in upgrading the above modules to R12.
Please let me know if any of you have had the experience in upgrading CRM modules to R12.
Rgds,
Thiru
We are on Ebus 11.5.9 we upgraded database to 10G with RAC , we are entending to upgrade to 12i.
1- is there any other pre-requsite the technology stack
2- Should we upgrade first to 11.5.10 , then Oracle 12.0.x or we can do straight upgrade
to release 12i ,
3- what version of release 12i is most stable and recommended .
thanks Atul .
Regards,
1- is there any other pre-requsite the technology stack
No (database upgrade to 10g is enough rest techstack upgrade will come as part of 11i to R12 upgrade), just take care of client side (from Jinitiator to Java Plugin)
2- Should we upgrade first to 11.5.10 , then Oracle 12.0.x or we can do straight upgrade
to release 12i ,
You could directly go from 11.5.9 to 12.0.X
3- what version of release 12i is most stable and recommended .
12.0.4
I am at 11.5.9
We plan to upgrade. My question to you is that , upgrade to 11.5.10 is better or upgrade to 12.1 is better?
We use AP,AR,GL
Will appreciate your guidance
Can you suggest how to check if 11.5.9 installation is CU1 or CU2?
hi all;
we are working with Oracle EBS 11i [11.5.10.2] and Database 10g [10.2.3]…
now we are going to upgrade to 12.1.1 ..
What are the steps actually required to migrate:-
1-Database no need to migrate [ at least certified with 12i]
2-on Application Tier , It need to install some Patch and TUM Scripts ..
3-Rapid Install on the same version and same oracle home …
we have minimal customization, can we make a fresh installation of 12i only??
Thanks for your help
Yours
Hi Atul,
The document and suggestion from your side is very Useful.
Please tell me whether we can proceed migration from 11.5.9 to 12.1.1 is there any problem.
regards
vikas
We upgrade from 11.5.10.2 to 12.0.4 and then to 12.0.6.We were on 10.2.4 database ,what I did is I convert the tablespaces to OATM and every thing went fine.For R12 I use Upgrade Guide Release 11i to Release 12.0.4 PART no E12011-02.I have the docc prepared for my company.Atul docc is very good docc to refer.
Anil Kumar
Can someone please tell what steps I need to perform to convert to Multi org before starting upgrade from 11.5.10.2 to R12.
Our environment is not multiorg and converting to multiorg is one of the mandatory step to perfomr upgrade.
Your help is appreciated.
Leave A Reply