查看mysql 补丁_oracle数据库补丁列表查询

这篇日志展示了如何使用SQL*Plus连接到Oracle数据库,并查询数据库版本及已安装的补丁。通过OPatch工具列出详细的库存信息,包括Oracle Database 11g的版本及10个已应用的补丁,每个补丁的创建日期和修复的Bug。
摘要由CSDN通过智能技术生成

[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, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.

[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, 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

[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/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

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

Bugs fixed:

7327166, 8338798, 6815733, 8303523

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, 7627743, 7652888, 7299153, 8242410, 6059178, 8563946, 6955744

7497788, 6840740, 8244217, 8702276, 6981690, 8450529, 7432556, 7719143

7523787, 8251486, 8367827, 7613481, 8341623, 7515145, 7348847, 8416414

8250643, 8284633, 8230457, 8563948, 6900214, 7044551, 7318049, 8940197

7013124, 7432514, 7393258, 7553884, 7639121, 8563944, 8860821, 7606362

7426959, 7330434, 7708340, 7352414, 6452375, 7356443, 7341598, 8213302

7196532, 7446163, 8409848, 8236851, 8342506, 7593835, 7340448, 7309458

8290478, 8391256, 7462112, 7013817, 8499600, 7411865, 7331867, 7527650

6977167, 8855565, 6501490, 6598432, 7524944, 7706138, 6941717, 8402555

7494333, 7586451, 8402551, 7499353, 8408887, 7496908, 7511040, 7719148

7311601, 7497640, 7373196, 7424804, 7452373, 7597354, 6882739, 7366290

6851669, 8543737, 7318276, 8284438, 8324760, 7420394, 7834195, 7350127

7475055, 8563942, 7122161, 8361398, 7451927, 7705669, 7676737, 8301559

8224083, 8658581, 8211920, 8462173, 7206858, 8563945, 8855553, 8402637

8257122, 8199266, 7454752, 7516536, 7345904, 8352304, 7416901, 7426336

8352309, 6812439, 7219752, 8534338, 8542307, 8413059, 7572069, 7436280

7432601, 7311909, 7506785, 7460818, 7276960, 8855559, 7013835, 7378322

8402548, 7189645, 8563947, 8306933, 7477246, 7263842, 7480809, 8855575

8433270, 7556778, 8836375, 7330611, 8339352, 7225720, 8563943, 7036453

7628387, 8419383, 6970731, 7719668, 7203349, 8402562, 7680907, 7438445

8855577, 8243648, 7630416, 6851110, 6980597, 6618461, 7357609, 8855570

8369094, 8318050, 8306934, 7434194, 8833297, 7486595, 7716219, 8362693

6599920, 7628866, 7183523, 7412296, 7135702, 7720494, 7436152, 7175513

7602341, 6679303, 8339404, 7393804, 8856696, 7650993, 6980601, 7830065

7462709, 8563941, 8226397, 7515779

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

OPatch succeeded.

[oraprod@db01 oraprod ]$ ,

本文原创发布php中文网,转载请注明出处,感谢您的尊重!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值