Shulou(Shulou.com)06/01 Report--

Oracle 10g RAC upgrade (CPU Update)-upgrade CRS

System environment:

Operating system: RedHat EL5

Cluster: Oracle CRS 10.2.0.1.0

Oracle: Oracle 10.2.0.1.0

As shown in the figure: RAC system architecture

Case study:

This case is upgraded from Oracle 10.2.0.1.0 to 10.2.0.4.0 as a patch upgrade (CPU Update) for Oracle.

Upgrade steps:

1. CRS upgrade (rolling upgrade can be used for CRS upgrade. Rolling upgrade is used in this case)

2. Oracle software upgrade

3. DataBase upgrade (you can use dbua or sqlplus command to upgrade)

1. Upgrade CRS (ROLLING UPDATE)

Preparation before upgrade:

[oracle@node1] $sqlplus'/ as sysdba'SQL*Plus: Release 10.2.0.1.0-Production on Mon May 12 14:57:24 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining optionsSQL > select instance_name,status from gv$instance INSTANCE_NAME STATUS--prod1 OPENprod2 OPENSQL > show parameter sgaNAME TYPE VALUE -- sga_max_size big integer 272Msga_target big integer 272MSQL > 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 sharedNAME TYPE VALUE-- shared_pool_size Big integer 0SQL > 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 bytesFixed Size 1220988 bytesVariable Size 524291716 bytesDatabase Buffers 100663296 bytesRedo Buffers 2969600 bytesSQL > show parameter shareNAME TYPE VALUE -- shared_pool_size big integer 200Mshared_server_sessions integerSQL > show parameter javaNAME TYPE VALUE-- -java_pool_size big integer 300m

1) upgrade on node1 first

Upgrade CRS on node1:

[root@node1] # uname-aLinux 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 softwareversionCRS softwareversion on node [node1] is [10.2.0.1.0] [root@node1] # crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy [root@node1 ~] # crs_stat-tName 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 node1ora....d2.inst application ONLINE ONLINE node2 close Instance on node1: [oracle@node1 ~] $srvctl stop instance-d prod-I prod1 close ASM on node1: [oracle@node1 ~] $srvctl stop asm-n node1 close nodeapps on node1: [oracle@node1 ~] $srvctl stop nodeapps-n node1 [oracle@node1 ~] $crs_stat-tName 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) download and extract the patch (the same patch is used for both CRS and Oracle software upgrades for RAC)

[oracle@node1 ~] $unzip p6810189_10204_Linux-x86.zip

Upgrade CRS 10.2.0.1.0 to 10.2.0.4.0, as shown in the following figure:

Execute as Oracle user: runInstaller

Start the upgrade

Note the upgrade directory: it should be the installation directory of CRS

Upgrade installation

Patch software upgrade process

Follow the prompts to execute 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 filesCompleted patching clusterware files to / u01/crs_1Relinking some shared libraries.Relinking of patched files is complete.WARNING: directory'/ u01'is not owned by rootPreparing 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: node1: node1 node1-priv node1Creating OCR keys for user 'root' Privgrp 'root'..Operation successful.clscfg-upgrade completed successfully [root@node1 ~] # crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy [root@node1 ~] # crs_stat-tName 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 softwareversionCRS softwareversion on node [node1] is [10.2 .0.4.0] [oracle@node1 ~] $

Node1's CRS upgrade succeeded!

3) upgrade the CRS of node2 (the steps are the same as node1)

[root@node1] # srvctl stop instance-d prod-I prod2 [root@node1] # srvctl stop asm-n node2 [root@node1] # srvctl stop nodeapps-n node2

The following is a different picture from node1 during the upgrade process:

Select "select all"

After the upgrade software installation is complete, follow the prompts to execute script

[root@node2 ~] # crsctl stop crs [root@node2 ~] # / u01/crs_1/install/ root102.sh [root @ node2 ~] # crsctl query crs softwareversionCRS softwareversion on node [node2] is [10.2.0.4.0]

CRS upgrade for node2 is complete!

[root@node1] # crs_stat-tName 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

@ so far, the Oracle RAC CRS upgrade is successful!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.