UPGRADE DATABASE 9.2.0.5 TO 10.1.0.3 WITH 11.5.9

Oracle Applications Release 11i with Oracle Database 10g Release 1 (10.1.0)
Doc ID: Note:282038.1
--------------------------------------------------------------------------------
Minimum Req:-
a.Oracle Applications 11.5.9 CU2.
b.Developer 6i Patch set 12.
c.AutoConfig Latest version
--------------------------------------------------------------------------------
Steps:-

1.Patch 3129264 INTEROP PATCH FOR 10.1.0 on 11.5.9 version of Apps.

2.P4337683_11i_TRU64
Minipack 11i.AD.I.2

3. Fresh installation of 10.1.0.2 and apply 10.1.0.3 patch.

4. Create nls/data/9idata directory
Install 10g Listener

5. Apply latest Oracle Patching Tool (OPatch) 2617419

6. Shut down Applications server processes and database listener

7. Database Upgrade Assistant (DBUA). Execute the Database Upgrade Assistant - $ORACLE_HOME/bin/dbua

8. Invalid object compilation ( Min 3 to 4 hours)

9. Modify initialization parameters

10. Run adgrants.sql
sys as sysdba
@$APPL_TOP/admin/adgrants.sql APPLSYS

11. Connect to sqlplus with apps
@$AD_TOP/patch/115/sql/adctxprv CTXSYS

12. perl $AD_TOP/bin/admkappsutil.pl
cp appsutil.zip to New Oracle_home
unzip -o appsutil.zip
perl adbldxml.pl tier=db appsuser=apps appspass=apps
run autoconfig

13. Gather sys statistics
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict;
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1264892 bytes
Variable Size 415236868 bytes
Database Buffers 645922816 bytes
Redo Buffers 11317248 bytes
Database mounted.
Database opened.
SQL> @/appl/prodappl/admin/adstats.sql
Connected.
-----------------------------------------------------
adstats.sql started at 2006-12-28 14:18:20
---
Checking for the DB version and collecting statistics ...
PL/SQL procedure successfully completed.

---------------------------------------------------
adstats.sql ended at 2006-12-28 15:10:41
---
Commit complete.

14.Re-create grants and synonyms using adadmin

15. Startup the services.