Contact Premier Online Trainings Today

Oracle Apps DBA - How to upgrade Oracle E-Business Suite R12.1.1 to 12.1.3

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

How to upgrade  Oracle E-Business Suite R12.1.1 to 12.1.3

-  Shutdown the database and apps tier and take a cold backup of both Tiers.

- Change at initSID.ora or spfile the database parameters.
_disable_fast_validate=TRUE  (This is a conditional step)
recyclebin=off
or
Start the database and listener
alter system set "_disable_fast_validate" = TRUE scope = spfile;  (This is a conditional step)
alter system set recyclebin = off scope = spfile;
 
- Upgrade Applications to 12.1.3. You have to download the below patches
9239089
9239090
9817770
9966055
9239095
 
Patch location - /soft/1213/app
 
-- stop the application
 
Enable maintenance mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=8
 
-- 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 APPS
 
Apply the patches
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
 
 
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
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
 
- start the serices and check the URL
cd $ADMIN_SCRIPTS_HOME
sh adopmnctl.sh startall
 

Reference document

Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]
Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1]
Database Initialization Parameters for Oracle Applications Release 12 [ID 396009.1]