Oracle Database patch list Query

[Oraprod @ db01 oraprod] $ sqlplus "/as sysdba"

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

Copyright (c) 1982,200 8, Oracle. All rights reserved.

Connected:

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

[Oraprod @ db01 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/export toollogs/opatch/opatch2014-03-17_14-37-35PM.log

Lsinventory Output file location:/u01/PRODDB/db/export toollogs/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,824 9087, 7281382

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

Created on 23 Mar 2009, 19:32:26 hrs PST8PDT

Bugs fixed:

7327166,833 8798, 6815733,830 3523

Patch 8834636: applied on Fri Dec 11 00:10:52 CST 2009

Created on 21 Sep 2009, 10:36:44 hrs PST8PDT

Bugs fixed:

8834636

Patch 8447623: applied on Fri Dec 11 00:07:23 CST 2009

Created on 26 May 2009, 15:52:49 hrs PST8PDT

Bugs fixed:

8447623

Patch 8738008: applied on Thu Dec 10 23:53:42 CST 2009

Created on 12 Oct 2009, 06:32:17 hrs PST8PDT

Bugs fixed:

8738008

Patch 7486407: applied on Thu Dec 10 23:30:20 CST 2009

Created on 10 Nov 2008, 10:22:46 hrs US/Eastern

Bugs fixed:

7486407

Patch 8833297: applied on Thu Dec 10 22:35:06 CST 2009

Created on 7 Oct 2009, 03:14:51 hrs PST8PDT

Bugs fixed:

6870937,762 7743, 7652888,729 9153, 8242410,605 9178, 8563946,695 5744

7497788,684 0740, 8244217,870 2276, 6981690,845 0529, 7432556,771 9143

7523787,825 1486, 8367827,761 3481, 8341623,751 5145, 7348847,841 6414

8250643,828 4633, 8230457,856 3948, 6900214,704 4551, 7318049,894 0197

7013124,743 2514, 7393258,755 3884, 7639121,856 3944, 8860821,760 6379

7426959,733 0434, 7708340,735 2414, 6452375,735 6443, 7341598,821 3302

7196532,744 6163, 8409848,823 6851, 8342506,759 3835, 7340448,730 9458

8290478,839 1256, 7462112,701 3817, 8499600,741 1865, 7331867,752 7650

6977167,885 5565, 6501490,659 8432, 7524944,770 6138, 6941717,840 2555

7494333,758 6451, 8402551,749 9353, 8408887,749 6908, 7511040,771 9148

7311601,749 7640, 7373196,742 4804, 7452373,759 7354, 6882739,736 6290

6851669,854 3737, 7318276,828 4438, 8324760,742 0394, 7834195,735 0127

7475055,856 3942, 7122161,836 1398, 7451927,770 5669, 7676737,830 1559

8224083,865 8581, 8211920,846 2173, 7206858,856 3945, 8855553,840 2637

8257122,819 9266, 7454752,751 6536, 7345904,835 2304, 7416901,742 6336

8352309,681 2439, 7219752,853 4338, 8542307,841 3059, 7572069,743 6280

7432601,731 1909, 7506785,746 0818, 7276960,885 5559, 7013835,737 8322

8402548,718 9645, 8563947,830 6933, 7477246,726 3842, 7480809,885 5575

8433270,755 6778, 8836375,733 0611, 8339352,722 5720, 8563943,703 6453

7628387,841 9383, 6970731,771 9668, 7203349,840 2562, 7680907,743 8445

8855577,824 3648, 7630416,685 1110, 6980597,661 8461, 7357609,885 5570

8369094,831 8050, 8306934,743 4194, 8833297,748 6595, 7716219,836 2693

6599920,762 8866, 7183523,741 2296, 7135702,772 0494, 7436152,717 5513

7602341,667 9303, 8339404,739 3694, 8856696,765 0993, 6980601,783 0065

7462709,856 3941, 8226397,751 5779

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

OPatch succeeded.

[Oraprod @ db01 oraprod] $