查询oracle psu,Oracle如何检查当前数据库CPU和PSU补丁

补丁"/>

查询oracle psu,Oracle如何检查当前数据库CPU和PSU补丁

正常情况下有两种方法：

一、登录数据库检查DBA_REGISTRY_HIST视图

sqlplus '/as sysdba'

set linesize 200

set pagesize 999

col action_time format a30

col action format a20

col id format a10

col version format a10

col comments format a20

select substr(action_time,1,30) action_time,substr(id,1,8) id,

substr(action,1,10) action,substr(version,1,8) version,substr(comments,1,20) comments from registry$history;

二、通过opatch lsinventory方式

[oracle@aaa ~]$ opatch lsinventory

Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

Copyright (c) 2010, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/app/oracle/product/10.2.0.1/db_1

Central Inventory : /oracle/oraInventory

from           : /etc/oraInst.loc

OPatch version    : 10.2.0.5.1

OUI version       : 10.2.0.4.0

OUI location      : /oracle/app/oracle/product/10.2.0.1/db_1/oui

Log file location : /oracle/app/oracle/product/10.2.0.1/db_1/cfgtoollogs/opatch/opatch2017-07-03_21-23-22PM.log

Patch history file: /oracle/app/oracle/product/10.2.0.1/db_1/cfgtoollogs/opatch/o