1.Pre-requisite checks:
a.Check whether the given patch number is applied before using below query.It will show the bug number if applied before.
select bug_number from ad_bugs where bug_number='9488727';
b.check count of objects INVALID. The count of invalids should go down after applying patches.
select count(*) from dba_objects where status='INVALID';
2. If not, then download the patch from support.oracle.com.see below.
Go to Tab "Patches & Updates" and enter patch number need to apply and search it.
3.The things need to keep in mind in selecting Patch are the patch number,Release,Platform,size and the date updated.Get release by using below query.
SQL>select release_name from fnd_product_groups;
4. Just click on to that Patch number and go to "Read me". Check if there are any pre-requisite and post-requisite steps.Then download it and save it in application (target)node patch directory.
5. Check whether the Maintenance mode is enable or not. To check use below query.
select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
6. Using below command ,put database in maintenance mode.
$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
7. Unzip the patch and stop the application services below.
./adacmctl.sh stop apps/appspwd
./adstpall.sh apps/password
8. Using below command, can able to see any services running behind.
ps -ef|grep applmgr
To kill---kill -9 `ps -ef|grep FND |awk '{print $2}'`
9. Connect sqlplus as apps user.Run cmclean in CM(Primary) node.
10. Go to that patch directory 9488727 and apply adpatch.It will prompt logfile name(9488727.log) and .drv file name(u9488727.drv).
11. Once completed successfully. Start all the application services
./adstrtal.sh apps/appspwd
12. We need to check again that the patch is applied and the invalids now.The Invalids should be lesser than what we got before applying patch.
13. Check all the concurrent managers are up and running.Submit Active users and make sure it is completing normally.
Thanks,
Azarudeen.
No comments:
Post a Comment