Installation


Step by step process 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


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Comments