24-july-2015(Friday) to 27 july 2015(Monday)
Upgrade 12.1.1 to 12.1.3 Application R12 ERP
Current version :-12.1.1
Download patch
1) p9239089_R12.AD.B_R12_LINUX.zip
2) p9239090_R12_LINUX_1of6.zip
3) p9817770_R12.ATG_PF.B_R12_LINUX.zip
4) p9966055_R12.FND.B_R12_GENERIC.zip
5) p9239095_R12_GENERIC.zip
Steps should be follow before upgrading.
1) Backup of oracle_home database Tier
2) Backup of APPL_TOP application Tier
3) Down the application
4) Check the invalid objects.
sqlplus / as sysdba
select count(*) from dba_objects where status='INVALID';
5) Keep application in Maintenance enable mode through adadmin
6) Check with all services are down must be check with ps -ef |grep FNDLIBR
If any service not down then kill from kill -9 PID
7) Go to the patch_Top where patch has been upzipped.
8) run adpatch
9) Apply Patch 9239089
10) -- pre install steps
11) Create $ORACLE_HOME/appsutil/admin on the database server.
12) mkdir -p $ORACLE_HOME/appsutil/admin
13) Copy adgrants.sql from this patch directory to
14) $ORACLE_HOME/appsutil/admin.
15) Set the environment to point to ORACLE_HOME on the database server.
16) Use SQL*Plus to run the script:
17) $ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
18) Apply patch 9239090 through adpatch applicaton node
19) Apply patch 9239090 through adpatch applicaton node
20) p9817770_R12.ATG_PF.B_R12_LINUX.zip
21) p9966055_R12.FND.B_R12_GENERIC.zip
22) p9239095_R12_GENERIC.zip
All patches should be applied as applied 1st patch.Before applying patch must be read
README.txt file.then follow the process as given in readme file.
All patch applied then check application version :- 12.1.3
