锐客网

  1. 首页 > 生活百科 > it技术 > >

怎么看oracle补丁 oracle的补丁集有哪几种

IT技术Oracle

Oracle数据库怎么查看补丁信息用数据字典
select
*
from
dba_users;
查看数据库里面所有用户 ， 前提是你是有dba权限的帐号，如sys,system
select
*
from
all_users;
查看你能管理的所有用户！
select
*
from
user_users;
查看当前用户信息
！
Oracle如何检查当前数据库CPU和PSU补丁进入ORACLE_HOME下面的OPatch目录，执行opatch lsinventory查看已经应用的补丁
oracle 用sql语句查询 已打补丁列表 。sys@NGACselect * from v$version ;
BANNER
【怎么看oracle补丁 oracle的补丁集有哪几种】--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE11.2.0.3.0Production
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 11g11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch14275605: 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-patch13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch13343438; "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, 12401111, 13742434
13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
13657605, 13103913, 14063280
--------------------------------------------------------------------------------
OPatch succeeded.
我不记得sql可以直接查询patch，因为补丁一般都是针对oracle数据库软件的 。
oracle 补丁CVE编号怎么查？oracle 补丁CVE编号怎么查？
任何软件都会有补?。?补丁的作用一般都是 修复bug或者安全问题，对于oracle 11g也不例外 。同时oracle的补丁属于商业软件的一部分，需要购买了oracle ps服务才能下载 。
关于怎么看oracle补丁和oracle的补丁集有哪几种的介绍到此就结束了 ， 不知道你从中找到你需要的信息了吗 ？如果你还想了解更多这方面的信息，记得收藏关注本站 。

    推荐阅读


    上一篇：go语言的秒杀系统，go语言实战

    下一篇：用html5定义一块画布画正三角形，纯css画三角形