由于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的说明详见链接:
10.2.0.4+版本PSU以及相关bundle patch列表–New
如下是今天对一套10.2.0.4.0 rac（aix）进行apply PSU的全过程。
这次打PSU相对麻烦的是，这套rac中存在2个库，sodb和amb，详细过程如下：
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
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
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
4. 解压PSU以及Opatch
unzip p9352164_10204_AIX5L.zip
unzip p12419397_10204_AIX5L.zip
unzip p6880880_102000_AIX64-5L.zip
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.
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。
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.
8. check error
cd $ORACLE_HOME/cfgtoollogs/catbundle
catbundle_PSU__APPLY_.log
catbundle_PSU__GENERATE_.log
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库进行如上操作，此处省略。
++++++ 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.
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
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.
........................
........................
......省略部分内容......
........................
........................
5. Check error
cd $ORACLE_HOME/cfgtoollogs/catbundle
catbundle_OPSU__APPLY_.log
catbundle_OPSU__GENERATE_.log
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.
7. Check invalid objects
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
如上操作同时在另外一个node操作以及另外的数据库amb进行。
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.
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
发表回复