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