Step_by_step apply PSU(10.2.0.4.9) for RAC (AIX)
本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客
|
1 2 3 4 5 6 7 8 9 10 |
由于oracle PSU 10.2.0.4.9 是基于PSU 10.2.0.4.4，故必须先apply 10.2.0.4.4， 然后再升级到10.2.0.4.9. 另外需要下载10.2版本的最新opatch。 关于oracle database 10.2 PSU version的说明详见链接: <a href="http://www.killdb.com/2011/10/21/10-2-0-4%E7%89%88%E6%9C%ACpsu%E4%BB%A5%E5%8F%8A%E7%9B%B8%E5%85%B3bundle-patch%E5%88%97%E8%A1%A8-new.html" style="font-size: 12px; text-decoration: underline; color: #0000ff; font-family: monospace;"> 10.2.0.4+版本PSU以及相关bundle patch列表–New</a> 如下是今天对一套10.2.0.4.0 rac（aix）进行apply PSU的全过程。 这次打PSU相对麻烦的是，这套rac中存在2个库，sodb和amb，详细过程如下： |
|
1 2 3 4 5 6 |
1. 备份ORACLE_HOME，两个node都进行tar备份，如下： $ tar -cvf oracle_product.tar product $ ls -ltr oracle_product* -rw-r--r-- 1 oracle dba 11503308800 Nov 14 09:45 oracle_product.tar |
|
1 2 3 4 5 6 7 8 9 |
2. 停止em，listener $ emctl stop dbconsole $ lsnrctl stop LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 14-NOV-2011 09:52:24 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 |
3. 停止所有instance $ env|grep ORA ORACLE_BASE=/oracle/product ORACLE_SID=amb1 ORACLE_TERM=xterm ORA_CRS_HOME=/oracle/product/10.2.0/crs ORACLE_HOME=/oracle/product/10.2.0/db $ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Mon Nov 14 09:53:00 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, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options $ ps -ef|grep pmon oracle 442496 372914 0 09:53:40 pts/2 0:00 grep pmon oracle 475626 1 0 Nov 09 - 0:59 ora_pmon_sodb1 $ export ORACLE_SID=sodb1 $ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Mon Nov 14 09:53:50 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, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options $ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....b1.inst application OFFLINE OFFLINE ora....b2.inst application OFFLINE OFFLINE ora.amb.db application OFFLINE OFFLINE ora....B1.lsnr application OFFLINE OFFLINE ora....db1.gsd application ONLINE ONLINE pmissodb1 ora....db1.ons application ONLINE ONLINE pmissodb1 ora....db1.vip application ONLINE ONLINE pmissodb1 ora....B2.lsnr application OFFLINE OFFLINE ora....db2.gsd application ONLINE ONLINE pmissodb2 ora....db2.ons application ONLINE ONLINE pmissodb2 ora....db2.vip application ONLINE ONLINE pmissodb2 ora.sodb.db application OFFLINE OFFLINE ora....b1.inst application OFFLINE OFFLINE ora....b2.inst application OFFLINE OFFLINE |
|
1 2 3 4 5 |
4. 解压PSU以及Opatch unzip p9352164_10204_AIX5L.zip unzip p12419397_10204_AIX5L.zip unzip p6880880_102000_AIX64-5L.zip |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 |
5. Check One-off Patch Conflict Detection $ /oracle/PSU_102049/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352164 Invoking OPatch 10.2.0.5.1 Oracle Interim Patch Installer version 10.2.0.5.1 Copyright (c) 2010, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /oracle/product/10.2.0/db Central Inventory : /oracle/product/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/10.2.0/db/oui Log file location : /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-11-14_09-59-05AM.log Patch history file: /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch_history.txt Invoking prereq "checkconflictagainstohwithdetail" ZOP-47: The patch(es) has supersets with other patches installed in the Oracle Home (or) among themselves. Prereq "checkConflictAgainstOHWithDetail" failed. Summary of Conflict Analysis: Patches that can be applied now without any conflicts are : 9352164 Following patches will be rolled back from Oracle Home on application of the patches in the given list : 9352164 Conflicts/Supersets for each patch are: Patch : 9352164 Bug Superset of 9352164 Super set bugs are: 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, 85 68397, 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, 63 27692, 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, 59 34363, 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, 71 97445, 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, 73 75613, 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, 82 17795, 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, 72 57770, 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, 73 75644, 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, 88 36308, 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, 61 45687, 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, 91 73248, 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, 67 05822, 8290506, 6658484, 7599944, 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, 83 0783, 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, 640 4447, 8220734, 6919764, 7597354, 7523787, 6029179, 5231155, 6455659 OPatch succeeded. |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 |
6. Apply PSU $ cd 9352164 $ /oracle/PSU_102049/OPatch/opatch apply Invoking OPatch 10.2.0.5.1 Oracle Interim Patch Installer version 10.2.0.5.1 Copyright (c) 2010, Oracle Corporation. All rights reserved. Oracle Home : /oracle/product/10.2.0/db Central Inventory : /oracle/product/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/10.2.0/db/oui Log file location : /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-11-14_10-02-21AM.log Patch history file: /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch_history.txt ApplySession applying interim patch '9352164' to OH '/oracle/product/10.2.0/db' Interim patch 9352164 is a superset of the patch(es) [ 9352164 ] in the Oracle Home OPatch will rollback the subset patches and apply the given patch. Execution of 'sh /oracle/PSU_102049/9352164/custom/scripts/init -apply 9352164 ': Return Code = 0 Execution of 'sh /oracle/product/10.2.0/db/.patch_storage/9352164_Apr_1_2010_11_28_28/original_patch/custom/scripts/init -rollback 9352164 ': Return Code = 0 Running prerequisite checks... Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes. This node is part of an Oracle Real Application Cluster. Remote nodes: 'pmissodb2' Local node: 'pmissodb1' elease shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/oracle/product/10.2.0/db') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files and inventory (not for auto-rollback) for the Oracle Home Backing up files affected by the patch '9352164' for restore. This might take a while... Backing up files affected by the patch '9352164' for restore. This might take a while... ApplySession rolling back interim patch '9352164' from OH '/oracle/product/10.2.0/db' Execution of 'sh /oracle/product/10.2.0/db/.patch_storage/9352164_Apr_1_2010_11_28_28/original_patch/custom/scripts/pre -rollback 9352164 ': Return Code = 0 Patching component oracle.rdbms.rsf, 10.2.0.4.0... Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qcodfdef.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qcdo.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/kghs.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/kgcc.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/kgh.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qcs.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/kngo.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qcop.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/kgl.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/kgl2.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/kgghs.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qmt.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qmx.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qmx0.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qmxi.o" Updating archive file "/oracle/product/10.2.0/db/lib/libgeneric10.a" with "lib/libgeneric10.a/qmu.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qcodfdef.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qcdo.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/kghs.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/kgcc.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/kgh.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qcs.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/kngo.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qcop.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/kgl.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/kgl2.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/kgghs.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qmt.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qmx.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qmx0.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qmxi.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libgeneric10.a" with "lib32/libgeneric10.a/qmu.o" Updating archive file "/oracle/product/10.2.0/db/lib/libcommon10.a" with "lib/libcommon10.a/kd4.o" Updating archive file "/oracle/product/10.2.0/db/lib/libcommon10.a" with "lib/libcommon10.a/kdb4.o" Updating archive file "/oracle/product/10.2.0/db/lib/libcommon10.a" with "lib/libcommon10.a/kdr4.o" Updating archive file "/oracle/product/10.2.0/db/lib/libcommon10.a" with "lib/libcommon10.a/kdr9ir24.o" Updating archive file "/oracle/product/10.2.0/db/lib/libcommon10.a" with "lib/libcommon10.a/ttcpip.o" Updating archive file "/oracle/product/10.2.0/db/lib/libcommon10.a" with "lib/libcommon10.a/ktsg.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libcommon10.a" with "lib32/libcommon10.a/kd4.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libcommon10.a" with "lib32/libcommon10.a/kdb4.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libcommon10.a" with "lib32/libcommon10.a/kdr4.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libcommon10.a" with "lib32/libcommon10.a/kdr9ir24.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libcommon10.a" with "lib32/libcommon10.a/ttcpip.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libcommon10.a" with "lib32/libcommon10.a/ktsg.o" Updating archive file "/oracle/product/10.2.0/db/lib/libpls10.a" with "lib/libpls10.a/pkr.o" Updating archive file "/oracle/product/10.2.0/db/lib/libpls10.a" with "lib/libpls10.a/pkwrap.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libpls10.a" with "lib32/libpls10.a/pkr.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libpls10.a" with "lib32/libpls10.a/pkwrap.o" Updating jar file "/oracle/product/10.2.0/db/rdbms/jlib/qsma.jar" with "/oracle/product/10.2.0/db/.patch_storage/9352164_Apr_1_2010_11_28_28/files//rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataManager.class" Updating jar file "/oracle/product/10.2.0/db/rdbms/jlib/qsma.jar" with "/oracle/product/10.2.0/db/.patch_storage/9352164_Apr_1_2010_11_28_28/files//rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataReports.class" Updating jar file "/oracle/product/10.2.0/db/rdbms/jlib/qsma.jar" with "/oracle/product/10.2.0/db/.patch_storage/9352164_Apr_1_2010_11_28_28/files//rdbms/jlib/qsma.jar/oracle/qsma/QsmaFileManager.class" Copying file to "/oracle/product/10.2.0/db/rdbms/lib/env_rdbms.mk" Copying file to "/oracle/product/10.2.0/db/rdbms/lib/rfsd.o" Patching component oracle.rdbms.dbscripts, 10.2.0.4.0... Copying file to "/oracle/product/10.2.0/db/rdbms/admin/prvtdefr.plb" Copying file to "/oracle/product/10.2.0/db/rdbms/admin/prvtbpp.plb" Copying file to "/oracle/product/10.2.0/db/rdbms/admin/prvtdmsu.plb" Copying file to "/oracle/product/10.2.0/db/rdbms/admin/prvtbstr.plb" Copying file to "/oracle/product/10.2.0/db/rdbms/admin/prvtsum.plb" Copying file to "/oracle/product/10.2.0/db/rdbms/admin/prvtsms.plb" Copying file to "/oracle/product/10.2.0/db/rdbms/admin/prvtjob.plb" ........................ ........................ ......省略部分内容...... ........................ ........................ Execution of 'sh /oracle/PSU_102049/9352164/custom/scripts/post -apply 9352164 ': Return Code = 0 The local system has been patched. You can restart Oracle instances on it. Patching in rolling mode. The node 'pmissodb2' will be patched next. Please shutdown Oracle instances running out of this ORACLE_HOME on 'pmissodb2'. (Oracle Home = '/oracle/product/10.2.0/db') Is the node ready for patching? [y|n] n User Responded with: N ApplySession exits on request You may exit the patching session and patch remaining nodes later from an un-patched node. Do you want to continue? Do you want to proceed? [y|n] n User Responded with: N Patching aborted on node "pmissodb2", remaining nodes are OPatch failed to propagate the patch to the remote node(s). Run the patch again on each of the remote node(s) using -local option. Details: Patching aborted on node "pmissodb2", remaining nodes are ApplySession failed: OUI-67081:OPatch failed to propagate the patch to the remote node(s). Run the patch again on each of the remote node(s) using -local option. Details: Patching aborted on node "pmissodb2", remaining nodes are System intact, OPatch will not attempt to restore the system -------------------------------------------------------------------------------- The following warnings have occurred during OPatch execution: 1) OUI-67620:Interim patch 9352164 is a superset of the patch(es) [ 9352164 ] in the Oracle Home -------------------------------------------------------------------------------- OPatch failed with error code 73 我这里是分node进行apply PSU，后面的error警告完全可以忽略，为什么我这里不直接输入Y进行呢？ 很简单，因为node之间拷贝文件比较慢，需要通过网络，为了节约时间，我当然选择local node进行apply。 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 |
7. Loading Modified SQL Files into the Database $ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Mon Nov 14 10:21:40 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 503317920 bytes Database Buffers 2701131776 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. SQL> @catbundle.sql PSU apply PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Generating apply and rollback scripts... Check the following file for errors: /oracle/product/10.2.0/db/cfgtoollogs/catbundle/catbundle_PSU_SODB_GENERATE_2011Nov14_10_21_58.log Apply script: /oracle/product/10.2.0/db/rdbms/admin/catbundle_PSU_SODB_APPLY.sql Rollback script: /oracle/product/10.2.0/db/rdbms/admin/catbundle_PSU_SODB_ROLLBACK.sql PL/SQL procedure successfully completed. Executing script file... SQL> SELECT '/oracle/product/10.2.0/db/cfgtoollogs/catbundle/' 2 || 'catbundle_PSU_' 3 || NAME 4 || '_APPLY_' 5 || TO_CHAR (SYSDATE, 6 'YYYYMonDD_hh24_mi_ss', 7 'NLS_DATE_LANGUAGE=''AMERICAN''' 8 ) 9 || '.log' AS spool_file 10 FROM v$database; SQL> SPOOL &spool_file SQL> exec dbms_registry.set_session_namespace('SERVER') PL/SQL procedure successfully completed. SQL> PROMPT Processing Oracle Text... Processing Oracle Text... SQL> ALTER SESSION SET current_schema = ctxsys; Session altered. ........................ ......省略部分内容...... ........................ SQL> SPOOL off SQL> SET echo off Check the following log file for errors: /oracle/product/10.2.0/db/cfgtoollogs/catbundle/catbundle_PSU_SODB_APPLY_2011Nov14_10_22_00.log SQL> @utlrp.sql TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_BGN 2011-11-14 10:24:37 1 row selected. DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid DOC> objects in the database. Recompilation time is proportional to the DOC> number of invalid objects in the database, so this command may take DOC> a long time to execute on a database with a large number of invalid DOC> objects. DOC> DOC> Use the following queries to track recompilation progress: DOC> DOC> 1. Query returning the number of invalid objects remaining. This DOC> number should decrease with time. DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6); DOC> DOC> 2. Query returning the number of objects compiled so far. This number DOC> should increase with time. DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED; DOC> DOC> This script automatically chooses serial or parallel recompilation DOC> based on the number of CPUs available (parameter cpu_count) multiplied DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu). DOC> On RAC, this number is added across all RAC nodes. DOC> DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel DOC> recompilation. Jobs are created without instance affinity so that they DOC> can migrate across RAC nodes. Use the following queries to verify DOC> whether UTL_RECOMP jobs are being created and run correctly: DOC> DOC> 1. Query showing jobs created by UTL_RECOMP DOC> SELECT job_name FROM dba_scheduler_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC> DOC> 2. Query showing UTL_RECOMP jobs that are running DOC> SELECT job_name FROM dba_scheduler_running_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC># PL/SQL procedure successfully completed. TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_END 2011-11-14 10:24:50 1 row selected. PL/SQL procedure successfully completed. DOC> The following query reports the number of objects that have compiled DOC> with errors (objects that compile with errors have status set to 3 in DOC> obj$). If the number is higher than expected, please examine the error DOC> messages reported with each object (using SHOW ERRORS) to see if they DOC> point to system misconfiguration or resource constraints that must be DOC> fixed before attempting to recompile these objects. DOC># OBJECTS WITH ERRORS ------------------- 0 1 row selected. DOC> The following query reports the number of errors caught during DOC> recompilation. If this number is non-zero, please query the error DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors DOC> are due to misconfiguration or resource constraints that must be DOC> fixed before objects can compile successfully. DOC># ERRORS DURING RECOMPILATION --------------------------- 0 1 row selected. PL/SQL procedure successfully completed. |
|
1 2 3 4 5 6 |
8. check error cd $ORACLE_HOME/cfgtoollogs/catbundle catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 |
9. Recompiling Views in the Database SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile; System altered. SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> STARTUP UPGRADE ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options $ cd $ORACLE_HOME/cpu/view_recompile $ ls -ltr *2008*.sql -rwxr-xr-x 1 oracle dba 5143 Apr 01 2010 view_recompile_jan2008cpu.sql -rwxr-xr-x 1 oracle dba 2095 Apr 01 2010 recompile_precheck_jan2008cpu.sql $ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Mon Nov 14 10:27:08 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, OLAP, Data Mining and Real Application Testing options SQL> show parameter instance NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ active_instance_count integer cluster_database_instances integer 1 instance_groups string instance_name string sodb1 instance_number integer 1 instance_type string RDBMS open_links_per_instance integer 4 parallel_instance_group string parallel_server_instances integer 1 SQL> @view_recompile_jan2008cpu.sql PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. viewrecomp.sql script is already applied PL/SQL procedure successfully completed. 1 row created. Commit complete. PL/SQL procedure successfully completed. Logfile for the current viewrecomp.sql session is : vcomp_SODB_14Nov2011_10_27_15.log SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup nomount ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile; SQL> shutdown immediate; ORA-01507: database not mounted SQL> startup ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------- 0 同时在node2上对amb库进行如上操作，此处省略。 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
++++++ Apply PSU 10.2.0.4.9 ++++++ 1. 停止所有instance 2. check One-off Patch Conflict Detection $ /oracle/PSU_102049/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./12419397 Invoking OPatch 10.2.0.5.1 Oracle Interim Patch Installer version 10.2.0.5.1 Copyright (c) 2010, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /oracle/product/10.2.0/db Central Inventory : /oracle/product/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/10.2.0/db/oui Log file location : /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-11-14_10-46-46AM.log Patch history file: /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch_history.txt Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 |
3. Apply PSU $ cd 124* $ /oracle/PSU_102049/OPatch/opatch apply Invoking OPatch 10.2.0.5.1 Oracle Interim Patch Installer version 10.2.0.5.1 Copyright (c) 2010, Oracle Corporation. All rights reserved. Oracle Home : /oracle/product/10.2.0/db Central Inventory : /oracle/product/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/10.2.0/db/oui Log file location : /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-11-14_10-48-46AM.log Patch history file: /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch_history.txt ApplySession applying interim patch '12419397' to OH '/oracle/product/10.2.0/db' Running prerequisite checks... Patch 12419397: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.4.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.4.0 ] Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes. This node is part of an Oracle Real Application Cluster. Remote nodes: 'pmissodb2' Local node: 'pmissodb1' elease shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/oracle/product/10.2.0/db') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files and inventory (not for auto-rollback) for the Oracle Home Backing up files affected by the patch '12419397' for restore. This might take a while... Backing up files affected by the patch '12419397' for rollback. This might take a while... Execution of 'sh /oracle/PSU_102049/12419397/custom/scripts/pre -apply 12419397 ': Return Code = 0 Patching component oracle.rdbms, 10.2.0.4.0... Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kwqit.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kkzl.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kkxe.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kzu.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kzvdve.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kzvutil.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kpolon.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kkxs.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kza.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/dmsvma.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/qxim.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/kkxm.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/qeroc.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/qeroi.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/qmix.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/qmxtk.o" Updating archive file "/oracle/product/10.2.0/db/lib/libserver10.a" with "lib/libserver10.a/evah2p.o" Copying file to "/oracle/product/10.2.0/db/rdbms/admin/bundledata_OPSU.xml" Copying file to "/oracle/product/10.2.0/db/rdbms/lib/kkxwtp.o" Copying file to "/oracle/product/10.2.0/db/PSU/10.2.0.4.9/catoPSU.sql" Copying file to "/oracle/product/10.2.0/db/PSU/10.2.0.4.9/catoPSU_rollback.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/amdcpu.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/apscpu.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/xoqcpu.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/bug9758569.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/bug8635726.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/bug9871112.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/bug9687193.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/patch_9389915.sql" Copying file to "/oracle/product/10.2.0/db/cpu/scripts/emdb_recomp_invalids.sql" Patching component oracle.xdk.rsf, 10.2.0.4.0... Updating archive file "/oracle/product/10.2.0/db/lib/libxml10.a" with "lib/libxml10.a/lpxpar.o" Updating archive file "/oracle/product/10.2.0/db/lib/libxml10.a" with "lib/libxml10.a/lpxm.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libxml10.a" with "lib32/libxml10.a/lpxpar.o" Updating archive file "/oracle/product/10.2.0/db/lib32/libxml10.a" with "lib32/libxml10.a/lpxm.o" .......................... .......................... .......省略部分内容....... .......................... .......................... Verifying the update... Inventory check OK: Patch ID 12419397 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 12419397 are present in Oracle Home. The local system has been patched. You can restart Oracle instances on it. Patching in rolling mode. The node 'pmissodb2' will be patched next. Please shutdown Oracle instances running out of this ORACLE_HOME on 'pmissodb2'. (Oracle Home = '/oracle/product/10.2.0/db') Is the node ready for patching? [y|n] n User Responded with: N ApplySession exits on request You may exit the patching session and patch remaining nodes later from an un-patched node. Do you want to continue? Do you want to proceed? [y|n] n User Responded with: N Patching aborted on node "pmissodb2", remaining nodes are OPatch failed to propagate the patch to the remote node(s). Run the patch again on each of the remote node(s) using -local option. Details: Patching aborted on node "pmissodb2", remaining nodes are ApplySession failed: OUI-67081:OPatch failed to propagate the patch to the remote node(s). Run the patch again on each of the remote node(s) using -local option. Details: Patching aborted on node "pmissodb2", remaining nodes are System intact, OPatch will not attempt to restore the system OPatch failed with error code 73 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 |
4. Loading Modified SQL Files into the Database SQL> startup ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. SQL> @catbundle.sql oPSU apply PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Generating apply and rollback scripts... Check the following file for errors: /oracle/product/10.2.0/db/cfgtoollogs/catbundle/catbundle_OPSU_SODB_GENERATE_2011Nov14_10_56_17.log Apply script: /oracle/product/10.2.0/db/rdbms/admin/catbundle_OPSU_SODB_APPLY.sql Rollback script: /oracle/product/10.2.0/db/rdbms/admin/catbundle_OPSU_SODB_ROLLBACK.sql PL/SQL procedure successfully completed. Executing script file... SQL> SELECT '/oracle/product/10.2.0/db/cfgtoollogs/catbundle/' 2 || 'catbundle_OPSU_' 3 || NAME 4 || '_APPLY_' 5 || TO_CHAR (SYSDATE, 6 'YYYYMonDD_hh24_mi_ss', 7 'NLS_DATE_LANGUAGE=''AMERICAN''' 8 ) 9 || '.log' AS spool_file 10 FROM v$database; SQL> SPOOL &spool_file SQL> exec dbms_registry.set_session_namespace('SERVER') PL/SQL procedure successfully completed. SQL> PROMPT Skipping Oracle Enterprise Manager because it is not installed or versions mismatch... Skipping Oracle Enterprise Manager because it is not installed or versions mismatch... SQL> PROMPT Processing JAVAVM Option... Processing JAVAVM Option... SQL> ALTER SESSION SET current_schema = sys; Session altered. SQL> @?/cpu/scripts/bug9758569.sql SQL> BEGIN 2 initjvmaux.exec 3 ('revoke execute on "oracle/aurora/vm/HotLoader" from public'); 4 EXCEPTION 5 WHEN OTHERS 6 THEN 7 IF SQLCODE NOT IN (-1927) 8 THEN 9 RAISE; 10 END IF; 11 END; 12 / revoke execute on "oracle/aurora/vm/HotLoader" from public PL/SQL procedure successfully completed. SQL> PROMPT Processing OLAP Analytic Workspace... Processing OLAP Analytic Workspace... SQL> ALTER SESSION SET current_schema = sys; Session altered. SQL> @?/cpu/scripts/apscpu.sql SQL> Rem SQL> Rem $Header: oraolap/admin/apscpu.sql st_oraolap_glyon_bug-9751398_a/2 2010/06/23 11:37:16 glyon Exp $ SQL> Rem SQL> Rem apscpu.sql SQL> Rem SQL> Rem Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. SQL> Rem SQL> Rem NAME SQL> Rem apscpu.sql SQL> Rem SQL> Rem DESCRIPTION SQL> Rem Install CPU/PSU SQL> Rem SQL> Rem NOTES SQL> Rem This script copies code from cataps.sql. Any changes should be SQL> Rem made to both scripts. SQL> Rem SQL> Rem MODIFIED (MM/DD/YY) SQL> Rem glyon 06/23/10 - Created; adapted from apspatch.sql SQL> Rem SQL> SQL> Rem Set the APS registry component to Upgrading SQL> execute sys.dbms_registry.upgrading('APS'); PL/SQL procedure successfully completed. SQL> Rem copied from cataps.sql SQL> CREATE OR REPLACE PROCEDURE aps_validate IS 2 AWok BOOLEAN; 3 OBJok BOOLEAN; 4 x NUMBER; -- dummy output spot 5 junklob CLOB; 6 BEGIN 7 8 -- AWs are valid if we can read an option 9 BEGIN 10 junklob := dbms_aw.INTERP('show SESSCACHE'); 11 AWok := TRUE; 12 EXCEPTION 13 WHEN OTHERS THEN 14 AWok := FALSE; 15 END; 16 17 -- supporting object things 18 BEGIN 19 SELECT 0 INTO x FROM DBA_OBJECTS 20 WHERE STATUS = 'INVALID' AND rownum <=1 AND 21 OWNER='SYS' AND OBJECT_NAME IN 22 ('OLAP_TABLE', 'OLAPIMPL_T', 'OLAP_SRF_T', 'OLAP_NUMBER_SRF', 23 'OLAP_EXPRESSION', 'OLAP_TEXT_SRF', 'OLAP_EXPRESSION_TEXT', 24 'OLAP_BOOL_SRF', 'OLAP_EXPRESSION_BOOL'); 25 -- at least one object is invalid so component is invalid 26 OBJok := FALSE; 27 EXCEPTION 28 WHEN NO_DATA_FOUND THEN 29 -- no invalid objects were found so component is valid 30 OBJok := TRUE; 31 END; 32 33 IF AWok AND OBJok THEN 34 dbms_registry.valid('APS'); 35 ELSE 36 dbms_registry.invalid('APS'); 37 END IF; 38 END; 39 / Procedure created. SQL> @?/olap/admin/xumuts.plb SQL> alter table ps$ initrans 4; Table altered. ........................ ........................ ......省略部分内容...... ........................ ........................ |
|
1 2 3 4 5 |
5. Check error cd $ORACLE_HOME/cfgtoollogs/catbundle catbundle_OPSU_<database SID>_APPLY_<TIMESTAMP>.log catbundle_OPSU_<database SID>_GENERATE_<TIMESTAMP>.log |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
6. Check invalid objects SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile; System altered. SQL> SHUTDOWN ORA-01507: database not mounted ORACLE instance shut down. SQL> STARTUP UPGRADE ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. SQL> @view_recompile_jan2008cpu.sql PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. viewrecomp.sql script is already applied PL/SQL procedure successfully completed. 1 row created. Commit complete. PL/SQL procedure successfully completed. Logfile for the current viewrecomp.sql session is : vcomp_SODB_14Nov2011_11_00_56.log SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile; System altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2087520 bytes Variable Size 520095136 bytes Database Buffers 2684354560 bytes Redo Buffers 14688256 bytes Database mounted. Database opened. |
|
1 2 3 4 5 6 7 8 9 |
7. Check invalid objects SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------- 0 如上操作同时在另外一个node操作以及另外的数据库amb进行。 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 |
8. Check PSU $ /oracle/PSU_102049/OPatch/opatch lsinventory -all Invoking OPatch 10.2.0.5.1 Oracle Interim Patch Installer version 10.2.0.5.1 Copyright (c) 2010, Oracle Corporation. All rights reserved. Oracle Home : /oracle/product/10.2.0/db Central Inventory : /oracle/product/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/10.2.0/db/oui Log file location : /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-11-14_12-33-55PM.log Patch history file: /oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch_history.txt Lsinventory Output file location : /oracle/product/10.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2011-11-14_12-33-55PM.txt -------------------------------------------------------------------------------- List of Oracle Homes: Name Location CRSHOME /oracle/product/10.2.0/crs ORACLEHOME /oracle/product/10.2.0/db 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 (3) : Patch 12419397 : applied on Mon Nov 14 10:50:55 CST 2011 Unique Patch ID: 13919247 Created on 10 Jul 2011, 08:06:28 hrs PST8PDT Bugs fixed: 12566124, 12566141, 12566142, 12566126, 12566143, 9573054, 12419397 12566129, 9714832, 11725015, 10014012, 11787762, 11787763, 10249540 11787764, 10014015, 11787765, 11724977, 9952234, 11787766, 10325885 10248636, 11787767, 10013975, 9173248, 9678690, 7609058, 9952272, 9678695 9678697, 12566131, 9713537, 12566134, 9655017, 12566136, 9654991 12566137, 12566139, 9442335, 10014009, 10325878, 8309642, 12419249, 12566121 This patch overlays patches: 9352164 This patch needs patches: 9352164 as prerequisites Patch 9352164 : applied on Mon Nov 14 10:07:46 CST 2011 Unique Patch ID: 12327708 Created on 1 Apr 2010, 11:28:28 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, 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 9572766 : applied on Tue Sep 27 11:04:47 CDT 2011 Unique Patch ID: 12379668 Created on 9 Apr 2010, 19:25:49 hrs PST8PDT Bugs fixed: 6994194, 8830147 Rac system comprising of multiple nodes Local node = pmissodb1 Remote node = pmissodb2 -------------------------------------------------------------------------------- OPatch succeeded. |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
9. 启动数据库，启动listener，测试应用 $ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....b1.inst application ONLINE ONLINE pmissodb1 ora....b2.inst application ONLINE ONLINE pmissodb2 ora.amb.db application ONLINE ONLINE pmissodb1 ora....B1.lsnr application ONLINE ONLINE pmissodb1 ora....db1.gsd application ONLINE ONLINE pmissodb1 ora....db1.ons application ONLINE ONLINE pmissodb1 ora....db1.vip application ONLINE ONLINE pmissodb1 ora....B2.lsnr application ONLINE ONLINE pmissodb2 ora....db2.gsd application ONLINE ONLINE pmissodb2 ora....db2.ons application ONLINE ONLINE pmissodb2 ora....db2.vip application ONLINE ONLINE pmissodb2 ora.sodb.db application ONLINE ONLINE pmissodb2 ora....b1.inst application ONLINE ONLINE pmissodb1 ora....b2.inst application ONLINE ONLINE pmissodb2 |
2 Responses to “Step_by_step apply PSU(10.2.0.4.9) for RAC (AIX)”
Prereq “checkConflictAgainstOHWithDetail” failed.
这里显示都失败了。
Patches that can be applied now without any conflicts are :
9352164
Leave a Reply
You must be logged in to post a comment.