Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check if a patch has been applied to the database?

tammytApr 5 2016 — edited Apr 6 2016

All,

I upgraded my database to 12.1.0.2 and applied the patch 20831110.  The patch was successful, but it is not showing that it is upgraded to version 12.1.0.2.4.  I ran the the datapatch utility that you are supposed to run after the opatch apply, and this is what I see in dba_registry_sqlpatch.  What am I missing here?  Thanks.

% sqlplus /nolog

SQL> Connect / as sysdba

SQL> startup

SQL> quit

% cd $ORACLE_HOME/OPatch

% ./datapatch -verbose

  PATCH_ID VERSION              STATUS          BUNDLE_ID  BUNDLE_SERIES

---------- -------------------- --------------- ---------- ------------------------------

  20831110 12.1.0.2             SUCCESS                  4 PSU

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2016
Added on Apr 5 2016
16 comments
12,596 views