#下面查看oracle 10g下的补丁信息，对于如何安装补丁，本文不作演示
oracle@M10DB01p:/users/oracle/OraHome10g/OPatch> ./opatch lsinventory
Invoking OPatch 10.2.0.3.0
.........
Oracle Home : /users/oracle/OraHome10g
Central Inventory : /users/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /users/oracle/OraHome10g/oui
Log file location : /users/oracle/OraHome10g/cfgtoollogs/opatch/opatch2013-12-19_09-54-27AM.log
Lsinventory Output file location : /users/oracle/OraHome10g/cfgtoollogs/opatch/lsinv/lsinventory2013-12-19_09-54-27AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0 #基础版本号
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0 #PSR号为3
There are 2 products installed in this Oracle Home.
Interim patches (2) : #列出了2个临时补丁patch号及bug号
Patch 5556081 : applied on Wed Feb 15 11:16:15 HKT 2012
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081
Patch 5557962 : applied on Wed Feb 15 11:16:08 HKT 2012
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974
--------------------------------------------------------------------------------
OPatch succeeded.
#也可以通过查询dba_server_registry查看当前数据补丁的使用情况
SQL> select comp_name,version from dba_server_registry;
COMP_NAME VERSION
-------------------------------------------------- ------------------------------
Oracle XML Database 10.2.0.3.0
Oracle Label Security 10.2.0.3.0
Oracle Expression Filter 10.2.0.3.0
Oracle Rules Manager 10.2.0.3.0
Oracle Workspace Manager 10.2.0.1.0
Oracle Database Catalog Views 10.2.0.3.0
Oracle Database Packages and Types 10.2.0.3.0
JServer JAVA Virtual Machine 10.2.0.3.0
Oracle XDK 10.2.0.3.0
Oracle Database Java Packages 10.2.0.3.0
10 rows selected.
#下面是Oracle 11g下使用lsinventory -detail时patch的应用情况
[oracle@linux1 OPatch]$ ./opatch lsinventory -detail
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
...............(省略)
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.
Installed Products (134):