There is a difference in the patch level that I am seeing on my Oracle database. On the Oracle Enterprise Manager, it shows that it is patched up to .7 but on DBA_REGISTRY_HISTORY it does not show any of the patches.

APPLY   SERVER    0   Patchset PSU
APPLY   SERVER    0   Patchset PSU

Is this a common occurrence?

Thank you

  • what patch are you checking for? in OEM, are you checking for patch recommendations?
    – tesla747
    Apr 20, 2016 at 16:01
  • I'm looking for (20760982). On OEM it shows that this patch was installed on Feb 7,2016 10:42:08 AM GMT. On OEM it also shows .1 through .6 as well
    – Stan
    Apr 20, 2016 at 16:05
  • shows .1 through .6 as what? recommended patches or applied patches?
    – tesla747
    Apr 20, 2016 at 16:08
  • It shows them as Installed as well, with Installation Times as well
    – Stan
    Apr 20, 2016 at 16:10
  • what does opatch output show? Does it show you have applied 20760982?
    – tesla747
    Apr 20, 2016 at 16:11

1 Answer 1


The installation of a PSU is not complete without the execution of the postinstall script. Opatch works at file level, it replaces/relinks files in the Oracle home. Changes inside the database are performed by running the postinstall script. Sometimes I see DBAs forget this step.

The postinstall script maintains the SYS.REGISTRY$ table (on which the DBA_SERVER_REGISTRY view is built) with the actual patch versions.

In 11.2, you run the postinstall script as (stated in the README):

sqlplus / as sysdba
@?/rdbms/admin/catbundle psu apply

This populates the above table (and so the view) with the actual data. When installing a PSU, this script must be executed in all databases running from the affected Oracle Home.

In most of the cases, skipping the postinstall script does not cause any problem, so mostly this goes on unnoticed. But there are exceptions, for example I have seen a database throwing ORA-07445 errors during the configuration of GoldenGate, because the postinstall script was not executed after the installation of the PSU.

Starting with 12c, the postinstall script is executed as:

export ORACLE_SID=orcl

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.