Steps for Applying Patch 14069503 using ADpatch in R12
++ To check the patch is applied.
select * from ad_bugs where bug_number='14069503';
select decode(bug_number, 8919491, 'R12.ATG_PF.B.delta.3', 7651091, 'R12.ATG_PF.B.delta.2',null) from ad_bugs
where bug_number in (8919491,7651091)
and language = 'US';
select patch_level from fnd_product_installations where patch_level like 'R12%AD%';
where bug_number in (8919491,7651091)
and language = 'US';
select patch_level from fnd_product_installations where patch_level like 'R12%AD%';
++ After downloading the patch
++ Stop the application
++ Enable maintance mode > adadmin
++ Now apply the patch
adpatch
Control C
And start adpatch for giving correct logfile name with patch no.
Ignore
- To check workers status
Adctrl
8th option was hiden one to skip the worker.
2nd to restarted the faliled workers.
===Patch run for recompiling invalids
sqlplus -s APPS/***** @/u01/uat/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 4 0 NONE FALSE
select count(*),owner from dba_objects where status<>'VALID' group by owner;
++ Patch Log location:
cd $APPL_TOP/admin/UAT/log
tail -100f 14069503.log
Check the log file.
++Disable the maintance mode
++Check the logfiles
- Run patchsets.sh
Down load from
R11i / R12.0 / R12.1 / R12.2: Oracle Applications Current Patchset Comparison Utility - patchsets.sh (Doc ID 139684.1)
No comments:
Post a Comment