Oracle 10g RAC 升级(CPU Update)之--升级数据库
系统环境:
操作系统:RedHat EL5
Cluster: Oracle CRS 10.2.0.1.0
Oracle: Oracle 10.2.0.1.0
如图所示:RAC 系统架构
三、升级数据库
数据库的升级需要关闭DataBase,可以采用DBUA以图形的方式升级,也可以采用sqlplus 命令(catupgrd.sql 脚本),本案例采用dbua方式升级。
[root@node2 ~]# srvctl start listener -n node1
[root@node2 ~]# srvctl start listener -n node2
[root@node2 ~]# srvctl start asm -n node1
[root@node2 ~]# srvctl start asm -n node2
[root@node2 ~]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
ora.prod.db application OFFLINE OFFLINE
ora....d1.inst application OFFLINE OFFLINE
ora....d2.inst application OFFLINE OFFLINE
以Oracle身份,执行dbua 开始升级:
执行dbua,开始升级
选择“Update DataBase"
升级数据库:prod
升级后,编译失效Object
指定Recovery Area
升级summary
升级组件
升级完成后,在所有node执行以下脚本:
[root@node1 ~]# su - oracle [oracle@node1 ~]$ /u01/app/oracle/product/10.2.0/db_1/install/changePerm.sh ------------------------------------------------------------------------------- Disclaimer: The purpose of this script is to relax permissions on some of the files in the database Oracle Home so that all clients can access them. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. Running this script should be done only after considering all security ramifications. ------------------------------------------------------------------------------- Do you wish to continue (y/n) [n]: y Spooling the error log /tmp/changePerm_err.log... Finished running the script successfully [oracle@node2 ~]$ /u01/app/oracle/product/10.2.0/db_1/install/changePerm.sh ------------------------------------------------------------------------------- Disclaimer: The purpose of this script is to relax permissions on some of the files in the database Oracle Home so that all clients can access them. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. Running this script should be done only after considering all security ramifications. ------------------------------------------------------------------------------- Do you wish to continue (y/n) [n]: y Spooling the error log /tmp/changePerm_err.log... Finished running the script successfully
升级后验证:
[oracle@node2 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 12 17:41:19 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME STATUS
---------------- ------------
prod2 OPEN
prod1 OPEN
SQL> col COMP_NAME for a40
SQL> col version for a30
SQL> set linesize 120
SQL> select comp_name,version,status from dba_registry
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
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
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
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
18 rows selected.
[oracle@node2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
ora.prod.db application ONLINE ONLINE node2
ora....d1.inst application ONLINE ONLINE node1
ora....d2.inst application ONLINE ONLINE node2
@至此,RAC的升级任务全部完成,时长在4个小时左右!
转载于:https://blog.51cto.com/tiany/1410272