To Upgrade Oracle EBS R12.1.1 To R12.1.3 Follow the Below Steps :
From https://support.oracle.com you have to download the following patch :
- p9239090_R12_LINUX_1of6.zip
- p9239090_R12_LINUX_2of6.zip
- p9239090_R12_LINUX_3of6.zip
- p9239090_R12_LINUX_4of6.zip
- p9239090_R12_LINUX_5of6.zip
- p9239090_R12_LINUX_6of6.zip
- p9239095_R12_GENERIC.zip
- p9822544_R12.MSC.B_R12_GENERIC.zip(Optional)
- p10349415_R12.AD.B_R12_GENERIC.zip (Optional)
- p9239089_R12.AD.B_R12_LINUX.zip
Before Start Working You have to shutdown all application Services using ( adstpall.sh ) and enable maintenance mode using adadmin
Run the Patch in Order like the following, before apply Any Patch you need to check README.txt for any Pre-Install Step/Post-Install Step
1- Start with patch Number 9239089 , before do that on Readme.txt you have to do the below :
-Open Two Session ( Terminal ) Run Apps Env On Terminal #1, Terminal #2 run database Env.
-On DB Terminal Create under $ORACLE_HOME/Appsutil/admin
-Copy adgrants.sql (Unix) from patch folder to Above folder.
-From $ORACLE_HOME/appsutil/admin Run adgrants.sql
-sqlplus /nolog
-SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
2-Apply Patch 10349415
3-Apply Patch 9239090
4-Apply Patch 9239095
5-Apply patch 9822544
6-Apply Patch 9817770
7-Apply Patch 9966055
After you Applied all the above patch Do the below steps :
On Application Tier :
- Run Autoconfig ( Which is Located $ADMIN_SCRIPT_HOME )
- Run the admkappsutil.pl ( Located in $AD_TOP/bin/admkappustil.pl ) Using the below command
perl /bin/admkappsutil.pl
This will generate new appsutil.zip located in $INST_TOP/admin/out
On Database Tier :
Copy appsutil from Application tier to $ORACLE_HOME,Unzip in under $ORACLE_HOME Like the below
- cd $ORACLE_HOME
- unzip appsutil.zip
- Run autoconfig for Database Tier located in ( $ORACLE_HOME/appsutil/admin) –> adauto.sh
Finally two more simple step, you need to run adpreclone on Database Tier & application Tier using the below command :
- perl adpreclone.pl dbTier (located in $ORACLE_HOME/appsutil/admin)
- perl adpreclone.pl appsTier (Located in $ADMIN_SCRIPT_HOME)
Disable Maintenance mode now.
Sqlplus apps/***
SQL> select release_name from fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.3
Start Application Services using ( adstrtall.sh )
Thank you
Osama mustafa