Tuesday, July 19, 2011

Oracle Apps 12.1.3 upgrade post upgrade steps for Oracle E-Business Suite Integrated SOA Gateway:

Oracle Apps 12.1.3 upgrade post upgrade steps for Oracle E-Business Suite Integrated SOA Gateway:

If you have upgraded the applications to 12.1.3 and you have SOA gateway integrated with EBSO, The below steps are mandatory to perform.

0)Techstack Upgrade

The Minimum patch set for Applications Server required for SOA is 10.1.3.5.0
A)upgrade your system to Oracle10g Application Server Patch Set 5 (10.1.3.5.0).

i)Apply the latest opatch
- cd $IAS_ORACLE_HOME
- mv OPatch OPatch_old

- unzip -d $IAS_ORACLE_HOME /tmp/p6880880_101000_LINUX.zip (Download the patch from support.oracle.com)
- chmod -R 755 OPatch
- $IAS_ORACLE_HOME/OPatch/opatch version
- OPatch Version: 1.0.0.0.63

ii)Install 10.1.3.5 Patchset 8626084
- Source the env file under $INST_TOP/ora/10.1.3

- cd $INST_TOP/ora/10.1.3
- . ./$CONTEXT_NAME.env
- uname -i
- If it is a 64-bit OS (x86_64) then do the following
- linux32 ksh
- uname –i
- It should give i386

iii)Verify the inventory and ensure it has proper values

iv)Invoke the runInstaller from VNC
- cd /patches/8626084/Disk1
- ./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc
- Screen 1) Select the 1013 ORACLE_HOME from the drop down list
- Screen 2) Provide the oc4jadmin password

- Complete the upgrade

Command to check version After the Upgrade:
- $ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|Patch of Oracle Application Server 10g'

B)Verify the 10.1.2.X  Oracle Home version and the required version is 10.1.2.3:

Example:
$ORACLE_HOME/OPatch/opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc | egrep 'Oracle Application Server 10g|Patch of Oracle Application Server 10g'
Oracle Application Server 10g                                    10.1.2.0.2
Patch of Oracle Application Server 10g                           10.1.2.3.0


1)Source the file $INST_TOP/ora/10.1.3/.env and then apply the following patches to the Oracle10g
Application Server 10.1.3.5 Oracle Home using opatch:

- Source the env file under $INST_TOP/ora/10.1.3
- cd $INST_TOP/ora/10.1.3
- . ./$CONTEXT_NAME.env

Apply the below techstack patches using opatch
- 9435187
- 9371120
- 9668283
- 7366746


2)Configuring Oracle E-Business Suite Integrated SOA Gateway Release 12.1.3

A)Apply the following Oracle E-Business Suite patch:

i) 9668283

- unzip p9668283_10135_GENERIC.zip
- cd $INST_TOP/ora/10.1.3
- . ./$CONTEXT_NAME.env
- cd 9668283
- opatch apply

ii) 9905881
Apply the above patch 9905881 using adpatch

B)Follow the configuration steps from Step 2 to Step 11 described in the section 3.3 Configuring
Oracle E-Business Suite Integrated SOA Gateway Release 12.1.2 to enable Oracle E-Business Suite Integrated SOA Gateway Release 12.1.3. 

i)Set applications environment and stop all application tier processes.

- From the applications instance $APPL_TOP, set the environment by running the APPS<CONTEXT_NAME>.env script
- Stop all application tier processes for the instance by running the script $ADMIN_SCRIPTS_HOME/adstpall

ii)Run TXK development script to install Oracle Application Server Adapter for Oracle Applications as shown below:

- $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp -applicationname=pcapps -oracleinternal=Yes  - oc4jpass=welcome12 -runautoconfig=No

Note: If the 'oc4jadmin' password for the OAFM oc4j instance is not known, then reset the password in the file  
 $INST_TOP/ora/10.1.3/j2ee/oafm/config/system-jazn-data.xml before running the script. Take the backup of system-jazn-data.xml before resetting the password.
 Replace the modified system-jazn-data.xml with backup of system-jazn-data.xml after running the script.


        For example, if you want to reset the password to 'welcome12', below should be the entry:

              <user>
                  <name>oc4jadmin</name>
                  <display-name>OC4J Administrator</display-name>
                  <guid>23C8E4F0BDDE11DCBFB8AF3B7E0DDB2D</guid>
                  <description>OC4J Administrator</description>
                  <credentials>!welcome12</credentials>
              </user>

iii)Run TXK deployment script to install forms-c4ws.ear and configure container Forms-c4ws J2EE group correctly, as shown below:
- $FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws

iv)Enable the new container forms-c4ws. (By default, the new OC4J container forms-c4ws will be disabled.)

- To enable the new container forms-c4ws, modify the following values of context variables in the $CONTEXT_FILE:
- Set 's_forms-c4wsstatus' to "enabled".
- Set 's_forms-c4ws_nprocs' to "1".

v)Run AutoConfig on MT Node

vi)Start all application tier processes for the instance by running the script $ADMIN_SCRIPTS_HOME/adstrtal

vii)Enable ASADMIN user using the following steps:

         1. Log on to Oracle E-Business Suite using sysadmin/sysadmin.
         2. Select the User Management responsibility in the Navigator.
         3. Click the Users link from the navigation menu to open the User Maintenance window.
         4. Locate 'ASADMIN' user by entering information in the search area to retrieve the 'ASADMIN' user.
         5. Click the Update icon next to the ASADMIN user to open the Update User window.
         6. Remove the Active To date field and click Apply.
         7. Click the Reset Password icon next to the ASADMIN user to open the Reset Password window.
         8. Enter new password twice and click Submit.


viii)After activating the ASADMIN user, verify if the ASADMIN user has the 'Apps Schema Connect Role' (UMX|APPS_SCHEMA_CONNECT) role in wf_user_roles.

- If the 'Apps Schema Connect Role' role is not present in the wf_user_roles for the ASADMIN user, then run the 'Workflow Directory Services User/Role Validation' concurrent program to grant the role.
ix)Reset the 'ASADMIN' password in the file system.

 After 'ASADMIN' user is enabled from Oracle E-Business Suite, update the file

 $INST_TOP/ora/10.1.3/j2ee/oafm/config/system-jazn-data.xml as shown below to reset the password:

 <user>
 <name>ASADMIN</name>

 <display-name>Default Apps SOA User</display-name>
 <description>Used by SOAProvider for DB connection</description>
 <credentials>!<NEW PASSWORD></credentials>
 </user>

3)Bring up all the services and perform complete health check

4 comments:

  1. hi
    this is one of the great blog i have ever seen...thanks for giving such a good source

    oracle fussion middleware

    ReplyDelete
  2. HI
    This is one of the best source for improve our knowledge in oracle apps thanks for providing such useful information
    Oracle Apps Online Tutorial

    ReplyDelete
  3. A prospects contract or basically fates is an institutionalized contract to purchase or offer a certain hidden resource at a certain date later on, at a predefined cost. Thanks for sharing about oas app.

    ReplyDelete
  4. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete