sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 产品DBA > Oracle RAC >

【学习笔记】Oracle 10G RAC升级笔记 10.2.0.1升级至10.2.0.4.4过程笔记

时间:2016-11-25 23:20   来源:Oracle研究中心   作者:网络   点击:

天萃荷净 Oracle研究中心学习笔记:分享一篇关于Oracle RAC升级的文章,该文章详细记录了Oracle10.2.0.1升级至10.2.0.4.4的详细步骤。

本站文章除注明转载外,均为本站原创: 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: Step_by_step apply PSU(10.2.0.4.9) for RAC (AIX)

由于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。


如下是今天对一套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 bOracleоytes
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 cmpleted.
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 iterim 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

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【学习笔记】Oracle 10G RAC升级笔记 10.2.0.1升级至10.2.0.4.4过程笔记

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1325.html

Oracle研究中心

关键词:

Oracle 10G RAC详细步骤

Oracle 10.2.0.1 TO 10.2.0.4.4详细过程