建站
咨詢
售后
建站咨詢
新聞中心
Oracle如何檢查當(dāng)前數(shù)據(jù)庫CPU和PSU補(bǔ)丁
進(jìn)入ORACLE_HOME下面的OPatch目錄，執(zhí)行opatch lsinventory查看已經(jīng)應(yīng)用的補(bǔ)丁
創(chuàng)新互聯(lián)公司是一家專業(yè)提供古塔企業(yè)網(wǎng)站建設(shè),專注與成都網(wǎng)站設(shè)計、成都網(wǎng)站建設(shè)、H5技術(shù)、小程序制作等業(yè)務(wù)。10年已為古塔眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專業(yè)的建站公司優(yōu)惠進(jìn)行中。
oracle 用sql語句查詢 已打補(bǔ)丁列表。
sys@NGACselect?*?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,?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，因為補(bǔ)丁一般都是針對oracle數(shù)據(jù)庫軟件的。
Oracle數(shù)據(jù)庫怎么查看補(bǔ)丁信息
用數(shù)據(jù)字典
select
*
from
dba_users;
查看數(shù)據(jù)庫里面所有用戶，前提是你是有dba權(quán)限的帳號，如sys,system
select
*
from
all_users;
查看你能管理的所有用戶！
select
*
from
user_users;
查看當(dāng)前用戶信息
！
如何查詢已經(jīng)安裝的Oracle CPU 補(bǔ)丁信息
Linux查看系統(tǒng)信息的一些命令及查看已安裝軟件包的命令（轉(zhuǎn))：
系統(tǒng)
# uname -a # 查看內(nèi)核/操作系統(tǒng)/CPU信息
磁盤和分區(qū)
# mount | column -t # 查看掛接的分區(qū)狀態(tài)
# fdisk -l
服務(wù)
# chkconfig --list # 列出所有系統(tǒng)服務(wù)
#chkconfig --list | grep on # 列出所有啟動的系統(tǒng)服務(wù)
本文題目：怎么查看oracle補(bǔ)丁 oracle數(shù)據(jù)庫打補(bǔ)丁
鏈接地址：http://www.dlmjj.cn/article/hehpdh.html
