Hi everybody, recently I have made complete iteration from fresh PROD 11i instance to R12.1.1 with database 11.2.0.2
I have used VMware for this iteration, the following step involved to achieve this upgrade from 11i to R12.1.1
OS – OEL 4.6
Memory 3GB
Instance 11i CU2
Database 9.2.0.6
Memory 3GB
Instance 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 upgrade 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
Very detailed step-by-step notes with screen shot also prepared along with this iteration, if anybody looking for this iteration material or VMware copy don’t forget to drop me mail.
Cheers!!!
