Thursday, April 25, 2013

ebs r12 upgrade 1og to 11gr2



OS Version:- OEL 4.6
Physical Memory:- 3GB
Application:- 11i CU2
Database:- 9.2.0.6

My VMware installation has been running on P5 processor with 4GB memory under Windows 7 (64 bits) machine.
Before starting this iteration, I have enabled multi-org. So please follow multi-org enabled procedure prior to this step. 

The following steps performed successfully to complete this hectic upgrade from 11i instance to R12.1.1

•      Upgrade 9.2.0.6 to 10.2.0.4
–     Patches applied before 10g upgrade are 5478710, 4676589, 4653225
–     Changed some of the OS kernel parameters
–     Created new oracle home directory
–     Installed 10gR1 (software only)
–     Installed 10gR1 companion CD
–     Installed 10g patch set 3 (10.2.0.4)
•      Configuration section for 10g
–     Created nls/data/9idata
–     Run the script cr9idata.pl
–     Copied environment file from 9i home to 10g home and made changes to reflect the directory structure of 10g home
–     Copied TNS_ADMIN directory from 9i to 10 home and made changes according to new home
–     Copies admin directory from 9i to 10g home and make necessary changes
–     Shutdown 9i database and listener
–     Startup 10g listener
–     Upgraded  9i to 10g using dbua from 10g home
•      Shutdown database and listener
•      Create temporary tablespace
•      Apply RDBMS Patches
•      Fix Korean Lexers
•      Run Adgrants.sql
•      Grant create procedure privilege on CTXSYS
•      Implement and run Autoconfig
•      Gather statistics for SYS schema
•      Recreate grants and synonym for apps
•      Restart application server process
•      Preparing for the Upgrade R12.1.1
–     Apply AD.I.6
–     Apply TUMS utility
–     Run AD preparation scripts
Backup database and applications
•      Startup 11i Instance
•      Check for Invalid Objects etc...
•      Create R12 application user
•      Create R12 Base folder
•      OS  Kernel setting etc
•      (Refer Metalink: 761564.1  - Oracle E-Business Suite Installation and Upgrade Notes R12.1.1 for Linux x86)
•      Installation of R12.1.1 applications
•      Enable maintenance mode in R12
•      Apply AD 12.1.1 upgrade driver (7461070)
•      Source the R12 Applications environment file
•      Run the Patch Application Assistant
•      Run the adgrants.sql
•      Apply patch
•      Re-Create grants and Synonyms
•      Compile APPS schema
•      Modify tablespace
•      Run the American English upgrade patch driver 6678700
•      Review patch history and timing
•      Install R12.1.1 again for configuration purpose
•       Startup / shutdown applications and database
•       Try with autoconfig in both tiers
•       Restart services
•       
    Upgrade 10.2.0.4 to 11.2.0.2
•      Patches applied before 11gR2 upgrades are 9062910, 8919489, 9868229, 10024524
•      Autoconfig latest version with 9852070 and 9738085
•      OS kernel parameters for 11gR2
•      
       Created new oracle home directory

     Installed 11gR2 (software only)
•      Installed 11g Examples CD
•       Configuration section for 11gR2
•      Created nls/data/9idata
•      Run the script cr9idata.pl
•      Copied environment file from 10g home to 11g home and made changes to reflect the directory structure of 11g home
•      Copied TNS_ADMIN directory from 10g to 11g home and made changes according to new home
•      Copies admin directory from 10g to 11g home and make necessary changes
•      Apply 11.2.0.2 RDBMS Patches – 4247037 and 10149223
•      Shutdown 10g database and listener
•      Startup 11g listener
•      Run  DBUA
•      Perform post-install instructions
•      Run adgrants.sql
•      Grant create procedure privilege on CTXSYS
•      Set CTXSYS parameter
•      Validate Workflow ruleset
•      Implement and run AutoConfig in the new Oracle home on the database server node.
•      Gather statistics for SYS schema
•      Re-create grants and synonyms
•      Restart Applications server processes
•      Synchronize Workflow views

No comments:

Post a Comment