甜橘子，专注成都网站制作网站设计与营销型网站建设与优化
QQ :532337155
电话：028-86922220
Oracle 10g RAC 升级（CPU Update）之--升级CRS
创新互联建站专注为客户提供全方位的互联网综合服务，包含不限于网站设计、网站建设、林芝网络推广、微信小程序开发、林芝网络营销、林芝企业策划、林芝品牌公关、搜索引擎seo、人物专访、企业宣传片、企业代运营等，从售前售中售后，我们都将竭诚为您服务，您的肯定，是我们最大的嘉奖；创新互联建站为所有大学生创业者提供林芝建站搭建服务，24小时服务热线：028-86922220，官方网址：www.cdcxhl.com
系统环境：
操作系统：RedHat EL5
Cluster： Oracle CRS 10.2.0.1.0
Oracle： Oracle 10.2.0.1.0
如图所示：RAC 系统架构
案例：
本案例是从 Oracle 10.2.0.1.0 升级到10.2.0.4.0，作为Oracle的补丁升级（CPU Update）。
升级步骤：
1、CRS 升级（对于CRS 升级可以采用滚动升级，本案例采用了滚动升级）
2、Oracle 软件升级
3、DataBase 升级（可以采用dbua 或 sqlplus 命令升级）
一、升级CRS (ROLLING UPDATE)
升级前的准备：
[oracle@node1 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 12 14:57:24 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> select instance_name,status from gv$instance; INSTANCE_NAME STATUS ---------------- ------------ prod1 OPEN prod2 OPEN SQL> show parameter sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 272M sga_target big integer 272M SQL> alter system set sga_max_size=600m scope=spfile; System altered. SQL> alter system set sga_target=600m scope=spfile; System altered. SQL> show parameter shared NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ shared_pool_size big integer 0 SQL> alter system set shared_pool_size=200m scope=spfile; System altered. SQL> alter system set java_pool_size=300m scope=spfile; System altered. SQL> startup force nomount; ORACLE instance started. Total System Global Area 629145600 bytes Fixed Size 1220988 bytes Variable Size 524291716 bytes Database Buffers 100663296 bytes Redo Buffers 2969600 bytes SQL> show parameter share NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ shared_pool_size big integer 200M shared_server_sessions integer SQL> show parameter java NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ java_pool_size big integer 300M
1)先在node1上进行升级
在node1上升级CRS:
[root@node1 ~]# uname -a Linux node1 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:43 EDT 2010 i686 i686 i386 GNU/Linux [root@node1 ~]# crsctl query crs softwareversion CRS software version on node [node1] is [10.2.0.1.0] [root@node1 ~]# crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy [root@node1 ~]# 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 node1 ora....d1.inst application ONLINE ONLINE node1 ora....d2.inst application ONLINE ONLINE node2 在node1上关闭Instance： [oracle@node1 ~]$ srvctl stop instance -d prod -i prod1 在node1上关闭ASM： [oracle@node1 ~]$ srvctl stop asm -n node1 在node1上关闭nodeapps： [oracle@node1 ~]$ srvctl stop nodeapps -n node1 [oracle@node1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application OFFLINE OFFLINE ora....E1.lsnr application OFFLINE OFFLINE ora.node1.gsd application OFFLINE OFFLINE ora.node1.ons application OFFLINE OFFLINE ora.node1.vip application OFFLINE OFFLINE 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 node1 ora....d1.inst application OFFLINE OFFLINE ora....d2.inst application ONLINE ONLINE node2
2）下载和解压补丁软件（对于RAC升级CRS和Oracle软件都是用相同的补丁软件）
[oracle@node1 ~]$ unzip p6810189_10204_Linux-x86.zip
升级CRS 10.2.0.1.0 到 10.2.0.4.0，如下图所示：
以Oracle用户的身份执行：runInstaller
开始升级
注意升级目录：应该是CRS的安装目录
升级安装
补丁软件升级过程
按照提示执行script
[root@node1 ~]# crsctl stop crs
Stopping resources. Successfully stopped CRS resources Stopping CSSD. Shutting down CSS daemon. Shutdown request successfully issued.
[root@node1 ~]# /u01/crs_1/install/root102.sh
