Upgrade 11i to R12.1.1



                   Step by step process 11i to R12.1.1


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

***************************************END********************************************

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...