使用opatch 命令檢視oracle patch 狀況

dbtest$opatch lsinventory -detail -invPtrLoc $ORACLE_HOME/oraInst.loc
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.

Oracle Home       : /u01/product/oracle
Central Inventory : /u01/oraInventory
   from           : /u01/product/oracle/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/product/oracle/oui
Log file location : /u01/product/oracle/cfgtoollogs/opatch/opatch2010-10-21_09-36-22AM.log

Patch history file: /u01/product/oracle/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/product/oracle/cfgtoollogs/opatch/lsinv/lsinventory2010-10-21_09-36-22AM.txt

--------------------------------------------------------------------------------
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):

Agent Required Support Files                                         10.2.0.4.2
Assistant Common Files                                               11.2.0.1.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.1.0
Character Set Migration Utility                                      11.2.0.1.0
Cluster Verification Utility Common Files                            11.2.0.1.0
Database Configuration and Upgrade Assistants                        11.2.0.1.0
Database SQL Scripts                                                 11.2.0.1.0
Database Workspace Manager                                           11.2.0.1.0
Deinstallation Tool                                                  11.2.0.1.0
Enterprise Edition Options                                           11.2.0.1.0
Enterprise Manager Agent                                             10.2.0.4.2
Enterprise Manager Agent Core Files                                  10.2.0.4.2
Enterprise Manager Common Core Files                                 10.2.0.4.2
Enterprise Manager Common Files                                      10.2.0.4.2
Enterprise Manager Database Plugin -- Agent Support                  11.2.0.1.0
Enterprise Manager Database Plugin -- Repository Support             11.2.0.1.0
Enterprise Manager Grid Control Core Files                           10.2.0.4.2
Enterprise Manager Minimal Integration                               11.2.0.1.0
Enterprise Manager plugin Common Files                               11.2.0.1.0
Enterprise Manager Repository Core Files                             10.2.0.4.2
Exadata Storage Server                                               11.2.0.1.0
Expat libraries                                                       2.0.1.0.1
Generic Connectivity Common Files                                    11.2.0.1.0
HAS Common Files                                                     11.2.0.1.0
HAS Files for DB                                                     11.2.0.1.0
Installation Common Files                                            11.2.0.1.0
Installation Plugin Files                                            11.2.0.1.0
Installer SDK Component                                              11.2.0.1.0
JAccelerator (COMPANION)                                             11.2.0.1.0
LDAP Required Support Files                                          11.2.0.1.0
OLAP SQL Scripts                                                     11.2.0.1.0
Oracle 11g Warehouse Builder Required Files                          11.2.0.1.0
Oracle Advanced Security                                             11.2.0.1.0
Oracle Application Express                                           11.2.0.1.0
Oracle Call Interface (OCI)                                          11.2.0.1.0
Oracle Clusterware RDBMS Files                                       11.2.0.1.0

.......  

SQL*Plus                                                             11.2.0.1.0
SQL*Plus Files for Instant Client                                    11.2.0.1.0
SQL*Plus Required Support Files                                      11.2.0.1.0
SQLJ Runtime                                                         11.2.0.1.0
SSL Required Support Files for InstantClient                         11.2.0.1.0
Sun JDK                                                              1.5.0.17.0
XDK Required Support Files                                           11.2.0.1.0
XML Parser for Java                                                  11.2.0.1.0
XML Parser for Oracle JVM                                            11.2.0.1.0
There are 134 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.
dbtest$