{"id":13,"date":"2011-08-19T23:55:48","date_gmt":"2011-08-19T15:55:48","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=13"},"modified":"2011-09-22T18:44:14","modified_gmt":"2011-09-22T10:44:14","slug":"%e6%a3%80%e6%9f%a5%e6%95%b0%e6%8d%ae%e5%ba%93cpu%e5%92%8cpsu%e8%a1%a5%e4%b8%81%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=13","title":{"rendered":"\u68c0\u67e5\u6570\u636e\u5e93CPU\u548cPSU\u8865\u4e01\u4fe1\u606f"},"content":{"rendered":"<p>\u7b80\u5355\u63cf\u8ff0\u5982\u4f55\u68c0\u67e5\u5f53\u524d\u6570\u636e\u5e93\u7684CPU\u548cPSU\u8865\u4e01\u5b89\u88c5\u60c5\u51b5\u3002<br \/>\n\u6b63\u5e38\u60c5\u51b5\u4e0b\u6709\u4e24\u79cd\u65b9\u6cd5\uff0c\u4e00\u79cd\u662f\u767b\u5f55\u6570\u636e\u5e93\u68c0\u67e5DBA_REGISTRY_HIST\u89c6\u56fe\uff1a<\/p>\n<pre lang='SQL'>MODDB2:[\/home\/oracle]$sqlplus \/ as sysdba\r\nSQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 18 13:04:43 2011\r\nCopyright (c) 1982, 2007, Oracle.  All Rights Reserved.\r\nConnected to:\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Oracle Label Security, Data Mining\r\nand Real Application Testing options\r\nSQL> set pages 100 lines 120\r\nSQL> col action format a6\r\nSQL> col namespace format a10\r\nSQL> col version format a10\r\nSQL> col comments format a15\r\nSQL> col action_time format a30\r\nSQL> col bundle_series format a15\r\nSQL> alter session set nls_timestamp_format = 'yyyy-mm-dd hh24:mi:ss.ff';\r\nSession altered.\r\nSQL> select * from dba_registry_history;\r\nACTION_TIME                 ACTION NAMESPACE  VERSION      ID BUNDLE_SERIES  COMMENTS\r\n--------------------------- ------ ---------- ---------- ---- -------------- ---------------\r\n2011-06-02 16:54:21.301023  APPLY  SERVER     10.2.0.4      4 PSU            PSU 10.2.0.4.4\r\n2011-06-02 16:54:42.711877  APPLY  SERVER     10.2.0.4      1 OPSU           PSU 10.2.0.4.5<\/pre>\n<p>\u53e6\u4e00\u79cd\u65b9\u5f0f\u662f\u901a\u8fc7opatch lsinventory\u65b9\u5f0f\uff1a<\/p>\n<pre lang='SQL'>MODDB2:[\/home\/oracle]$opatch lsinventory\r\nInvoking OPatch 10.2.0.5.0\r\nOracle Interim Patch Installer version 10.2.0.5.0\r\nCopyright (c) 2010, Oracle Corporation.  All rights reserved.\r\nOracle Home       : \/oracle\/db\r\nCentral Inventory : \/oracle\/oraInventory\r\n   from           : \/var\/opt\/oracle\/oraInst.loc\r\nOPatch version    : 10.2.0.5.0\r\nOUI version       : 10.2.0.4.0\r\nOUI location      : \/oracle\/db\/oui\r\nLog file location : \/oracle\/db\/cfgtoollogs\/opatch\/opatch2011-08-18_11-18-30AM.log\r\nPatch history file: \/oracle\/db\/cfgtoollogs\/opatch\/opatch_history.txt\r\nLsinventory Output file location : \/oracle\/db\/cfgtoollogs\/opatch\/lsinv\/lsinventory2011-08-18_11-18-30AM.txt\r\n--------------------------------------------------------------------------------\r\nInstalled Top-level Products (2): \r\nOracle Database 10g                                                  10.2.0.1.0\r\nOracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0\r\nThere are 2 products installed in this Oracle Home.\r\nInterim patches (4) :\r\nPatch  6367097      : applied on Tue Sep 14 22:08:15 GMT+08:00 2010\r\n   Created on 20 Jul 2008, 23:37:14 hrs US\/Pacific\r\n   Bugs fixed:\r\n     6367097\r\nPatch  9654991      : applied on Tue Sep 14 22:06:57 GMT+08:00 2010\r\nUnique Patch ID:  12666999\r\n   Created on 1 Jul 2010, 19:02:09 hrs PST8PDT\r\n   Bugs fixed:\r\n     9714832, 9713537, 9678695, 9655017, 9173248, 8309642, 9678697, 9678690\r\n     9573054, 9654991\r\n   This patch overlays patches:\r\n     9352164\r\n   This patch needs patches:\r\n     9352164\r\n   as prerequisites\r\nPatch  9352164      : applied on Tue Sep 14 22:02:20 GMT+08:00 2010\r\nUnique Patch ID:  12317594\r\n   Created on 1 Apr 2010, 11:23:39 hrs PST8PDT\r\n   Bugs fixed:\r\n     9377578, 6418420, 7835247, 7207654, 7592346, 6724797, 7936993, 7331867\r\n     9093300, 7535152, 7552067, 5879114, 8866013, 5457450, 8344348, 7272297\r\n     7136866, 7196894, 6258480, 7013124, 6512622, 6355586, 7196532, 8568395\r\n     8309587, 7557226, 5399699, 6509115, 8568397, 8568398, 7127618, 5701695\r\n     6052226, 7424804, 6817593, 7553884, 6741425, 7513673, 6783812, 8437213\r\n     6452766, 6469211, 7527650, 8309592, 8479537, 5991038, 5686407, 6945157\r\n     7639602, 9119226, 6403091, 7589862, 7552082, 6711853, 8304589, 6052169\r\n     8199266, 6327692, 5756769, 9352191, 7460818, 6268409, 8232056, 6687381\r\n     6972843, 8230457, 6800507, 7027551, 6778714, 6200820, 6645719, 7393804\r\n     6775231, 3934160, 6683178, 6650256, 5085288, 7528105, 7329252, 6378112\r\n     6151380, 6844866, 4723109, 8544896, 5126719, 5890312, 5934363, 7036453\r\n     7610362, 8426816, 8433026, 7270434, 7172531, 6451626, 8247855, 5497338\r\n     6324944, 6874522, 7175513, 6960489, 7341598, 8576156, 6797677, 8342923\r\n     5895190, 6756739, 7150470, 7593835, 7356443, 7044551, 8227106, 4695511\r\n     7298688, 5747462, 8556340, 7197445, 5348308, 7937113, 8341623, 7569205\r\n     8409848, 6053134, 6163771, 6851669, 6181488, 6375150, 6825866, 7210921\r\n     7295780, 6345573, 7033630, 6954722, 6824129, 7523475, 7457766, 7309458\r\n     8324577, 6840740, 6804746, 7375611, 8268054, 6981690, 6512811, 6988017\r\n     7375613, 8344399, 7340448, 8362683, 7375617, 8251247, 5933656, 6005347\r\n     9145204, 6599920, 7238230, 6379441, 6452375, 6352003, 6833965, 7136489\r\n     6610218, 7612639, 6392076, 7225204, 9119194, 5476236, 9442328, 7609057\r\n     7609058, 6605106, 6374297, 6193945, 4693355, 8217795, 7039896, 7432514\r\n     7330909, 6952701, 7190270, 8287155, 7587008, 7207932, 6802650, 7189447\r\n     8481935, 4598439, 9442331, 6615740, 7155655, 6749617, 9442335, 7159505\r\n     5868257, 5727166, 7173005, 6917874, 9442339, 7013768, 7691766, 7385253\r\n     7291739, 7225720, 7257770, 7363767, 7244238, 6941717, 8267348, 7710551\r\n     8354686, 7247217, 8328954, 7299153, 8909984, 6681695, 8702276, 9119284\r\n     8217011, 7661251, 6265559, 6823287, 6991626, 6954829, 5259835, 6500033\r\n     5923486, 7432601, 7022234, 8534387, 5147386, 7697802, 6653934, 7375644\r\n     6490140, 7662491, 8331466, 5623467, 6070225, 6635214, 7396409, 6638558\r\n     7038750, 6714608, 6838714, 6870937, 7219752, 7263842, 7278117, 6882739\r\n     5404871, 8836667, 8373286, 7393292, 6678845, 6903051, 7936793, 6600051\r\n     7155248, 4966512, 7155249, 7197637, 8836308, 8568402, 8568404, 8568405\r\n     8431487, 5704108, 6343150, 7280764, 6923450, 7643632, 6145177, 8836671\r\n     8310931, 6640411, 8347704, 8836675, 7155250, 7155251, 8836677, 7155252\r\n     8836678, 7155253, 8292378, 7155254, 6219529, 7411865, 8227091, 8340379\r\n     7276960, 6145687, 7659217, 5863926, 7022905, 6852598, 7123643, 6596564\r\n     6413089, 6851438, 8836681, 8836683, 8836684, 8836686, 7579469, 7494333\r\n     7315642, 8340383, 6786022, 8340387, 6926448, 7600026, 7462072, 6679303\r\n     8815639, 7197583, 7172752, 7326645, 7008262, 9173244, 9173248, 7573151\r\n     8490879, 7477934, 6725634, 6733655, 6799205, 6980597, 7499353, 6084232\r\n     6014513, 7140204, 7254987, 8833280, 6647480, 6120004, 7693128, 6760697\r\n     6051177, 8247215, 6858062, 7189645, 6844739, 6768251, 7196863, 5630796\r\n     7378661, 7378735, 5970301, 6705822, 8290506, 6658484, 7599944, 9173253\r\n     8309623, 7125408, 7257461, 6987790, 7568556, 6919819, 8886674, 5883691\r\n     6955744, 7801939, 6074620, 7149004, 6857917, 8283650, 6445948, 5929055\r\n     6110752, 7552042, 8210889, 8287504, 6506617, 7306915, 6271590, 5386204\r\n     6976005, 8330783, 7606362, 5377242, 7043989, 8309632, 7575925, 6870047\r\n     8309637, 5902053, 8309639, 7028176, 6827260, 7588384, 4726401, 6720712\r\n     5910650, 6752765, 6971433, 6024730, 8315482, 6628122, 8239142, 9352164\r\n     5695562, 4637902, 7345904, 8309642, 6994160, 8556586, 6404447, 8220734\r\n     6919764, 7597354, 7523787, 6029179, 5231155, 6455659\r\nPatch  9294403      : applied on Tue Sep 14 21:29:10 GMT+08:00 2010\r\nUnique Patch ID:  12382380\r\n   Created on 19 Mar 2010, 08:00:09 hrs PST8PDT\r\n   Bugs fixed:\r\n     9294403\r\nOPatch succeeded.<\/pre>\n<p>\u6ce8\u610f\uff0cCPU\u548cPSU\u8865\u4e01\u5206\u4e3a\u4e24\u90e8\u5206\uff0c\u9996\u5148\u901a\u8fc7opatch\u547d\u4ee4\uff0c\u968f\u540e\u8fd8\u9700\u8981\u8fd0\u884ccat_bundle.sql\u3002\u5982\u679c\u6ca1\u6709\u8fd0\u884c\u8fd9\u4e2aSQL\uff0c\u5219\u8865\u4e01\u4e0d\u7b97\u5b89\u88c5\u6210\u529f\uff0c\u8fd9\u65f6\u901a\u8fc7OPATCH\u547d\u4ee4\u68c0\u67e5\u53ef\u4ee5\u770b\u5230\u8865\u4e01\u7684\u5b89\u88c5\u4fe1\u606f\uff0c\u4f46\u662f\u5728\u6570\u636e\u5e93\u7684DBA_REGISTRY_HISTORY\u4e2d\u662f\u627e\u4e0d\u5230\u5bf9\u5e94\u7684\u4fe1\u606f\u7684\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7b80\u5355\u63cf\u8ff0\u5982\u4f55\u68c0\u67e5\u5f53\u524d\u6570\u636e\u5e93\u7684CPU\u548cPSU\u8865\u4e01\u5b89\u88c5\u60c5\u51b5\u3002 \u6b63\u5e38\u60c5\u51b5\u4e0b\u6709\u4e24\u79cd\u65b9\u6cd5\uff0c\u4e00\u79cd\u662f\u767b\u5f55\u6570\u636e\u5e93\u68c0\u67e5DBA_REGISTRY_HIST\u89c6\u56fe\uff1a MODDB2:[\/home\/oracle]$sqlplus \/ as sysdba SQL*Plus: Release 10.2.0.4.0 &#8211; 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 &#8211; 64bit Production With the Partitioning, &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=13\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[82,79,80,78],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-d","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/13"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13"}],"version-history":[{"count":6,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions"}],"predecessor-version":[{"id":139,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions\/139"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}