Upgrade Oracle Applications 11i Database to 10g R2 (10.2.0.3)

Step by Step Upgrade Oracle Applications 11i Database to 10g R2 (10.2.0.3)

In this post I’m going to describe step-by-step how to upgrade an Oracle Apps 11i Database 9i (9.2.0.6) to 10g R2 (10.2.0.3).
The upgrade was done on a single node environment installed on Red Hat Linux 4.

Technical information: OS: RHL4
Apps version: 11.5.10.2
DB version: 9.2.0.6
ATG Rup 5 + AD.I.5

*** The following upgrade process suitable to the above starting point only!
*** For another OS or Apps version you can be helped by this post, but it's highly
*** recommended to read the related Notes mentions at the end of this post.
1) Apply patch 4653225 - 10g release 2 ineroperability patch for 11.5.10 a. Unzip patch file
b. Cd 4653225
c. Run adpatch.sh

2) Upgrade Developer 6i to the latest patch set If your patch set level is earlier then patch set 17, you should apply the latest certified patch set (nowadays – 18).
You can use my previous post (step-by-step style) – “Upgrading Developer 6i with Oracle Apps 11i”.
And Metalink Note 125767.1 – “Upgrading Developer 6i with Oracle Applications 11i”.

3) Install 10g software a. mkdir [rdbms_oracle_home] for the new 10g software (/oracle/tst10db/10.2)
b. Export ORACLE_HOME=[rdbms_oracle_home]
c. Unzip installation file - 10201_database_linux32.zip
d. cd database
e. Execute runInstaller with oracle user
f. Select Advanced Installation

g. Inventory directory location: /oracle/tst10db/10.2/oraInventory


h. Select Installation Type: “Enterprise Edition”


i. Home Details:
Name: OraDB10g_home
Path: /oracle/tst10db/10.2


j. Fix all errors if exists


k. Choose to Install Database Software only
l. Click on install


m. Run the following scripts with root


n. Exit

4) Install Oracle Database products from Oracle 10g Companion CD a. Export ORACLE_HOME=[RDBMS_ORACLE_HOME]
b. Unzip installation file - 10201_companion_linux32.zip
c. cd companion
d. Execute runInstaller with oracle user


e. Select Oracle Database Products 10.2.0.1.0


f. Name and Path like database software installation.
Name: OraDB10g_home
Path: /oracle/tst10db/10.2


g. Fix errors if exists


h. Click on Install

i. Exit


5) Install 10.2.0.3 patch set
a. Export ORACLE_HOME=/oracle/tst10db/10.2
b. Export ORACLE_SID=tst10
c. unzip installation file - p5337014_10203_LINUX.zip
d. cd Disk1
e. Execute runInstaller with oracle user


f. Name and Path like in database installation
Name: OraDB10g_home
Path: /oracle/tst10db/10.2


g. Click on Install

h. Run root.sh

i. Exit installation


6) Create nls/data/9idata directory
a. Execute: perl $ORACLE_HOME/nls/data/old/cr9idata.pl
b. export ORACLE_HOME=/oracle/tst10db/10.2
c. export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

7) Install 10g Listener a. Stop 9i listener
b. Export ORACLE_HOME=/oracle/tst10db/10.2
c. cd $ORACLE_HOME/bin
d. execute ./netca (Network Configuration Assitant)
e. Name the listener TST10

8) Database Upgrade a. Export ORACLE_HOME=/oracle/tst10/10.2
b. Export ORACLE_SID=tst10
c. cp /oracle/tst10/10.2/rdbms/admin/utlu102i.sql /tmp
d. cd /tmp
e. sqlplus “/as sysdba”
i. startup db
ii. spool info.log
iii. run $utlu102i.sql
iv. spool off
f. Check info.log for any errors
g. Add to initTST10.ora -> local_listener =’(ADDRESS= (PROTOCOL= TCP)(Host= servername.domain)(Port= 1521))’
h. Execute the Database Upgrade Assistant - $ORACLE_HOME/bin/dbua


i. Select the db to upgrade


j. SYSAUX tablespace should be on: /oracle/tst10data/sysaux01.dbf
Choose Automatically extend datafile when full (AUTOEXTEND).



k. It is strongly recommended to have a full cold backup of the database before upgrade.
You can choose to make the cold backup at this stage.



l. Enter passwords for system users.


m. Click on Finish


n. Check status of all upgraded components.


o. Close

9) Modify initialization parameters Follow Metalink note 216205.1 - Database Initialization Parameters for Oracle Applications 11i.
Section 2.4 - Release-specific database initialization parameters for 10gR2 (10.2.X) + Removal list 10gR2 (10.2.X).

10) Fix Korean lexers
a. Connect to sqlplus as sysdba
b. execute $ORACLE_HOME/ctx/sample/script/drkorean.sql

11) Run adgrants.sql a. Connect to sqlplus as sysdba
b. Execute @$APPL_TOP/admin/adgrants.sql APPLSYS

12) Grant create procedure privilege on CTXSYS a. Connect to sqlplus with apps
b. Execute @$AD_TOP/patch/115/sql/adctxprv [SYSTEM_PASSWORD] CTXSYS

13) Run Autoconfig on DB Tier and Application Tier a. Log in to server with applmgr user
b. source /oracle/tst10appl/[context_name].env
c. perl $AD_TOP/bin/admkappsutil.pl
d. cp $APPL_TOP/admin/out/appsutil.zip /oracle/tst10db/10.2
e. Login to server with oracle user
f. cd /oracle/tst10db/10.2
g. unzip –o appsutil.zip
h. Copy the old database context file from 9.2.0 to 10.2
i. cd /oracle/livedb/10.2/appsutil/bin
j. Execute ./adconfig.sh
k. Login to server with applmgr user
l. Run autoconfig on application Tier

14) Gather Statistics for SYS schema a. sqlplus “/as sysdba”
b. shutdown immediate
c. startup restrict
d. @/oracle/tst10appl/admin/adstats.sql
e. shutdown
f. startup

15) Recreate grants and synonym for apps a. Log in to server with applmgr user
b. Execute adadmin
c. Choose -> Maintain Applications Database Entities menu
d. Choose -> Re-create grants and synonyms for APPS schema

16) Apply Oracle receivables patch (5753621) a. unzip patch file
b. cd 5753621
c. run adpatch