Database Home Installation

Download Oracle 10g Release 2 (10.2.0.1.0) x64 for Windows from
here and extract it to a temporary directory. Run setup.exe.

Click Next.

Select Enterprise Edition and click Next.

Specify a home for the RAC database. This home must be different than both the ASM and Clusterware homes from our previous installs. Click Next to continue.

Select Cluster Installation and ensure that all the nodes are selected. Click Next.

Click Next once all the prerequisite checks have been completed.

Select No and click Next.

Select Install database Software only and click Next.

Review summary and click Install.

The installer will now install the Oracle home.

Click Exit to close the installer.

Database Home Upgrade from 10.2.0.1 to 10.2.0.3

The database software should be upgraded to patch level 2 (10.2.0.3) before the instance is created.

The first thing to do is to download the patch 5337014 from Metalink.

Unzip the patch to a temporary directory on any of the two nodes and run setup.exe and click Next.

Select the RAC home from our previous install and click Next.

Cluster installation mode should already be selected. Click Next to continue.

Review the summary before installing. Click Install to continue.

The patch will now be staged to each node in the cluster.

The patch will now be applied to each node.

Click Exit to close the installer.

Database Instance Creation

From the Oracle database home bin directory, run the Database Configuration Assistant.

Select Oracle Real Application Clusters database and click Next.

Select Create a Database and click Next.

Make sure every node in the cluster is selected and click Next.

Select the General Purpose template and click Next. Note, at this point if you have specific requirements for your database such as a different character set, Custom Database may be a better choice.

Enter a global database name and a SID. Click Next to continue.

Check the Configure the Database with Enterprise Manager checkbox (it should be checked by default) and click Next.

Enter a password for the SYS account and click Next.

Select Automatic Storage Management (ASM) and click Next.

Select the disk group that we stamped as DATA and click Next.

Click Next.

Use the Browse button to find the disk group we stamped as FLASH and select it for the flash recovery area. Click Next to continue.

Click Next.

Do not specify any services. Click Next.

Click Next.

Tablespaces can be defined at this point or later through the Enterprise Manager. Click Next to continue.

Click Finish.

A summary of the selected options is shown at this point. Click OK to create the database.

This will take a few minutes.

The instance is now created. Click Exit to close the assistant.

The instance will now be started on each node.

Using the SYS account, we can now log into the Oracle Enterprise Manager using a browser. A shortcut to the proper URL should be in the Start menu, in this case it is http://rac1:1158.