Step by step process 11i to R12.1.1

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

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!!!