Author – A.
Kishore
[Link]
Upgrade Oracle Applications from R12.1.1 to R12.1.2
Reference Note - Oracle E-Business Suite Readme, Release 12.1.2 (Doc ID 949406.1)
1> Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade (Doc ID 761570.1)
The minimum required database version should be [Link], R12.1.1 comes with [Link]
Test - Passed
2> Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12 (Doc
ID 454811.1)
The minimum required version of OracleAS 10g should be [Link], R12.1.1 comes with [Link]
[applmgr12@linux1 ~]$ grep "ias_version" $CONTEXT_FILE
<ias_version oa_var="s_ias_version">[Link].0</ias_version>
Test - Passed
3> Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)
The minimum required version of OracleAS 10g Forms and Reports should be [Link].0, R12.1.1 comes
with [Link]
[applmgr12@linux1 ~]$ grep "forms_version" $CONTEXT_FILE
<forms_version oa_var="s_forms_version">[Link].0</forms_version>
Test - Passed
Author – [Link]
[Link]
4> Below patches/steps are required to upgrade from R12.1.1 to R12.1.2
- Use AutoPatch to apply [Link].2 Patch 8502056
- Use AutoPatch to apply Release 12.1.2 Patch 7303033 – Patch size is 3.2 GB ☺
- Use AutoPatch to apply the latest consolidated online help Patch 7303032
- Post-Update Steps
5> Use AutoPatch to apply [Link].2 Patch 8502056
The readme says to run [Link] (Patch application assistant)
Author – [Link]
[Link]
Patch Location - /d01/oracle/R1212/8502056
Author – [Link]
[Link]
Author – [Link]
[Link]
-- stop the services
su - applmgr12
cd $ADMIN_SCRIPTS_HOME
sh [Link] apps/apps
-- Enable Maintenance Mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/[Link] logfile=[Link]
menu_option=ENABLE_MAINT_MODE workers=4
export PATCH_TOP=/d01/oracle/R1212
Create $ORACLE_HOME/appsutil/admin on the database server.
su – oracle12
cd $ORACLE_HOME/appsutil
Author – [Link]
[Link]
mkdir admin
Copy [Link] (UNIX) from this patch directory to
cd $ORACLE_HOME/appsutil/admin
cp $APPL_TOP/admin/[Link] .
sqlplus "/as sysdba" @[Link] APPS
-- Apply patch 8502056 in non interactive mode
-- Takes 30 minutes
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/[Link] logfile=[Link]
patchtop=$PATCH_TOP/8502056 driver=[Link] workers=4
5> Use AutoPatch to apply Release 12.1.2 Patch 7303033 – Took 18 hours ☺
Run [Link] as per the readme file
Author – [Link]
[Link]
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/[Link] logfile=[Link]
patchtop=$PATCH_TOP/7303033 driver=[Link] workers=4
Issue 1>
I told Yes and continued with patch
grep 'Error' [Link]
make: *** [/d02/oracle/PROD/apps/apps_st/appl/msc/12.0.0/bin/MSCCPP] Error 1
Solution -
Relink Error On All MSC Executables On Oracle Enterprise Linux (OEL) 5.x/Red Hat Linux (RHEL) 5.x (Doc ID
758831.1)
The below link from [Link] has given me the clue.
[Link]
You should follow the instructions in Metalink note 758831.1.
I had a similar problem while patching from 12.1.1 to 12.1.2, all of the MSC... files would not relink. I had to reinstall the binutils library and
all went well.
It might work for you too (I'm running OEL 5 64bit)
Read the whole note but since I already downloaded and installed those packages as part of the initial install I just needed to reinstall this
one
rpm -U binutils-[Link].6-6.0.1.el5.x86_64.rpm
Author – [Link]
[Link]
Issue 2>
/d02/oracle/PROD/apps/apps_st/appl/cs/12.0.0/patch/115/sql/[Link]
CREATE OR REPLACE PACKAGE CS_ServiceRequest_UTIL AUTHID CURRENT_USER
Unable to process file in PACKAGE mode.
AD Worker error:
ORA-00060: deadlock detected while waiting for resource
Solution – I executed the [Link] manually and there was no issue
sqlplus apps/apps @/d02/oracle/PROD/apps/apps_st/appl/cs/12.0.0/patch/115/sql/[Link]
I have restarted the failed worker using adctrl
Issue 3> Few pll/fmx have failed to compile
Author – [Link]
[Link]
I told Yes and continued with the patch and then manually generated the plls/fmx files using adadmin,
the issue got resolved.
3> Use AutoPatch to apply the latest consolidated online help Patch 7303032
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/[Link] logfile=[Link]
patchtop=$PATCH_TOP/7303032 driver=[Link] workers=4
Post-Update Steps
Update database tier nodes with the Release 12.1.2 code level.
After you have upgraded to Release 12.1.2, perform the following post-update steps to update all
database tier nodes with the code level, provided by Release 12.1.2:
Application tier:
As the APPLMGR user, run the environment (UNIX) or the command (WINDOWS) file for the current
APPL_TOP.
UNIX
. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env
Run the [Link] utility to create the file [Link] in the <INST_TOP>/admin/out directory.
perl <AD_TOP>/bin/[Link]
As the ORACLE user, run the environment (UNIX) or the command (WINDOWS) file for the current
ORACLE_HOME.
UNIX
cd <RDBMS ORACLE_HOME>
. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env
Copy or FTP the [Link] file to the <RDBMS ORACLE_HOME>.
Uncompress [Link] under the <RDBMS ORACLE_HOME>.
cd <ORACLE_HOME>
mv appsutil appsutil_old
Author – [Link]
[Link]
unzip -o [Link]
Run AutoConfig on the <RDBMS ORACLE_HOME>.
perl [Link] appsuser=apps appspass=apps
Below is the error
JRE_TOP or java executable not found at its desired location /d02/oracle/PROD/db
/tech_st/11.1.0/appsutil/jre, /d02/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java
Solution :
Copy the jre from appsutil_old
cd $ORACLE_HOME/appsutil_old
cp -R jre /d02/oracle/PROD/db/tech_st/11.1.0/appsutil
perl [Link] appsuser=apps appspass=apps
The context file has been created at:
/d02/oracle/PROD/db/tech_st/11.1.0/appsutil/ PROD_linux1.xml
n Run autoconfig
cd /d02/oracle/PROD/db/tech_st/11.1.0/appsutil/bin
sh [Link]
Enter the full path to the Context file: /d02/oracle/PROD/db/tech_st/11.1.0/appsutil/ PROD_linux1.xml
Enter the APPS user password:
Database tier and application tier:
Re-run [Link] on the database tier and the application tier. Since updates included in RUP6 were
applied to the system, adpreclone must be run again to apply the updates to the clone directory
structures that were used during cloning.
perl [Link] dbTier
perl [Link] appsTier
Author – [Link]
[Link]
n Disable the maintenance mode
adadmin menu_option=DISABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin
/$TWO_TASK/[Link] logfile=adadmin_DISABLE_MAINT_MODE.log
n Start the services
cd $ADMIN_SCRIPTS_HOME
sh [Link] apps/apps
Final check - Check whether the update is done or not from backend
Author – [Link]
[Link]
Check whether application is running from frontend