\u5bf9\u4e8ePSU\u8865\u4e01\u7684\u5b89\u88c5\uff0c\u4e0d\u662f\u7b80\u5355\u7684opatch apply\u4e4b\u540e\u5c31\u5b8c\u6210\u4e86\uff0c\u8fd8\u9700\u8981\u8fd0\u884c\u7279\u5b9a\u7684sql\u3002
\n\u5728\u5ba2\u6237\u6570\u636e\u5e93\u4e2d\u68c0\u67e5\u8865\u4e01\u60c5\u51b5\uff0c\u53d1\u73b0\u5b89\u88c5PSU\u53ea\u5b8c\u6210\u4e86\u7b2c\u4e00\u6b65\uff1a\n<\/pre lang='SQL'>fgms:\/fgms\/oracle\/tru64_setupFile\/OPatch
\n> .\/opatch lsinventory
\nInvoking OPatch 10.2.0.5.0
\nOracle Interim Patch Installer version 10.2.0.5.0
\nCopyright (c) 2010, Oracle Corporation. All rights reserved.<\/p>\n
Oracle Home : \/fgms\/oracle10g\/db
\nCentral Inventory : \/fgms\/oracle\/oraInventory
\nfrom : \/var\/opt\/oracle\/oraInst.loc
\nOPatch version : 10.2.0.5.0
\nOUI version : 10.2.0.4.0
\nOUI location : \/fgms\/oracle10g\/db\/oui
\nLog file location : \/fgms\/oracle10g\/db\/cfgtoollogs\/opatch\/opatch2011-06-02_15-41-01PM.log
\nPatch history file: \/fgms\/oracle10g\/db\/cfgtoollogs\/opatch\/opatch_history.txt
\nLsinventory Output file location : \/fgms\/oracle10g\/db\/cfgtoollogs\/opatch\/lsinv\/lsinventory2011-06-02_15-41-01PM.txt
\n——————————————————————————–
\nInstalled Top-level Products (2):
\nOracle Database 10g 10.2.0.2.0
\nOracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
\nThere are 2 products installed in this Oracle Home.<\/p>\n
Interim patches (2) :
\nPatch 9654991 : applied on Mon Sep 20 15:48:09 GMT+08:00 2010
\nUnique Patch ID: 12744499
\nCreated on 7 Jul 2010, 15:37:03 hrs PST8PDT
\nBugs fixed:
\n9714832, 9713537, 9678695, 9655017, 9173248, 8309642, 9678697, 9678690
\n9573054, 9654991
\nThis patch overlays patches:
\n9352164
\nThis patch needs patches:
\n9352164
\nas prerequisites
\nPatch 9352164 : applied on Mon Sep 20 15:34:43 GMT+08:00 2010
\nUnique Patch ID: 12389142
\nCreated on 7 Apr 2010, 12:28:31 hrs PST8PDT
\nBugs fixed:
\n9377578, 6418420, 7835247, 7207654, 7592346, 6724797, 7936993, 7331867
\n9093300, 7535152, 7552067, 5879114, 8866013, 5457450, 8344348, 7272297
\n7136866, 7196894, 6258480, 7013124, 6512622, 6355586, 7196532, 8568395
\n8309587, 7557226, 5399699, 6509115, 8568397, 8568398, 7127618, 5701695
\n6052226, 7424804, 6817593, 7553884, 6741425, 7513673, 6783812, 8437213
\n6452766, 6469211, 7527650, 8309592, 8479537, 5991038, 5686407, 6945157
\n7639602, 9119226, 6403091, 7589862, 7552082, 6711853, 8304589, 6052169
\n8199266, 6327692, 5756769, 9352191, 7460818, 6268409, 8232056, 6687381
\n6972843, 8230457, 6800507, 7027551, 6778714, 6200820, 6645719, 7393804
\n6775231, 3934160, 6683178, 6650256, 5085288, 7528105, 7329252, 6378112
\n6151380, 6844866, 4723109, 8544896, 5126719, 5890312, 5934363, 7036453
\n7610362, 8426816, 8433026, 7270434, 7172531, 6451626, 8247855, 5497338
\n6324944, 6874522, 7175513, 6960489, 7341598, 8576156, 6797677, 8342923
\n5895190, 6756739, 7150470, 7593835, 7356443, 7044551, 8227106, 4695511
\n7298688, 5747462, 8556340, 7197445, 5348308, 7937113, 8341623, 7569205
\n8409848, 6053134, 6163771, 6851669, 6181488, 6375150, 6825866, 7210921
\n7295780, 6345573, 7033630, 6954722, 6824129, 7523475, 7457766, 7309458
\n8324577, 6840740, 6804746, 7375611, 8268054, 6981690, 6512811, 6988017
\n7375613, 8344399, 7340448, 8362683, 7375617, 8251247, 5933656, 6005347
\n9145204, 6599920, 7238230, 6379441, 6452375, 6352003, 6833965, 7136489
\n6610218, 7612639, 6392076, 7225204, 9119194, 5476236, 9442328, 7609057
\n7609058, 6605106, 6374297, 6193945, 4693355, 8217795, 7039896, 7432514
\n7330909, 6952701, 7190270, 8287155, 7587008, 7207932, 6802650, 7189447
\n8481935, 4598439, 9442331, 6615740, 7155655, 6749617, 9442335, 7159505
\n5868257, 5727166, 7173005, 6917874, 9442339, 7013768, 7691766, 7385253
\n7291739, 7225720, 7257770, 7363767, 7244238, 6941717, 8267348, 7710551
\n8354686, 7247217, 8328954, 7299153, 8909984, 6681695, 8702276, 9119284
\n8217011, 7661251, 6265559, 6823287, 6991626, 6954829, 5259835, 6500033
\n5923486, 7432601, 7022234, 8534387, 5147386, 7697802, 6653934, 7375644
\n6490140, 7662491, 8331466, 5623467, 6070225, 6635214, 7396409, 6638558
\n7038750, 6714608, 6838714, 6870937, 7219752, 7263842, 7278117, 6882739
\n5404871, 8836667, 8373286, 7393292, 6678845, 6903051, 7936793, 6600051
\n7155248, 4966512, 7155249, 7197637, 8836308, 8568402, 8568404, 8568405
\n8431487, 5704108, 6343150, 7280764, 6923450, 7643632, 6145177, 8836671
\n8310931, 6640411, 8347704, 8836675, 7155250, 7155251, 8836677, 7155252
\n8836678, 7155253, 8292378, 7155254, 6219529, 7411865, 8227091, 8340379
\n7276960, 6145687, 7659217, 5863926, 7022905, 6852598, 7123643, 6596564
\n6413089, 6851438, 8836681, 8836683, 8836684, 8836686, 7579469, 7494333
\n7315642, 8340383, 6786022, 8340387, 6926448, 7600026, 7462072, 6679303
\n8815639, 7197583, 7172752, 7326645, 7008262, 9173244, 9173248, 7573151
\n8490879, 7477934, 6725634, 6733655, 6799205, 6980597, 7499353, 6084232
\n6014513, 7140204, 7254987, 8833280, 6647480, 6120004, 7693128, 6760697
\n6051177, 8247215, 6858062, 7189645, 6844739, 6768251, 7196863, 5630796
\n7378661, 7378735, 5970301, 6705822, 8290506, 6658484, 7599944, 8309623
\n7125408, 7257461, 6987790, 7568556, 6919819, 8886674, 5883691, 6955744
\n7801939, 6074620, 7149004, 6857917, 8283650, 6445948, 5929055, 6110752
\n7552042, 8210889, 8287504, 6506617, 7306915, 6271590, 5386204, 6976005
\n8330783, 7606362, 5377242, 7043989, 8309632, 7575925, 6870047, 8309637
\n5902053, 8309639, 7028176, 6827260, 7588384, 4726401, 6720712, 5910650
\n6752765, 6971433, 6024730, 8315482, 6628122, 8239142, 9352164, 5695562
\n4637902, 7345904, 8309642, 6994160, 8556586, 6404447, 8220734, 6919764
\n7597354, 7523787, 6029179, 5231155, 6455659
\n——————————————————————————–
\nOPatch succeeded.<\/pre>\n
\u4eceOPATCH\u5de5\u5177\u4fe1\u606f\u53ef\u4ee5\u770b\u5230\uff0c\u6570\u636e\u5e93\u7684PSU\u5df2\u7ecf\u6253\u5230\u4e8610.2.0.4.5\uff0c\u4f46\u662f\u67e5\u8be2DBA_REGISTRY_HISTORY\u89c6\u56fe\uff0c\u5374\u6ca1\u6709\u4efb\u4f55\u8bb0\u5f55\u3002\n<\/pre lang='SQL'>SQL> select * from v$version;
\nBANNER
\n—————————————————————-
\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod
\nPL\/SQL Release 10.2.0.4.0 – Production
\nCORE 10.2.0.4.0 Production
\nTNS for Compaq Tru64 UNIX: Version 10.2.0.4.0 – Production
\nNLSRTL Version 10.2.0.4.0 – Production
\nSQL> select * from dba_registry_history;
\nno rows selected<\/pre>\n
\u8fd9\u8bf4\u660e\u8865\u4e01\u7684\u5b89\u88c5\u8fc7\u7a0b\u53ea\u8fdb\u884c\u4e86\u524d\u4e00\u534a\uff0c\u800c\u968f\u540e\u7684\u8c03\u7528sql\u7684\u6b65\u9aa4\u6ca1\u6709\u6267\u884c\uff0c\u5206\u522b\u8fd0\u884c$ORACLE_HOME\/psu\/10.2.0.4.4\/catpsu.sql\u548c$ORACLE_HOME\/psu\/10.2.0.4.5\/catpsu.sql\uff1a\n<\/pre lang='SQL'>> cd $ORACLE_HOME\/psu
\nfgms:\/fgms\/oracle10g\/db\/psu
\n> ls
\n10.2.0.4.4 10.2.0.4.5
\nfgms:\/fgms\/oracle10g\/db\/psu
\n> cd 10.2.0.4.4
\nfgms:\/fgms\/oracle10g\/db\/psu\/10.2.0.4.4
\n> sqlplus \/ as sysdba
\nSQL*Plus: Release 10.2.0.4.0 – Production on Thu Jun 2 16:13:55 2011
\nCopyright (c) 1982, 2007, Oracle. All Rights Reserved.<\/p>\n
Connected to:
\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Production
\nWith the Partitioning, Data Mining and Real Application Testing options
\nSQL> @catpsu.sql
\nPL\/SQL procedure successfully completed.<\/p>\n
PL\/SQL procedure successfully completed.<\/p>\n
PL\/SQL procedure successfully completed.
\n.
\n.
\n.
\nSQL> ALTER SESSION SET current_schema = SYS;
\nSession altered.
\nSQL> PROMPT Updating registry…
\nUpdating registry…
\nSQL> INSERT INTO registry$history
\n2 (action_time, action,
\n3 namespace, version, id,
\n4 bundle_series, comments)
\n5 VALUES
\n6 (SYSTIMESTAMP, ‘APPLY’,
\n7 SYS_CONTEXT(‘REGISTRY$CTX’,’NAMESPACE’),
\n8 ‘10.2.0.4’,
\n9 4,
\n10 ‘PSU’,
\n11 ‘PSU 10.2.0.4.4’);
\n1 row created.
\nSQL> COMMIT;
\nCommit complete.
\nSQL> SPOOL off
\nSQL> SET echo off
\nCheck the following log file for errors:
\n\/fgms\/oracle10g\/db\/cfgtoollogs\/catbundle\/catbundle_PSU_B1FGMS_APPLY_2011Jun02_16_14_08.log<\/pre>\n
\u6574\u4e2aTRACE\u6587\u4ef6\u8d85\u8fc7\u4e864W\u884c\uff0c\u7531\u4e8e\u7bc7\u5e45\uff0c\u8fd9\u91cc\u53ea\u5217\u51fa\u4e86\u5f00\u5934\u548c\u7ed3\u5c3e\u90e8\u5206\u5185\u5bb9\uff0c\u53ef\u4ee5\u770b\u5230\uff0c\u5982\u679c\u4e0d\u8fd0\u884ccatpsu.sql\uff0c\u4e8b\u5b9e\u4e0a\u8865\u4e01\u7684\u5f88\u591a\u5185\u5bb9\u53ea\u662f\u5e94\u7528\u5230\u4e86\u6570\u636e\u5e93\u8f6f\u4ef6\uff0c\u800c\u5e76\u6ca1\u6709\u771f\u6b63\u5e94\u7528\u5230\u6570\u636e\u5e93\u5b57\u5178\u4e2d\u3002\n<\/pre lang='SQL'>SQL> col action_time format a30
\nSQL> col action format a10
\nSQL> col namespace format a10
\nSQL> col version format a10
\nSQL> col comments format a15
\nSQL> select * from dba_registry_history;
\nACTION_TIME ACTION NAMESPACE VERSION ID BUNDL COMMENTS
\n—————————— ———- ———- ———- —— —– ————–
\n02-JUN-11 04.15.43.804266 PM APPLY SERVER 10.2.0.4 4 PSU PSU 10.2.0.4.4
\n1 row selected.<\/pre>\n
\u8fd9\u65f6PSU\u7684\u5b89\u88c5\u4fe1\u606f\u5df2\u7ecf\u5199\u5165\u5230\u6570\u636e\u5b57\u5178\u4e2d\uff0c\u4e0b\u9762\u8fd0\u884c10.2.0.4.5\u7684catpsu.sql\uff1a\n<\/pre lang='SQL'>SQL> @..\/10.2.0.4.5\/catopsu.sql
\nPL\/SQL procedure successfully completed.
\n1 row selected.<\/p>\n
PL\/SQL procedure successfully completed.<\/p>\n
PL\/SQL procedure successfully completed.
\n1 row selected.
\nGenerating apply and rollback scripts…
\nCheck the following file for errors:
\n\/fgms\/oracle10g\/db\/cfgtoollogs\/catbundle\/catbundle_OPSU_B1FGMS_GENERATE_2011Jun02_16_21_39.log
\nApply script: \/fgms\/oracle10g\/db\/rdbms\/admin\/catbundle_OPSU_B1FGMS_APPLY.sql
\nRollback script: \/fgms\/oracle10g\/db\/rdbms\/admin\/catbundle_OPSU_B1FGMS_ROLLBACK.sql
\nPL\/SQL procedure successfully completed.
\nExecuting script file…<\/p>\n
1 row selected.
\nSQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
\nSQL> SELECT ‘\/fgms\/oracle10g\/db\/cfgtoollogs\/catbundle\/’ || ‘catbundle_OPSU_’ || name || ‘_APPLY_’ || TO_CHAR(SYSDATE, ‘YYYYMonDD_hh24_mi_ss’, ‘NLS_DATE_LANGUAGE=”AMERICAN”’) || ‘.log’ AS spool_file FROM v$database;<\/p>\n
1 row selected.
\nSQL> SPOOL &spool_file
\nSQL> exec dbms_registry.set_session_namespace(‘SERVER’)
\nPL\/SQL procedure successfully completed.
\nSQL> PROMPT Skipping OLAP Analytic Workspace because it is not installed or versions mismatch…
\nSkipping OLAP Analytic Workspace because it is not installed or versions mismatch…
\nSQL> PROMPT Skipping OLAP Catalog because it is not installed or versions mismatch…
\nSkipping OLAP Catalog because it is not installed or versions mismatch…
\nSQL> PROMPT Skipping Oracle OLAP API because it is not installed or versions mismatch…
\nSkipping Oracle OLAP API because it is not installed or versions mismatch…
\nSQL> ALTER SESSION SET current_schema = SYS;
\nSession altered.
\nSQL> PROMPT Updating registry…
\nUpdating registry…
\nSQL> INSERT INTO registry$history
\n2 (action_time, action,
\n3 namespace, version, id,
\n4 bundle_series, comments)
\n5 VALUES
\n6 (SYSTIMESTAMP, ‘APPLY’,
\n7 SYS_CONTEXT(‘REGISTRY$CTX’,’NAMESPACE’),
\n8 ‘10.2.0.4’,
\n9 1,
\n10 ‘OPSU’,
\n11 ‘PSU 10.2.0.4.5’);
\n1 row created.
\nSQL> COMMIT;
\nCommit complete.
\nSQL> SPOOL off
\nSQL> SET echo off
\nCheck the following log file for errors:
\n\/fgms\/oracle10g\/db\/cfgtoollogs\/catbundle\/catbundle_OPSU_B1FGMS_APPLY_2011Jun02_16_21_41.log<\/pre>\n
10.2.0.4.5\u7684\u6240\u6709\u8bb0\u5f55\u90fd\u5217\u51fa\u6765\u4e86\uff0c\u548c10.2.0.4.4\u76f8\u6bd4\uff0c\u8fd9\u91cc\u7684\u4fee\u6539\u81f3\u5c11\u76f8\u5dee\u4e86\u4e0d\u6b62\u4e00\u4e2a\u6570\u91cf\u7ea7\uff0c\u8fd9\u4e5f\u662f10.2.0.4.4\u662f\u57fa\u7840PSU\uff0c\u800c10.2.0.4.5\u662fOPSU\u7684\u539f\u56e0\u3002
\n\u6700\u540e\u68c0\u67e5\u6570\u636e\u5e93\u4e2dPSU\u4fe1\u606f\uff1a\n<\/pre lang='SQL'>SQL> select * from dba_registry_history;
\nACTION_TIME ACTION NAMESPACE VERSION ID BUNDL COMMENTS
\n—————————— ———- ———- ———- —— —– ————–
\n02-JUN-11 04.15.43.804266 PM APPLY SERVER 10.2.0.4 4 PSU PSU 10.2.0.4.4
\n02-JUN-11 04.21.41.080347 PM APPLY SERVER 10.2.0.4 1 OPSU PSU 10.2.0.4.5
\n2 rows selected.<\/pre>\n
\u81f3\u6b64\uff0cPSU\u7684\u5b89\u88c5\u624d\u7b97\u771f\u6b63\u5b8c\u6210\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5bf9\u4e8ePSU\u8865\u4e01\u7684\u5b89\u88c5\uff0c\u4e0d\u662f\u7b80\u5355\u7684opatch apply\u4e4b\u540e\u5c31\u5b8c\u6210\u4e86\uff0c\u8fd8\u9700\u8981\u8fd0\u884c\u7279\u5b9a\u7684sql\u3002 \u5728\u5ba2\u6237\u6570\u636e\u5e93\u4e2d\u68c0\u67e5\u8865\u4e01\u60c5\u51b5\uff0c\u53d1\u73b0\u5b89\u88c5PSU\u53ea\u5b8c\u6210\u4e86\u7b2c\u4e00\u6b65\uff1a fgms:\/fgms\/oracle\/tru64_setupFile\/OPatch > .\/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 : \/fgms\/oracle10g\/db Central Inventory : \/fgms\/oracle\/oraInventory from : \/var\/opt\/oracle\/oraInst.loc OPatch version : 10.2.0.5.0 OUI … Continue reading