简单描述如何检查当前数据库的CPU和PSU补丁安装情况。
正常情况下有两种方法，一种是登录数据库检查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 Patch 9654991 : applied ON Tue Sep 14 22:06:57 GMT+08:00 2010 UNIQUE Patch ID: 12666999 Created ON 1 Jul 2010, 19:02:09 hrs PST8PDT Bugs fixed: 9714832, 9713537, 9678695, 9655017, 9173248, 8309642, 9678697, 9678690 9573054, 9654991 This patch overlays patches: 9352164 This patch needs patches: 9352164 AS prerequisites Patch 9352164 : applied ON Tue Sep 14 22:02:20 GMT+08:00 2010 UNIQUE Patch ID: 12317594 Created ON 1 Apr 2010, 11:23:39 hrs PST8PDT Bugs fixed: 9377578, 6418420, 7835247, 7207654, 7592346, 6724797, 7936993, 7331867 9093300, 7535152, 7552067, 5879114, 8866013, 5457450, 8344348, 7272297 7136866, 7196894, 6258480, 7013124, 6512622, 6355586, 7196532, 8568395 8309587, 7557226, 5399699, 6509115, 8568397, 8568398, 7127618, 5701695 6052226, 7424804, 6817593, 7553884, 6741425, 7513673, 6783812, 8437213 6452766, 6469211, 7527650, 8309592, 8479537, 5991038, 5686407, 6945157 7639602, 9119226, 6403091, 7589862, 7552082, 6711853, 8304589, 6052169 8199266, 6327692, 5756769, 9352191, 7460818, 6268409, 8232056, 6687381 6972843, 8230457, 6800507, 7027551, 6778714, 6200820, 6645719, 7393804 6775231, 3934160, 6683178, 6650256, 5085288, 7528105, 7329252, 6378112 6151380, 6844866, 4723109, 8544896, 5126719, 5890312, 5934363, 7036453 7610362, 8426816, 8433026, 7270434, 7172531, 6451626, 8247855, 5497338 6324944, 6874522, 7175513, 6960489, 7341598, 8576156, 6797677, 8342923 5895190, 6756739, 7150470, 7593835, 7356443, 7044551, 8227106, 4695511 7298688, 5747462, 8556340, 7197445, 5348308, 7937113, 8341623, 7569205 8409848, 6053134, 6163771, 6851669, 6181488, 6375150, 6825866, 7210921 7295780, 6345573, 7033630, 6954722, 6824129, 7523475, 7457766, 7309458 8324577, 6840740, 6804746, 7375611, 8268054, 6981690, 6512811, 6988017 7375613, 8344399, 7340448, 8362683, 7375617, 8251247, 5933656, 6005347 9145204, 6599920, 7238230, 6379441, 6452375, 6352003, 6833965, 7136489 6610218, 7612639, 6392076, 7225204, 9119194, 5476236, 9442328, 7609057 7609058, 6605106, 6374297, 6193945, 4693355, 8217795, 7039896, 7432514 7330909, 6952701, 7190270, 8287155, 7587008, 7207932, 6802650, 7189447 8481935, 4598439, 9442331, 6615740, 7155655, 6749617, 9442335, 7159505 5868257, 5727166, 7173005, 6917874, 9442339, 7013768, 7691766, 7385253 7291739, 7225720, 7257770, 7363767, 7244238, 6941717, 8267348, 7710551 8354686, 7247217, 8328954, 7299153, 8909984, 6681695, 8702276, 9119284 8217011, 7661251, 6265559, 6823287, 6991626, 6954829, 5259835, 6500033 5923486, 7432601, 7022234, 8534387, 5147386, 7697802, 6653934, 7375644 6490140, 7662491, 8331466, 5623467, 6070225, 6635214, 7396409, 6638558 7038750, 6714608, 6838714, 6870937, 7219752, 7263842, 7278117, 6882739 5404871, 8836667, 8373286, 7393292, 6678845, 6903051, 7936793, 6600051 7155248, 4966512, 7155249, 7197637, 8836308, 8568402, 8568404, 8568405 8431487, 5704108, 6343150, 7280764, 6923450, 7643632, 6145177, 8836671 8310931, 6640411, 8347704, 8836675, 7155250, 7155251, 8836677, 7155252 8836678, 7155253, 8292378, 7155254, 6219529, 7411865, 8227091, 8340379 7276960, 6145687, 7659217, 5863926, 7022905, 6852598, 7123643, 6596564 6413089, 6851438, 8836681, 8836683, 8836684, 8836686, 7579469, 7494333 7315642, 8340383, 6786022, 8340387, 6926448, 7600026, 7462072, 6679303 8815639, 7197583, 7172752, 7326645, 7008262, 9173244, 9173248, 7573151 8490879, 7477934, 6725634, 6733655, 6799205, 6980597, 7499353, 6084232 6014513, 7140204, 7254987, 8833280, 6647480, 6120004, 7693128, 6760697 6051177, 8247215, 6858062, 7189645, 6844739, 6768251, 7196863, 5630796 7378661, 7378735, 5970301, 6705822, 8290506, 6658484, 7599944, 9173253 8309623, 7125408, 7257461, 6987790, 7568556, 6919819, 8886674, 5883691 6955744, 7801939, 6074620, 7149004, 6857917, 8283650, 6445948, 5929055 6110752, 7552042, 8210889, 8287504, 6506617, 7306915, 6271590, 5386204 6976005, 8330783, 7606362, 5377242, 7043989, 8309632, 7575925, 6870047 8309637, 5902053, 8309639, 7028176, 6827260, 7588384, 4726401, 6720712 5910650, 6752765, 6971433, 6024730, 8315482, 6628122, 8239142, 9352164 5695562, 4637902, 7345904, 8309642, 6994160, 8556586, 6404447, 8220734 6919764, 7597354, 7523787, 6029179, 5231155, 6455659 Patch 9294403 : applied ON Tue Sep 14 21:29:10 GMT+08:00 2010 UNIQUE Patch ID: 12382380 Created ON 19 Mar 2010, 08:00:09 hrs PST8PDT Bugs fixed: 9294403 OPatch succeeded. |
注意，CPU和PSU补丁分为两部分，首先通过opatch命令，随后还需要运行cat_bundle.sql。如果没有运行这个SQL，则补丁不算安装成功，这时通过OPATCH命令检查可以看到补丁的安装信息，但是在数据库的DBA_REGISTRY_HISTORY中是找不到对应的信息的。
3 Responses to 检查数据库CPU和PSU补丁信息