萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Oracle 教學

Oracle 資料庫補丁清單查詢:OPatch lsinventory 與 V$VERSION 實操指南

一、確認資料庫版本基線

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

基線版本:11.1.0.7.0 (已打 Patch Set 1)。

二、OPatch 清單完整輸出解讀

$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 11.1.0.6.2
Oracle Home       : /u01/PRODDB/db
Central Inventory : /u01/oraInventory
OPatch version    : 11.1.0.6.2
OUI version       : 11.1.0.7.0

Installed Top-level Products (2):
Oracle Database 11g 11.1.0.6.0
Oracle Database 11g Patch Set 1 11.1.0.7.0

Interim patches (10):
Patch 7211965  : applied on Fri Dec 11 00:30:57 CST 2009
  Bugs fixed: 7211965
Patch 7253531  : applied on Fri Dec 11 00:28:34 CST 2009
  Bugs fixed: 7253531
Patch 8639653  : applied on Fri Dec 11 00:18:33 CST 2009
  Bugs fixed: 8639653
Patch 8409203  : applied on Fri Dec 11 00:16:08 CST 2009
  Bugs fixed: 8409203, 8249087, 7281382
Patch 8338798  : applied on Fri Dec 11 00:13:22 CST 2009
  Bugs fixed: 7327166, 8338798, 6815733, 8303523
Patch 8834636  : applied on Fri Dec 11 00:10:52 CST 2009
  Bugs fixed: 8834636
Patch 8447623  : applied on Fri Dec 11 00:07:23 CST 2009
  Bugs fixed: 8447623
Patch 8738008  : applied on Thu Dec 10 23:53:42 CST 2009
  Bugs fixed: 8738008
Patch 7486407  : applied on Thu Dec 10 23:30:20 CST 2009
  Bugs fixed: 7486407
Patch 8833297  : applied on Thu Dec 10 22:35:06 CST 2009
  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

三、關鍵資訊提取技巧

  • PSU/CPU 識別:opatch lsinventory -bugs_fixed | grep -i 'DATABASE PSU'
  • 特定 Bug 是否修復:opatch lsinventory -bugs_fixed | grep 7211965
  • 安裝時間排序:輸出按應用時間倒序,最新在前。
  • 衝突檢測:opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./patch_dir

四、資料庫視圖驗證 (補充)

-- 查看套件元件版本 (不顯示 PSU 細節)
SELECT * FROM PRODUCT_COMPONENT_VERSION;

-- 查看註冊歷史 (需 catbundle.sql 執行後)
SELECT action, comments, action_time FROM DBA_REGISTRY_HISTORY ORDER BY action_time;

五、OPatch 版本管理

# 查看當前 OPatch 版本
$ opatch version
OPatch Version: 11.1.0.6.2

# 升級 OPatch (下載 Patch 6880880)
$ unzip p6880880_111000_Linux-x86-64.zip -d $ORACLE_HOME
# 覆蓋 $ORACLE_HOME/OPatch 目錄

六、巡檢清單

  1. 基線版本 (V$VERSION) 與支援矩陣對齊。
  2. 最新 PSU/CPU 是否已應用 (OPatch 清單)。
  3. 關鍵 Bug (如安全漏洞 CVE) 是否在修復清單中。
  4. OPatch 版本是否滿足最新 PSU 需求。
  5. RAC 所有節點補丁一致性 (跑 opatch lsinventory -all_nodes)。

定期輸出 opatch lsinventory -bugs_fixed > patch_list_$(date +%F).txt 歸檔,構建補丁管理審計軌跡,滿足合規與故障溯源需求。

copyright © 萬盛學電腦網 all rights reserved