Monday 24 January 2011

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!!!
SocialTwist Tell-a-Friend

Wednesday 19 January 2011

How to check if the Workflow Mailer is Running?

There are situations whether the Workflow Standalone Mailer processes are up & running without logging to the Application. Just follow the steps below

1. opmnctl status

2. Check the component container
ps -ef | grep OC4J_SECURITY

3. Is Java Mailer running ?
ps -ef | grep Service_Component_Container

or

SQL> select SC.COMPONENT_TYPE, SC.COMPONENT_NAME,
FND_SVC_COMPONENT.Get_Component_Status(SC.COMPONENT_NAME) COMPONENT_STATUS
from FND_SVC_COMPONENTS SC
order by 1, 2;


Cheers!!!
SocialTwist Tell-a-Friend