Check the database for CPU and PSU patch Information

Check the database for CPU and PSU patch information

Briefly describes how to check the current database for CPU and PSU patch installation.

Normally there are two methods, one is to log in to the database check dba_registry_hist view:

Moddb2:[/home/oracle] $sqlplus/as sysdba

Sql*plus:release 10.2.0.4.0-production on Thu Aug 18 13:04:43 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition release 10.2.0.4.0-64bit Production
With the partitioning, real application clusters, Oracle Label security, Data Mining
and real Application testing options

Sql> Set Pages Lines 120
Sql> Col Action format A6
Sql> Col namespace format A10
Sql> Col version format A10
Sql> Col Comments Format A15
sql> Col action_time format A30
sql> Col bundle_series format A15
Sql> alter session Set Nls_timestamp_format = ' Yyyy-mm-dd hh24:mi:ss.ff ';

Session altered.

Sql> select * from Dba_registry_history;

Action_time ACTION NAMESPACE VERSION ID bundle_series COMMENTS
--------------------------- ------ ---------- ---------- ---- -------------- ---------------
2011-06-02 16:54:21.301023 APPLY SERVER 10.2.0.4 4 PSU PSU 10.2.0.4.4
2011-06-02 16:54:42.711877 APPLY SERVER 10.2.0.4 1 opsu PSU 10.2.0.4.5

Another way is through the Opatch lsinventory way:

Moddb2:[/home/oracle] $opatch lsinventory
Invoking Opatch 10.2.0.5.0

Oracle Interim Patch Installer version 10.2.0.5.0
Copyright (c), Oracle Corporation. All rights reserved.

Oracle Home:/oracle/db
Inventory:/oracle/orainventory
From:/var/opt/oracle/orainst.loc
Opatch version:10.2.0.5.0
OUI version:10.2.0.4.0
OUI Location:/oracle/db/oui
Log File Location:/oracle/db/cfgtoollogs/opatch/opatch2011-08-18_11-18-30am.log

Patch history File:/oracle/db/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file Location:/oracle/db/cfgtoollogs/opatch/lsinv/lsinventory2011-08-18_11-18-30am.txt

--------------------------------------------------------------------------------
Installed top-level products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed at this Oracle home.

Interim Patches (4):

Patch 6367097:applied on Tue Sep 22:08:15 gmt+08:00 2010
Created on June 2008, 23:37:14 hrs us/pacific
Bugs fixed:
6367097

......

Bugs fixed:
9294403

Opatch succeeded.

Note that the CPU and PSU patches are divided into two parts, first through the Opatch command, followed by the need to run Cat_bundle.sql. If this SQL is not running, then the patch does not count for installation success, then through the opatch command check can see the patch installation information, but in the database dba_registry_history is not found the corresponding information.

PS: I built a few Oracle QQ group, Welcome to join the database enthusiasts.

Oracle Expert QQ1 Group: 60632593

Oracle Expert QQ2 Group: 60618621

Oracle Expert QQ3 Group: 23145225