Upgrade Oracle 9i RAC to Oracle 10g RAC

By: Vincent Chan
To read more DBA articles, visit http://dba.fyicenter.com/article/

This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).

Oracle Database 10g and Oracle Real Application Cluster (RAC) 10g itself, boast many new and exciting features that simplify database manageability and provide higher availability and scalability. Compared to its predecessors, Oracle 10g RAC is much easier to install, use and manage, thereby reducing the total cost of ownership.

Overview

The RAC cluster comprises two Intel x86 servers running on RHEL3 (Kernel 2.4.21-27). Each node has access to a shared storage and connectivity to the public and private network.

This article is structured into the following steps:

1. Preliminary Installation
2. Install Oracle Clusterware
3. Install Oracle RAC Software
4. Upgrade the Database
5. Migrate Database to ASM (Optional Step)

Unless otherwise specified, you should execute all steps on both nodes.

Here's an overview of our Oracle 9i RAC environment:

Host Name	Instance Name	Database Name	$ORACLE_HOME	Database File Storage

salmon1	prod1a	prod1	/u01/app/oracle/product/9.2.0	OCFS
salmon2	prod1b	prod1	/u01/app/oracle/product/9.2.0	OCFS

File	File Name	File Storage

Quorum	/ocfs/prod1/quorum	OCFS
Shared Configuration	/ocfs/prod1/srvm	OCFS

And an overview of the Oracle 10g RAC environment:

Host Name	Instance Name	Database Name	$ORACLE_HOME	Database File Storage

salmon1	prod1a	prod1	/u01/app/oracle/product/10.2.0/db_1	OCFS
salmon2	prod1b	prod1	/u01/app/oracle/product/10.2.0/db_1	OCFS

File	File Name	File Storage

Voting Disk	/ocfs/prod1/vdisk1 /ocfs/prod1/vdisk2 /ocfs/prod1/vdisk3	OCFS
Oracle Cluster Registry	/ocfs/prod1/ocr1 /ocfs/prod1/ocr2	OCFS

Full article...