RedHat 5.4 Oracle RAC database upgraded from 10.2.0.1 to 10.2.0.4

Previously, the RAC platform was installed on two nodes. The database version is 10.2.0.1. The purpose of this experiment is to upgrade the database version from 10.2.0.1 to 10.2.0.4. The upgrade package can be downloaded from Oracle metalink. This download requires an Oracle paid account. Resources may be downloaded from the network. The patch number of 10.2.0.4 is p6810189.

For more information about how to install RAC on two nodes, see:

RedHat 5.4 + ASM + RAW + Oracle 10g RAC installation documentation

The upgrade process is similar to that of a single node. For upgrade of a 10g single node, refer to the Blog:

Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4

The upgrade in the RAC environment is divided into three steps. This is detailed in the readme document in the patch package.

1. Upgrade clusterware --> In the upgrade package, select CRS_HOME to install

2. Upgrade the database software --> select ORACLE_HOME in the installation program of the upgrade package to install

3. Upgrade the instance --> you can use a script or run DBUA directly. If you use a script, refer to single-node upgrade.

RAC upgrades are classified into rolling upgrade and non-rolling upgrade.

A rolling upgrade is to update a node each time.

Non-rolling means upgrading all nodes at a time.

The readme document of this patch package is also described. This upgrade uses non-rolling updates. That is, all nodes are completed at one time.

Note:

Back up the production database before upgrading. Back up the database (such as RMAN), The ORA_CRS_HOME directory, and the ORACLE_HOME directory. Although there are very few problems, if there is a problem, who will pay for our errors, so as a DBA should remember that backup is important.

1. view the current version from the client

1.1 modify the tnsnames. Ora file and add the following content:

RAC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 110.853.10.1) (PORT = 1521 ))

(ADDRESS = (PROTOCOL = TCP) (HOST = 10.85.10.2) (PORT = 1521 ))

(LOAD_BALANCE = YES)

(

CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCL)

(

FAILOVER_MODE =

(TYPE = session)

(METHOD = basic)

(RETRIES = 180)

(DELAY = 5)

)

)

)

1.2 The client uses sqlplus to connect to the database and view the database version information

C: \ Users \ Administrator. David Dai> sqlplus/nolog

SQL * Plus: Release 11.2.0.1.0 Production on Wednesday September 15 16:32:47 2010

Copyright (c) 1982,201 0, Oracle. All rights reserved.

SQL> conn sys/oracle @ rac as sysdba;

Connected.

SQL> select instance_name from V $ instance;

INSTANCE_NAME

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

Orcl2

SQL> 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

SQL>

It is not necessary to check the version. Here is an additional demonstration of how the client connects to RAC.

Ii. Upgrade Clusterware Software

2.1 mout the upgrade package to linux

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

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

2.2 stop related processes

2.2.1 each node stops EM and isqlplus respectively.

[Oracle @ rac1 bin] $ emctl stop dbconsole

[Oracle @ rac1 bin] $ isqlplusctl stop

2.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 bin] $ crs_stat-t

Name Type Target State Host

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

Ora. orcl. db application OFFLINE

Ora... oltp. cs application OFFLINE

Ora... cl1.srv application OFFLINE

Ora... cl2.srv application OFFLINE

Ora... l1.inst application OFFLINE

Ora... l2.inst application OFFLINE

Ora... SM2.asm application OFFLINE

Ora... C1.lsnr application OFFLINE

Ora. rac1.gsd application OFFLINE

Ora. rac1.ons application OFFLINE

Ora. rac1.vip application OFFLINE

Ora... SM1.asm application OFFLINE

Ora... C2.lsnr application OFFLINE

Ora. rac2.gsd application OFFLINE

Ora. rac2.ons application OFFLINE

Ora. rac2.vip application OFFLINE

1 2 3 Next Page