Oracle 10g RAC 升級(jí)（CPU Update）之--升級(jí)CRS
創(chuàng)新互聯(lián)建站專(zhuān)注為客戶(hù)提供全方位的互聯(lián)網(wǎng)綜合服務(wù)，包含不限于網(wǎng)站設(shè)計(jì)、網(wǎng)站建設(shè)、林芝網(wǎng)絡(luò)推廣、微信小程序開(kāi)發(fā)、林芝網(wǎng)絡(luò)營(yíng)銷(xiāo)、林芝企業(yè)策劃、林芝品牌公關(guān)、搜索引擎seo、人物專(zhuān)訪(fǎng)、企業(yè)宣傳片、企業(yè)代運(yùn)營(yíng)等，從售前售中售后，我們都將竭誠(chéng)為您服務(wù)，您的肯定，是我們最大的嘉獎(jiǎng)；創(chuàng)新互聯(lián)建站為所有大學(xué)生創(chuàng)業(yè)者提供林芝建站搭建服務(wù)，24小時(shí)服務(wù)熱線(xiàn)：028-86922220，官方網(wǎng)址：www.cdcxhl.com
系統(tǒng)環(huán)境：
操作系統(tǒng)：RedHat EL5
Cluster： Oracle CRS 10.2.0.1.0
Oracle： Oracle 10.2.0.1.0
如圖所示：RAC 系統(tǒng)架構(gòu)
案例：
本案例是從 Oracle 10.2.0.1.0 升級(jí)到10.2.0.4.0，作為Oracle的補(bǔ)丁升級(jí)（CPU Update）。
升級(jí)步驟：
1、CRS 升級(jí)（對(duì)于CRS 升級(jí)可以采用滾動(dòng)升級(jí)，本案例采用了滾動(dòng)升級(jí)）
2、Oracle 軟件升級(jí)
3、DataBase 升級(jí)（可以采用dbua 或 sqlplus 命令升級(jí)）
一、升級(jí)CRS (ROLLING UPDATE)
升級(jí)前的準(zhǔn)備：
[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上進(jìn)行升級(jí)
在node1上升級(jí)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上關(guān)閉Instance： [oracle@node1 ~]$ srvctl stop instance -d prod -i prod1 在node1上關(guān)閉ASM： [oracle@node1 ~]$ srvctl stop asm -n node1 在node1上關(guān)閉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）下載和解壓補(bǔ)丁軟件（對(duì)于RAC升級(jí)CRS和Oracle軟件都是用相同的補(bǔ)丁軟件）
[oracle@node1 ~]$ unzip p6810189_10204_Linux-x86.zip
升級(jí)CRS 10.2.0.1.0 到 10.2.0.4.0，如下圖所示：
以O(shè)racle用戶(hù)的身份執(zhí)行：runInstaller
開(kāi)始升級(jí)
注意升級(jí)目錄：應(yīng)該是CRS的安裝目錄
升級(jí)安裝
補(bǔ)丁軟件升級(jí)過(guò)程
按照提示執(zhí)行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
重慶分公司
重慶分公司
