How Does Oracle check the CPU and PSU patch information of the current database?

InOracleIn the database, how do we checkCPU and PSU PatchesWhat about the installation? This article mainly introduces this part, hoping to help you.

Normally, there are two methods:

One is to log on to the database and check the 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 100 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 method is opatch lsinventory:

 
 

  
  
MODDB2:[/home/oracle]$opatch lsinventory  
  
  
Invoking OPatch 10.2.0.5.0  
  
  
Oracle Interim Patch Installer version 10.2.0.5.0  
  
  
Copyright (c) 2010, Oracle Corporation. All rights reserved.  
  
  
Oracle Home : /oracle/db  
  
  
Central 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 in this Oracle Home.  
  
  
Interim patches (4) :  
  
  
Patch 6367097 : applied on Tue Sep 14 22:08:15 GMT+08:00 2010  
  
  
Created on 20 Jul 2008, 23:37:14 hrs US/Pacific  
  
  
Bugs fixed:  
  
  
6367097  
  
  
......  
  
  
Bugs fixed:  
  
  
9294403  
  
  
OPatch succeeded. 
 
 

Note:The CPU and PSU patches are divided into two parts: First run the opatch command, and then run cat_bundle. SQL. If this SQL statement is not run, the Patch Is Not Installed successfully. You can check the patch installation information through the OPATCH command, but the corresponding information cannot be found in the database DBA_REGISTRY_HISTORY.

The above are two ways to check the CPU and PSU patch information of the current database in the Oracle database. This article will introduce it here, and I hope this introduction will be helpful to you!