Monday, June 21, 2010

Tasks and Phases to Upgrade Oracle Applications 11i to r12 (12.1.1)

Last month I was busy in upgrading Oracle Applications 11i (11.5.10.2) to release 12 (12.1.1) with 64 bit 11g (11.1.0.7) database. The following were the main tasks and phases with which the upgrade project was done. For rough detailed steps for the upgrade please refer my post 'rough upgrade steps from 11i to r12 with db 11g'
TASK and Phases
Phase -1
Applying ATG RUP 6 patch and Converting to Multiorg
Baseline backup of the existing 9i database and Oracle 11i Application file system including windows registries
Disabling Batch jobs or any scheduled Database jobs .
Apply Pre-reqs patch 4252319
Apply ATG RUP 6 Patch 5903765
Apply ATG RUP 6 Transaltion Patch 5903765
Apply Post Upgrade patch 4583125
Perform the Post upgrade steps
Converting to mutliorg
Apply the TUMS utility Patch 7705743

In case of failure time for restoration will be 3 hr




Phase -2
Oracle Database upgrade to 11gR1
Baseline backup of the existing 9i database and Oracle 11i Application file system including windows registries
Applying Oracle Database upgrade and baseline Pre-reqs on the Windows Server 2003
Performing Pre-upgrade Tasks on the existing 9i Database .
Copy the timezone dat file from the patch 5845928 and run utlu111i.sql
Disabling Batch jobs or any scheduled Database jobs .
Starting the Oracle Database upgrade from 9i to 11gR1 (11.1.0.7) .
Performing Post-upgrade Tasks on the upgraded 11gR1 Database .
enabling autoconfig standardize configuration management tasks in an Oracle Applications environment
Final Oracle 11gR1 Database backup .

In case of failure time for restoration will be 3 hr

Phase -3
R12 Upgrade
Baseline backup of the existing 11gR1 database and Oracle 11i Application file system including windows registries
Install and integrate the R12 filsystem with 11gr1 database
Apply the pre-reqs patches
Run the Upgrade Driver for R12
Apply the NLS upgrade driver
Migrate the customization

Phase -4
Database migration to 64 bit
Baseline backup of the existing 11gR1 database
Installation of Microsoft windows 64 bit
Migrate the Database to 64 Bit
Enable Autoconfig on New RDBMS home on 64 bit
Recreate the Grants and synonyms
Compile flexfields


In case of failure time for restoration will be 3 hr

No comments: