Oracle   Home  

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application R12 DBA  >  Upgrade 11i to R12: Upgrading the Middle tier to R12

NOTE: The following steps are specific to my installation (11.5.10.2 on Linux) and the steps are only for the technical upgrade. In the real life we have to take care of the customizations and we have to apply patches for different products as well. For more details please read the upgrade documentation which can be found on the CD /DVD you have received/ downloaded together with the Oracle Applications R12. Maintenance Wizard utility could be used as well. 

1. Install the latest version of 11i.AD.I (on the 11i APPL_TOP)

Fore more details click here. 

2. Install the R12 software

Fore more details click here.

3. Run TUMS utility

Download patch 5120936 (TUMS utility) and apply it on the administration server node. 

cd $AD_TOP/patch/115/sql

sqlplus <APPS username>/<APPS password> @adtums.sql <DIRECTORY>

. /APPS_DB_R12/db/tech_st/10.2.0/VIS_db.env

cd $AD_TOP/patch/115/sql

sqlplus APPS/APPS @adtums.sql /APPS_DB_R12/utl_file_dir

In /APPS_DB_R12/utl_file_dir directory there is a report (tumsr12.html) which contains the steps which don't need to be performed during the upgrade:

4. Convert to Multiple Organizations architecture

In my case this is already done. 

5. Review the size of the old tablespaces 

In my case all is ok. You can take a look in the Metalink Note 399362.1

6. Run AD preparation scripts

Apply the patch number 5726010:

More information about  this subject ( Upgrade 11i to R12: Upgrading the Middle tier to R12 ) you can get from  www.in-oracle.com

7. Gather schema statistics for CBO (highly recommended) 

From the 11i APPL_TOP, log in as sysadmin and navigate to "Submit Request" window -> Run -> Submit Gather Statistics program. Set the schema name to ALL.

8. Run the Minipack 4502962 (on R12 APPL_TOP)

Apply the u4502962.drv using AutoPatch. No prerequisites are needed. 

9. Run the American English update patch driver (u4440000.drv)

This will bring the database to a full Oracle Applications Release 12 level. The driver u4440000.drv is located in the R12 APPL_TOP, in the $AU_TOP/patch/115/driver 

on the administration node:

. /APPS_MI_R12/apps/apps_st/appl/APPSVIS_apps.env

cd $AU_TOP/patch/115/driver

adpatch options=nocopyportion,nogenerateportion

AutoPatch will not execute the following actions in your patch driver file
because you requested this using the keyword argument 'options='.

libout
copy
forcecopy
jcopy
genform
libin
link
genrep
genrpll
genfpll
genmenu
genmesg
genwfmsg
makedir
gengpll
genogd

Do you want to run AutoPatch with these actions turned off [Yes] ? <Enter>
... 

NOTE: This patch take a lot of time to be applied. On a P4 could take more than 24 hours to apply this patch. Also, if some pre-upgrade product patch are not applied that could make the u4440000.drv to generate errors. 

10. Run the NLS update patch driver if needed.

11. Apply the latest product patches (for the new R12 )

12. Apply the latest NLS product patches (for the new R12 ) if needed

13. Disable Maintenance Mode

14. Reset init.ora parameters

15. Backup Oracle Applications