将102011RAC升级到102040

将102011RAC升级到102040

补丁：6810189

VMware workstation下安装

Vmware version:  9

OS:ORACLE LINUX 5.6_64位

 DATABASE: 10201_64位

完全关掉RAC

o10n1->emctl stop dbconsole

o10n1->isqlplusctl stop

o10n1->srvctl stop service -d bamuta

o10n1->srvctl stop database -d bamuta

o10n1->srvctl stop asm -n o10n1

o10n1->srvctl stop asm -n o10n2

o10n1->srvctl stop nodeapps -n o10n1

o10n1->srvctl stop nodeapps -n o10n2

[root@o10n1 ~]# crsctl stop crs

[root@o10n2 ~]# crsctl stop crs

 

备份数据

升级CRS

这个补丁包包括了CRS和DATABASE，在如下的界面，选择CRS的路径

还需要运行以下脚本：

[root@o10n1 ~]# crsctl stop crs

[root@o10n1 ~]# /oracle/product/10.2.0/crs/install/root102.sh

验证CRS版本：

o10n1->crsctl query crs softwareversiono10n1

CRS software version on node [o10n1] is[10.2.0.4.0]

o10n1->crsctl querycrs softwareversion o10n2

CRS software version on node [o10n2] is[10.2.0.1.0]

节点2也要运行该脚本

[root@o10n2 ~]# /etc/init.d/init.crs stop

[root@o10n2 ~]#/oracle/product/10.2.0/crs/install/root102.sh

o10n1->crsctl query crs softwareversiono10n2

CRS software version on node [o10n2] is[10.2.0.4.0]

 

升级database soft

查看集群升级的结果

[root@o10n2 ~]# crsctl query crssoftwareversion o10n1

CRS software version on node [o10n1] is [10.2.0.4.0]

[root@o10n2 ~]# crsctl query crssoftwareversion o10n2

CRS software version on node [o10n2] is[10.2.0.4.0]

 

关闭所有应用

# crs_stop –all

[root@o10n2 ~]# crs_stat -t

Name           Type           Target    State    Host       

------------------------------------------------------------

ora....a1.inst application    OFFLINE  OFFLINE              

ora....a2.inst application    OFFLINE  OFFLINE              

ora.bamuta.db  application   OFFLINE   OFFLINE              

ora....SM1.asm application    OFFLINE  OFFLINE              

ora....N1.lsnr application    OFFLINE  OFFLINE              

ora.o10n1.gsd  application   OFFLINE   OFFLINE              

ora.o10n1.ons  application   OFFLINE   OFFLINE              

ora.o10n1.vip  application   OFFLINE   OFFLINE              

ora....SM2.asm application    OFFLINE  OFFLINE              

ora....N2.lsnr application    OFFLINE  OFFLINE              

ora.o10n2.gsd  application   OFFLINE   OFFLINE              

ora.o10n2.ons  application   OFFLINE   OFFLINE              

ora.o10n2.vip  application   OFFLINE   OFFLINE 

 

最好关的彻底一些

/etc/init.d/init.crs stop

 

这个失败可以直接重新安装

 

下面选择db目录

 

升级database

不升级database的问题

如果只升级了database soft，而没有升级database,会有下面的情况发生

[root@o10n1 ~]# crs_stat -t

Name           Type           Target    State    Host       

------------------------------------------------------------

ora....a1.inst application    OFFLINE  OFFLINE              

ora....a2.inst application    OFFLINE  OFFLINE              

ora.bamuta.db  application   OFFLINE   OFFLINE              

ora....SM1.asm application    ONLINE   ONLINE    o10n1      

ora....N1.lsnr application    ONLINE   ONLINE    o10n1      

ora.o10n1.gsd  application   ONLINE    ONLINE    o10n1      

ora.o10n1.ons  application   ONLINE    ONLINE    o10n1      

ora.o10n1.vip  application   ONLINE    ONLINE    o10n1      

ora....SM2.asm application    ONLINE   ONLINE    o10n2      

ora....N2.lsnr application    ONLINE   ONLINE    o10n2      

ora.o10n2.gsd  application   ONLINE    ONLINE    o10n2      

ora.o10n2.ons  application   ONLINE    ONLINE    o10n2      

ora.o10n2.vip  application   ONLINE    ONLINE    o10n2 

 

上面CRS和db soft升级完后database是没有启动的。

 

手工启动：

[root@o10n1 ~]# srvctl start database -dbamuta

PRKP-1001 : Error starting instance bamuta1on node o10n1

CRS-0215: Could not start resource'ora.bamuta.bamuta1.inst'.

PRKP-1001 : Error starting instance bamuta2on node o10n2

CRS-0215: Could not start resource'ora.bamuta.bamuta2.inst'.

但是启动不起来

 

Errors in file/oracle/product/10.2.0/db_1/admin/bamuta/udump/bamuta1_ora_13113.trc:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened withUPGRADE option

Tue Dec 3 13:41:44 2013

Error 704 happened during db open, shuttingdown database

USER: terminating instance due to error 704

Tue Dec 3 13:41:44 2013

Errors in file/oracle/product/10.2.0/db_1/admin/bamuta/bdump/bamuta1_lmd0_12955.trc:

ORA-00704: bootstrap process failure

Tue Dec 3 13:41:44 2013

Errors in file/oracle/product/10.2.0/db_1/admin/bamuta/bdump/bamuta1_lms0_12957.trc:

ORA-00704: bootstrap process failure

Tue Dec 3 13:41:44 2013

Errors in file/oracle/product/10.2.0/db_1/admin/bamuta/bdump/bamuta1_lms1_12961.trc:

ORA-00704: bootstrap process failure

Instance terminated by USER, pid = 13113

ORA-1092 signalled during: ALTER DATABASEOPEN...

 

Trace里面的内容类似

Rcvr 2 state 0x0

 rbufs tot 1100  in_ksxp 1100  ubufs 0 free 20

 msgs rdyq 0  watq 0  nsq 0 routq 1100

 rmpool: alloc 1101  avail 20

 ibatch: 2[0] 3[0] 4[0] 5[0] 6[0] 7[0] 8[0] 9[0] 10[0] 11[0]

 ibatch: 12[0] 13[0] 14[0] 15[0] 16[0] 17[0] 18[0] 19[0] 20[0]

 ibatch: 21[0] sum 0

         rcvs 0 tot msgs 0 max sz 0 avg sz 0

 pbatch: 2[0] 3[0] 4[0] 5[0] 6[0] 7[0] 8[0] 9[0] 10[0] 11[0]

 pbatch: 12[0] 13[0] 14[0] 15[0] 16[0] 17[0] 18[0] 19[0] 20[0]

 pbatch: 21[0] sum 0

         rcvs 1 tot msgs 1 max sz 1 avg sz 0

 DEFER MSG QUEUE ON LMS1 IS EMPTY

 SEQUENCES:

 0:0.0  1:0.0

error 704 detected in background process

ORA-00704: bootstrap process failure

 

 

使用DBUA升级database

 

先升级ASM

 

ASM提示不需要升级

 

再升级database

 

 

其中OEM升级失败，不过压根就不用，需要用后面可以手工重新安装。

 

 

升级完所有进程会自动起来

[root@o10n1 OPatch]# crs_stat -t

Name           Type           Target    State    Host       

------------------------------------------------------------

ora....a1.inst application    ONLINE   ONLINE    o10n1      

ora....a2.inst application    ONLINE   ONLINE    o10n2      

ora.bamuta.db  application   ONLINE    ONLINE    o10n2      

ora....SM1.asm application    ONLINE   ONLINE    o10n1      

ora....N1.lsnr application    ONLINE   ONLINE    o10n1      

ora.o10n1.gsd  application    ONLINE   ONLINE    o10n1      

ora.o10n1.ons  application   ONLINE    ONLINE    o10n1      

ora.o10n1.vip  application   ONLINE    ONLINE    o10n1      

ora....SM2.asm application    ONLINE   ONLINE    o10n2      

ora....N2.lsnr application    ONLINE   ONLINE    o10n2      

ora.o10n2.gsd  application   ONLINE    ONLINE    o10n2      

ora.o10n2.ons  application   ONLINE    ONLINE    o10n2      

ora.o10n2.vip  application   ONLINE    ONLINE    o10n2

简单验证下

SQL> select * from V$version;

 

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise EditionRelease 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE   10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 -Production

NLSRTL Version 10.2.0.4.0 – Production

 

SQL>select comp_name,version,status from sys.dba_registry

Oracle Enterprise Manager                10.2.0.4.0           VALID

Spatial                                 10.2.0.4.0           VALID

Oracle interMedia                        10.2.0.4.0           VALID

OLAP Catalog                             10.2.0.4.0           VALID

Oracle XML Database                      10.2.0.4.0           VALID

Oracle Text                              10.2.0.4.0           VALID

Oracle Expression Filter                 10.2.0.4.0           VALID

Oracle Rule Manager                      10.2.0.4.0           VALID

Oracle Workspace Manager                 10.2.0.4.3           VALID

Oracle Data Mining                       10.2.0.4.0           VALID

Oracle Database Catalog Views            10.2.0.4.0           VALID

Oracle Database Packages and Types       10.2.0.4.0           VALID

JServer JAVA Virtual Machine             10.2.0.4.0           VALID

Oracle XDK                               10.2.0.4.0           VALID

Oracle Database Java Packages            10.2.0.4.0           VALID

OLAP Analytic Workspace                  10.2.0.4.0           VALID

Oracle OLAP API                          10.2.0.4.0           VALID

Oracle Real Application Clusters         10.2.0.4.0           VALID