oracle 用sql语句查询已打补丁列表。

答案:2 悬赏:80 手机版

解决时间 2021-02-12 22:51

提问者网友：练爱
2021-02-12 17:26

最佳答案

五星知识达人网友：青灯有味
2021-02-12 18:01

查打过的 patchset:

select * from v$version

查PSU(不是100%真实)

select * from registry$history ;

最实际的你还是要用

opatch lsinventory 看
from askmaclean

全部回答

1楼网友：杯酒困英雄
2021-02-12 18:29

sys@NGAC>select * from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
或者[oracle@svr-ww-ora02 OPatch]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11gr2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11gr2/db_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11gr2/db_1/cfgtoollogs/opatch/opatch2014-01-03_16-46-01PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11gr2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-01-03_16-46-01PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g                                                  11.2.0.3.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :
Patch  14275605     : applied on Tue Oct 30 13:12:42 CST 2012
Unique Patch ID:  15367368
Patch description:  "Database Patch Set Update : 11.2.0.3.4 (14275605)"
   Created on 3 Oct 2012, 18:38:19 hrs PST8PDT
Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
     14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
     13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
     12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
     14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
     13503598, 10133521, 12718090, 13742433, 12905058, 1240

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息

oracle 用sql语句查询 已打补丁列表。

oracle 用sql语句查询已打补丁列表。