Pages

Monday, 3 November 2014

Applying Patch 14069503 using ADpatch in R12

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%';
++ 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