Contact Premier Online Trainings Today

Oracle Apps DBA - Upgrade E-Business Suite from R12.1.1 to R12.1.3 steps

Date Added: 18 Nov.2019 Date Updated: 22 Dec.2019 Oracle Apps DBA Full Blog

Upgrade Oracle E-Business Suite from R12.1.1 to R12.1.3 steps

After Installation of Oracle Applications R12.1.1,I have upgraded to R12.1.3 Successfully in my Servers. The following patches are required and download from the Oracle Support as per their environment..

Downlod the below patch and copy to the patchtop location.

Required patches:

9239089
9239090
9239095
9817770
9966055
 
Patch location - /soft/1213/app/
 
-- stop the application services
 
-- copy the adgrants.sql from the patch 9239089 to the database server
 
$cd /soft/1213/app//9239089/admin
ls adgrants.sql
 
On the database server
sqlplus "/as sysdba" @adgrants.sql APPS
 
$adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=8
 
$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239089.log patchtop=/soft/1213/app/9239089 driver=u9239089.drv workers=8
 
 
$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239090.log patchtop=/soft/1213/app/9239090 driver=u9239090.drv workers=8
 
 
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.3
 
$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239095.log patchtop=/soft/1213/app/9239095 driver=u9239095.drv workers=8
 
$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9817770.log patchtop=/soft/1213/app/9817770 driver=u9817770.drv workers=8
 
$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9966055.log patchtop=/soft/1213/app/9966055 driver=u9966055.drv workers=8
 
 
- Run the admkappsutil.pl utility to create the file appsutil.zip in the /admin/out directory. 
 
perl $AD_TOP/bin/admkappsutil.pl
cd <RDBMS ORACLE_HOME>
. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env
 
• Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>.
• Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>.
cd <ORACLE_HOME>
unzip -o appsutil.zip
 
Run AutoConfig on the <RDBMS ORACLE_HOME>.
perl $ORACLE_HOME/appsutil/bin/adbldxml.pl
cd $ORACLE_HOME/appsutil/bin/
sh adconfig.sh
 
- Run adpreclone.pl on the database tier and the application tier
perl adpreclone.pl dbTier
perl adpreclone.pl appsTier
 
- Disable Maintenance Mode
$adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=DISABLE_MAINT_MODE workers=8
 
 
Reference doc:
Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)