Monday, 2 August 2010

Upgradation from Oracle Apps to R12.1.1

Using the following steps I have successfully upgraded my instance to R12.1.1

In this test, I didn't upgraded the individual products upgrade, the main focus was to upgrade from 11i to R12.1.1. The below upgrade steps are for testing purposes only, please do refer metalink note for more information

Status of my instance are:-
Already my instance is  on 11i.AD.I.7
Database version:
Apps Version:
Developer 6i latest patchset 19
Applied Latest CPU July 2010 both Apps and DB tiers
Java version "1.6.0_07"

This instance is Multi-Org, coz multi-org is mandatory in R12.1.1

1. Applied TUMS utility  - 7705743

2. Applied Run AD preparation scripts - 7197489

3. 12.1.1 Rapid Install completed successfully with "Upgrade File"
 Here for R12, created one new apps user, appsR12

4. Applied required patches for


5. Gather statistics for SYS schema completed

Copied R12 $APPL_TOP/admin/adstats.sql from the administration server node to the database server node

$ sqlplus "/ as sysdba"
SQL> shutdown normal;
SQL> startup restrict;
SQL> @adstats.sql
SQL> shutdown normal;
SQL> startup;
SQL> exit;

6. Updated init.ora with new parameters (Metalink Note:396009.1)

7. Maintenance Mode is enabled
 Source the R12 Application Tier

8. Applied AD 12.1.1 upgrade driver - 7461070

9. Run the American English upgrade patch driver - u6678700.drv
 cd $AU_TOP/patch/115/driver
 adpatch options=nocopyportion,nogenerateportion
 (depends on your hardware, this process will take hours/days. So be patient)

10. Configure and start server processes – RunInstaller
  Start the runinstaller from staging area again

11. run autoconfig from Apps Tier as well as Db Tier

12. Restart the R12 Apps Tier

Lots of issues in between upgrade patch driver process, always keep on monitoring the log file and clear the issues and restart the workers using adctrl utility. This issues will vary depends on installation to installation.
Before starting the upgrade driver process, you have to make sure enough space on APPS_TS_TX_DATA tablespace.


SocialTwist Tell-a-Friend

Related Posts by Categories


Anonymous said...

i am unable to find American English upgrade patch driver - u6678700.drv in metalink. Please help how can i get this patch or is there any patch that has superseeded this one. please let me know.
i am trying to upgrade from 11i to r12.1.1


Ajikumar G said...

Hi Praneeth,
To run the American English upgrade patch driver 6678700, you have to change your directory to the destination
$ cd $AU_TOP/patch/115/driver
This 6678700.drv is available here as part of upgradation. Now you can patch the application using
$ adpatch options=nocopyportion,nogenerateportion