Sunday, 31 January 2016

How to Check Patch Applied Status in Oracle Applications?

R11i,12.0.x,12.1.x
=============

From Oracle Applications Release 11i to 12.1.x, Patch application Status can be queried from ad_bugs or ad_applied_patches tables

Query to check whether patch is applied on a instance.

SQL>select bug_number,creation_date,last_update_date from apps.ad_bugs where bug_number='&patchnum';

SQL> select PATCH_NAME,CREATION_DATE from apps.ad_applied_patches where PATCH_NAME='&patchnum';

What is difference between above two Queries?


Suppose, we applied a patch which has multiple bugfixes.The details of all bugs fixed by the patch are listed in ad_bugs table.
In Contrast,ad_applied_patches table give info only about the patches which are applied through adpatch utility.


R12.2
=====

From Release 12.2, Online Patching utility(adop) is used for Patching application Filesystem.

Querying the data from ad_bugs or ad_applied_patches tables may not give correct information.Because, online patching can be aborted anytime prior to Cutover Phase.
ad_bugs or ad_applied_patches tables may contain entries for patches which are started through adop and later aborted.

The below query gives accurate Information about Patch Applied Status in R12.2

select AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;

example sql:
SELECT adb.bug_number,ad_patch.is_patch_applied('11i', 1045, adb.bug_number)
FROM ad_bugs adb
WHERE adb.bug_number in (22498647);

or for single app tier installations:
select ad_patch.is_patch_applied('R12',-1,22498647) from dual;

Sample Output:

EXPLICIT = applied
NOT APPLIED = not applied / aborted


Database
=========

Login to Database node as the database os user

Set environment using commands below

$export ORACLE_HOME=/u01/app/oracle/product/112

$export PATH=$PATH:$ORACLE_HOME/Opatch

$which opatch
==>It should give output like /u01/app/oracle/product/112/Opatch

$opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc

== This gives list of all patches applied to the ORACLE_HOME


$opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc|grep 988765


==> To check if a particular patch is applied to the ORACLE_HOME



11 comments:

  1. how to check for languages patches has been applied or not ?

    ReplyDelete
  2. These patches have from that point forward adorned outfits the world over; they have been gladly worn by military work force just as increased a continuing in the regular citizen network as an authority's thing. check this out

    ReplyDelete
  3. There were various styles accessible in the dresses both for people. Ladies' Renaissance clothes incorporates easier pieces, for example, underskirts, robes, to more dynamic and complex clothing that included skirts, bodices, over-bodices, circles, collars and so on wear new

    ReplyDelete
  4. It consequently switches between paired patching and entire record patching on a document by-document premise to produces the littlest patch feasible for your venture. website

    ReplyDelete
  5. Doing as such makes a gigantic measure of Control focuses that will either be amazingly hard to alter or may crash your 3D Application completely. The most ideal approach to assemble patches is either from Patch surfaces or through the your 3D Application natives. b3 bomber jacket canada

    ReplyDelete
  6. Any actual boost to one side of your body will expand action in the right half of the globe of the cerebrum, and bad habit versa.8 Standing to your left side leg, for instance, animates R-mode movement, while remaining on your right leg will invigorates L-mode. cheap custom tailored mac coats

    ReplyDelete
  7. I visit some sites and sites everyday to read articles, however this website offers feature based posts. If you need a visa to enter Turkey, you may apply for a Turkish visa and fill the visa on arrival Turkey form. It is way easy and quick to get a Turkish e-Visa by following three simple steps.

    ReplyDelete
  8. Attractive component of the material. I just stumbled across your web site and accession capital to say that I really enjoyed your site. Fill the form with accurate and complete information about the traveler's data, passport details, date of travel and the type of visa they wish to obtain. Kenya e visa fees required to cover the expenses involved in the processing of the visa application.

    ReplyDelete
  9. Great blog! An article gives a lot of information... The Indian tourist e visa application system is fully online, it's fast and cheaper as compared to a sticker visa. If you have any doubt check the information.

    ReplyDelete
  10. Thanks for your blog.This is a nice blog. Hiii guys, if you are willing to travel in India, now India is open for tourism, you can travel in India. But without a visa you can never enter India. Firstly You can apply for an Indian visa & you can fill yourself online Indian visa application form within 5 to 10 minutes.

    ReplyDelete
  11. Thank you for your valuable and useful information through The blog. I am admiring the way you shared the relevant, precious, and perfect information. We provide cloud computing services, If you have any query related to cloud computing services then visit our website you will get complete information related to your query.

    ReplyDelete

Was this Post Helpful?

Feel free to suggest your opinions in the comments section!