oracle数据!库补丁列表查询

 　　[[email protected] oraprod ]$ sqlplus "/as sysdba"

　　SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 17 14:36:41 2014

　　Copyright (c) 1982, 2008, Oracle. All rights reserved.

　　Connected to:

　　Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

　　With the Partitioning, Real Application Clusters, OLAP, Data Mining

　　and Real Application Testing options

　　SQL> select * from v$version ;

　　BANNER

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

　　Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

　　PL/SQL Release 11.1.0.7.0 - Production

　　CORE 11.1.0.7.0 Production

　　TNS for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production

　　NLSRTL Version 11.1.0.7.0 - Production

　　SQL> exit

　　Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

　　With the Partitioning, Real Application Clusters, OLAP, Data Mining

　　and Real Application Testing options

　　[[email protected] oraprod ]$ $ORACLE_HOME/OPatch/opatch lsinventory

　　Invoking OPatch 11.1.0.6.2

　　Oracle Interim Patch Installer version 11.1.0.6.2

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

　　Oracle Home : /u01/PRODDB/db

　　Central Inventory : /u01/oraInventory

　　from : /etc/oraInst.loc

　　OPatch version : 11.1.0.6.2

　　OUI version : 11.1.0.7.0

　　OUI location : /u01/PRODDB/db/oui

　　Log file location : /u01/PRODDB/db/cfgtoollogs/opatch/opatch2014-03-17_14-37-35PM.log

　　Lsinventory Output file location : /u01/PRODDB/db/cfgtoollogs/opatch/lsinv/lsinventory2014-03-17_14-37-35PM.txt

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

　　Installed Top-level Products (2):

　　Oracle Database 11g 11.1.0.6.0

　　Oracle Database 11g Patch Set 1 11.1.0.7.0

　　There are 2 products installed in this Oracle Home.

　　Interim patches (10) :

　　Patch 7211965 : applied on Fri Dec 11 00:30:57 CST 2009

　　Created on 13 Feb 2009, 13:15:13 hrs UTC

　　Bugs fixed:

　　7211965

　　Patch 7253531 : applied on Fri Dec 11 00:28:34 CST 2009

　　Created on 24 Nov 2008, 04:11:42 hrs US/Pacific

　　Bugs fixed:

　　7253531

　　Patch 8639653 : applied on Fri Dec 11 00:18:33 CST 2009

　　Created on 12 Aug 2009, 00:44:39 hrs PST8PDT

　　Bugs fixed:

　　8639653

　　Patch 8409203 : applied on Fri Dec 11 00:16:08 CST 2009

　　Created on 7 Apr 2009, 14:57:08 hrs US/Pacific

　　Bugs fixed:

　　8409203, 8249087, 7281382

　　Patch 8338798 : applied on Fri Dec 11 00:13:22 CST 2009