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
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:
Post a Comment