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

Related Posts by Categories