In Oracle : Upgrading the Oracle Apps Middle tier to R12

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> R12

-> Upgrading the Oracle Apps Middle tier to R12

 

 Upgrading the Oracle Apps 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: Install the latest version of 11i.AD.I

 

 

2. Install the R12 software

Fore more details click here: Install the Oracle Applications R12 software.

 

 

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:

 

- download the patch in directory: in my case this is /home/applmgr/Desktop/PATCHES

cd /home/applmgr/Desktop/PATCHES/5726010

sqlplus <APPS username>/<APPS password> @adgncons.sql apps apps

 

sqlplus apps/apps @adgncons.sql apps apps

 

- Modify adcrtbsp.sql to reflect your current tablespace information. 

 

Example:

 

CREATE TABLESPACE INTERIM
DATAFILE '?/dbf/interim.dbf'
SIZE 200 M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
SEGMENT SPACE MANAGEMENT AUTO ;

will be:

 

CREATE TABLESPACE INTERIM
DATAFILE '/APPS_DB_R12/db/apps_st/data/interim.dbf'
SIZE 200 M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
SEGMENT SPACE MANAGEMENT AUTO ;

- Run adcrtbsp.sql, which is generated by adgncons.sql. 

 

sqlplus <SYSTEM>/<SYSTEM PASSWORD> @adcrtbsp.sql 

sqlplus system/manager @adcrtbsp.sql 

 

- Run the adgrants.sql script

 

1. Create $ORACLE_HOME/appsutil/admin on the database server (if is not done already) 

2. Copy adgrants.sql from this patch directory to $ORACLE_HOME/appsutil/admin. 

3. Set the environment to point to ORACLE_HOME on the database server. 

4. Use SQL*Plus to run the script: 

$ sqlplus /nolog 
SQL> connect / as sysdba 
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPLSYS schema name> 

 

sqlplus /nolog

connect / as sysdba 

@$ORACLE_HOME/appsutil/admin/adgrants.sql APPLSYS

 

 

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

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> R12

-> Upgrading the Oracle Apps Middle tier to R12

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.