正常情况下有两种方法:
一种是登录数据库检查DBA_REGISTRY_HIST视图:
1.MODDB2:[/home/oracle]$sqlplus / as sysdba
2.SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 18 13:04:43
3.Copyright (c) 1982, , Oracle. All Rights Reserved.
4.Connected to:
5.Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
6.With the Partitioning, Real Application Clusters, Oracle Label Security, Data Mining
7.and Real Application Testing options
8.SQL> set pages 100 lines 120
9.SQL> col action format a6
10.SQL> col namespace format a10
11.SQL> col version format a10
12.SQL> col comments format a15
13.SQL> col action_time format a30
14.SQL> col bundle_series format a15
15.SQL> alter session set nls_timestamp_format = 'yyyy-mm-dd hh24:mi:ss.ff';
16.Session altered.
17.SQL> select * from dba_registry_history;
18.ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
19.--------------------------- ------ ---------- -------------- -------------- ---------------
20.-06-02 16:54:21.301023 APPLY SERVER 10.2.0.4 4 PSU PSU 10.2.0.4.4
21.-06-02 16:54:42.711877 APPLY SERVER 10.2.0.4 1 OPSU PSU 10.2.0.4.5
另一种方式是通过opatch lsinventory方式:
1.MODDB2:[/home/oracle]$opatch lsinventory
2.Invoking OPatch 10.2.0.5.0
3.Oracle Interim Patch Installer version 10.2.0.5.0
4.Copyright (c) , Oracle Corporation. All rights reserved.
5.Oracle Home : /oracle/db
6.Central Inventory : /oracle/oraInventory
7.from : /var/opt/oracle/oraInst.loc
8.OPatch version : 10.2.0.5.0
9.OUI version : 10.2.0.4.0
10.OUI location : /oracle/db/oui
11.Log file location : /oracle/db/cfgtoollogs/opatch/opatch-08-18_11-18-30AM.log
12.Patch history file: /oracle/db/cfgtoollogs/opatch/opatch_history.txt
13.Lsinventory Output file location : /oracle/db/cfgtoollogs/opatch/lsinv/lsinventory-08-18_11-18-30AM.txt
14.--------------------------------------------------------------------------------
15.Installed Top-level Products (2):
16.Oracle Database 10g 10.2.0.1.0
17.Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0