将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