溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
Oracle 10g RAC 升級（CPU Update）之--升級CRS
系統環境：
操作系統：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
Creating pre-patch directory for saving pre-patch clusterware files Completed patching clusterware files to /u01/crs_1 Relinking some shared libraries. Relinking of patched files is complete. WARNING: directory '/u01' is not owned by root Preparing to recopy patched init and RC scripts. Recopying init and RC scripts. Startup will be queued to init within 30 seconds. Starting up the CRS daemons. Waiting for the patched CRS daemons to start. This may take a while on some systems. . 10204 patch successfully applied. clscfg: EXISTING configuration version 3 detected. clscfg: version 3 is 10G Release 2. Successfully accumulated necessary OCR keys. Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897. node <nodenumber>: <nodename> <private interconnect name> <hostname> node 1: node1 node1-priv node1 Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. clscfg -upgrade completed successfully [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 node2 ora....d1.inst application ONLINE ONLINE node1 ora....d2.inst application ONLINE ONLINE node2 [oracle@node1 ~]$ crsctl query crs softwareversion CRS software version on node [node1] is [10.2.0.4.0] [oracle@node1 ~]$
node1 的CRS升級成功！
3）升級node2的CRS(步驟與node1相同）
[root@node1 ~]# srvctl stop instance -d prod -i prod2 [root@node1 ~]# srvctl stop asm -n node2 [root@node1 ~]# srvctl stop nodeapps -n node2
以下為升級過程過程中與node1不同的畫面：
選擇“select all”
升級軟件安裝完成后，按照提示執行script
[root@node2 ~]# crsctl stop crs [root@node2 ~]# /u01/crs_1/install/root102.sh
[root@node2 ~]# crsctl query crs softwareversion CRS software version on node [node2] is [10.2.0.4.0]
node2的CRS升級完成！
[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 node2 ora....d1.inst application ONLINE ONLINE node1 ora....d2.inst application ONLINE ONLINE node2
@至此，Oracle RAC CRS 升級成功！
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
