Upgrade an Oracle rac asm instance from 10.2.0.1 to 10.2.0.4

I. Description

See an ASM upgrade document on the official website, as shown below:

How To Upgrade ASM from 10.2 to 11.1 (RAC)

Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2

For database upgrades under RAC, refer:

RedHat 5.4 Orcle RAC database upgraded from 10.2.0.1 to 10.2.0.4

Notes:

1. The Clusterware version must be consistent with the DB or ASM version. If you want to upgrade ASM or DB, you must first upgrade clusterware.

Either the release version of Oracle Clusterware must be equal to the ASM release to which you want to upgrade, or you must first upgrade Oracle Clusterware. for example, you can upgrade ASM release 11.1.0.6 to 11.1.0.7 if Oracle Clusterware on your system is release 11.1.0.7, but you cannot do this if Oracle Clusterware is 11.1.0.6 or an earlier release.

2. You can upgrade ASM and DB together. If you only upgrade the ASM instance, it is like the method provided on the official website:

(1) install the new version of ASM to another directory. Install the database software.

(2) Start the instance with the old version of ASM.

(3) open another window, re-specify ORACLE_HOME, PATH and other parameters, and specify the new version of the ORACLE software directory.

(4) Run dbua in this window and select the ASM instance for upgrade.

3. In this experiment, we will upgrade the database and ASM together. No separate upgrade. Because the Virtual Machine space is not enough. You can understand this idea.

Ii. View RAC Information

2.1 DB version information

[Oracle @ rac1 ~] $ Export ORACLE_SID = dave1

[Oracle @ rac1 ~] $ Sqlplus/as sysdba;

SQL * Plus: Release 10.2.0.1.0-Production on Thu May 12 15:08:44 2011

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SYS @ dave1 (rac1)> select * from v $ version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod

PL/SQL Release 10.2.0.1.0-Production

CORE 10.2.0.1.0 Production

TNS for Linux: Version 10.2.0.1.0-Production

NLSRTL Version 10.2.0.1.0-Production

SYS @ dave1 (rac1)>

2.2 ASM instance version

[Oracle @ rac1 ~] $ Export ORACLE_SID = + ASM1

[Oracle @ rac1 ~] $ Sqlplus/as sysdba;

SQL * Plus: Release 10.2.0.1.0-Production on Thu May 12 18:19:29 2011

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SYS @ + ASM1 (rac1)>

2.3 RAC process info.

[Oracle @ rac1 ~] $ Cd/u01

[Oracle @ rac1 u01] $ sh crs_stat.sh

Name Target State Host

--------------------------------------------------------

Ora. dave. dave1.inst ONLINE rac1

Ora. dave. dave2.inst ONLINE rac2

Ora. dave. db ONLINE rac1

Ora. dave. taf. cs ONLINE rac1

Ora. dave. taf. dave1.srv ONLINE rac1

Ora. dave. taf. dave2.srv ONLINE rac2

Ora. rac1.ASM1. asm ONLINE rac1

Ora. rac1.LISTENER _ RAC1.lsnr ONLINE rac1

Ora. rac1.gsd ONLINE rac1

Ora. rac1.ons ONLINE rac1

Ora. rac1.vip ONLINE rac1

Ora. rac2.ASM2. asm ONLINE rac2

Ora. rac2.LISTENER _ RAC2.lsnr ONLINE rac2

Ora. rac2.gsd ONLINE rac2

Ora. rac2.ons ONLINE rac2

Ora. rac2.vip ONLINE rac2

3. Upgrade Clusterware

The patch number of 10.2.0.4 is p6810189.

3.1 mout the upgrade package to linux

The local operating system under my Patch, the network speed is limited by the network management, so it is directly mounted to linux.

Log on to the system as a root user and run the following command:

Mount-o username = administrator, password = 12345678 // 192.168.3.115/Software/mnt

Mount-o username = administrator, password = bailing520 // 192.168.3.115/Software/mnt

3.2 stop related processes

3.2.1 each node stops EM and isqlplus respectively.

[Oracle @ rac1 bin] $ emctl stop dbconsole

[Oracle @ rac1 bin] $ isqlplusctl stop

3.2.2 stop related processes

You can run the srvctl command one by one or crs_stop-all.

For this part of content, refer to Blog:

Oracle RAC startup and Shutdown

[Oracle @ rac1 u01] $ sh crs_stat.sh

Name Target State Host

--------------------------------------------------------

Ora. dave. dave1.inst OFFLINE

Ora. dave. dave2.inst OFFLINE

Ora. dave. db OFFLINE

Ora. dave. taf. cs OFFLINE

Ora. dave. taf. dave1.srv OFFLINE

Ora. dave. taf. dave2.srv OFFLINE

Ora. rac1.ASM1. asm OFFLINE

Ora. rac1.LISTENER _ RAC1.lsnr OFFLINE

Ora. rac1.gsd OFFLINE

Ora. rac1.ons OFFLINE

Ora. rac1.vip OFFLINE

Ora. rac2.ASM2. asm OFFLINE

Ora. rac2.LISTENER _ RAC2.lsnr OFFLINE

Ora. rac2.gsd OFFLINE

Ora. rac2.ons OFFLINE

Ora. rac2.vip OFFLINE

1 2 3 Next Page