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