建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
Oracle如何檢查當(dāng)前數(shù)據(jù)庫CPU和PSU補(bǔ)丁信息？
在Oracle數(shù)據(jù)庫中，我們?nèi)绾螜z查當(dāng)前數(shù)據(jù)庫的CPU和PSU補(bǔ)丁安裝情況呢？本文我們主要就介紹這部分內(nèi)容，希望能夠?qū)δ兴鶐椭?/p>
正常情況下有兩種方法：
一種是登錄數(shù)據(jù)庫檢查DBA_REGISTRY_HIST視圖：
- MODDB2:[/home/oracle]$sqlplus / as sysdba
- SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 18 13:04:43 2011
- Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
- Connected to:
- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
- With the Partitioning, Real Application Clusters, Oracle Label Security, Data Mining
- and Real Application Testing options
- SQL> set pages 100 lines 120
- SQL> col action format a6
- SQL> col namespace format a10
- SQL> col version format a10
- SQL> col comments format a15
- SQL> col action_time format a30
- SQL> col bundle_series format a15
- SQL> alter session set nls_timestamp_format = 'yyyy-mm-dd hh24:mi:ss.ff';
- Session altered.
- SQL> select * from dba_registry_history;
- ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
- --------------------------- ------ ---------- -------------- -------------- ---------------
- 2011-06-02 16:54:21.301023 APPLY SERVER 10.2.0.4 4 PSU PSU 10.2.0.4.4
- 2011-06-02 16:54:42.711877 APPLY SERVER 10.2.0.4 1 OPSU PSU 10.2.0.4.5
另一種方式是通過opatch lsinventory方式：
- MODDB2:[/home/oracle]$opatch lsinventory
- Invoking OPatch 10.2.0.5.0
- Oracle Interim Patch Installer version 10.2.0.5.0
- Copyright (c) 2010, Oracle Corporation. All rights reserved.
- Oracle Home : /oracle/db
- Central Inventory : /oracle/oraInventory
- from : /var/opt/oracle/oraInst.loc
- OPatch version : 10.2.0.5.0
- OUI version : 10.2.0.4.0
- OUI location : /oracle/db/oui
- Log file location : /oracle/db/cfgtoollogs/opatch/opatch2011-08-18_11-18-30AM.log
- Patch history file: /oracle/db/cfgtoollogs/opatch/opatch_history.txt
- Lsinventory Output file location : /oracle/db/cfgtoollogs/opatch/lsinv/lsinventory2011-08-18_11-18-30AM.txt
- --------------------------------------------------------------------------------
- Installed Top-level Products (2):
- Oracle Database 10g 10.2.0.1.0
- Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
- There are 2 products installed in this Oracle Home.
- Interim patches (4) :
- Patch 6367097 : applied on Tue Sep 14 22:08:15 GMT+08:00 2010
- Created on 20 Jul 2008, 23:37:14 hrs US/Pacific
- Bugs fixed:
- 6367097
- ......
- Bugs fixed:
- 9294403
- OPatch succeeded.
注意：CPU和PSU補(bǔ)丁分為兩部分，首先通過opatch命令，隨后還需要運行cat_bundle.sql。如果沒有運行這個SQL，則補(bǔ)丁不算安裝成功，這時通過OPATCH命令檢查可以看到補(bǔ)丁的安裝信息，但是在數(shù)據(jù)庫的DBA_REGISTRY_HISTORY中是找不到對應(yīng)的信息的。
以上就是Oracle數(shù)據(jù)庫中檢查當(dāng)前數(shù)據(jù)庫CPU和PSU補(bǔ)丁信息的兩種方法，本文就介紹到這里了，希望本次的介紹能夠?qū)δ兴斋@！
當(dāng)前標(biāo)題：Oracle如何檢查當(dāng)前數(shù)據(jù)庫CPU和PSU補(bǔ)丁信息？
當(dāng)前網(wǎng)址：http://www.dlmjj.cn/article/dpogpji.html
