This Document explains the installation of Oracle service on Windows Cluster

This basic infrastructure is setup for running Oracle DB services on top of

Windows Server 2008 R2 cluster, that includes two Physical nodes running Windows 2008 R2(Enterprise using ISCSI as storage solution.

This document outlines the step by step process to install Oracle11G

Standard Edition on Windows Server 2008R2 failover Cluster.

Start with Oracle 11G Configuration

Prerequisites The following prerequisites must be fulfilled before starting the Oracle 11G installation.

A).NET framework 3.5 SP1 must be installed on all the Nodes.

B).Shared Disks for Oracle Data files. Disks must not be

compressed (Figure 1). These drives are also visible in the Failover Cluster

Management Console (Figure 2). There should be different drives for each

Clustered Instance.

Note: Oracle 11G support one disk for both Data & Archive files.

However, each instance must have a separate disk.

Quorum, ROOT & Data Drives.

C).No Antivirus software should be installed on the Nodes.

D).Add exceptions to firewall configuration settings for the Oracle 11G port (1521),

File and Printer Sharing (TCP 139/445 and UDP 137/138) and

Remote Procedure Call (TCP port 135).

E).Remote Registry Service must be running.

F).The installing account must be a local administrator to the Nodes.

F).The Oracle Service account should be from the same domain as the nodes.

G).Identify the network connections for Heartbeat, Backup & Production.

H).Copy the Oracle media to the local disks of the nodes.

Figure 1

Figure 2

The following information must be in your note book or Notepad before you start Installing

Oracle 11G on windows 2008 R2 Cluster.

1. Oracle Server Service Account(s)/Password(s).

2. Oracle Server Cluster Network Name(s) & Instance Name(s).

3. Oracle Server Cluster Network IP Address(s) for each Network Name.

4. Subnet Mask.

Note: The Oracle 11G service installations are to be performed on both the

Nodes.

Installing Oracle 11G on windows 2008R2 Cluster Node1.

It’s a best practice to restart the Cluster Nodes before starting the Oracle Installation.

A).Run Setup.exe from the Installation media or from the local disk as given below.

B). The Oracle Installation Center will launch.

C). You can skip the email information part if needed.

D). You can skip the Software Update part if needed.

E). Select the first option “Create and configure a database” to start installation, click

the Next Button to continue.

F). Select Server Class option to install the Server Configuration and click Next Button to

continue.

G). Select Single instance database installation and click Next Button to continue.

H). Select the Typical Install and click the Next Button to continue.

I). Select the database path and Required details as given below.

J). Setup Prerequisite Checks.

K). Setup Pre-stage Summary.

L). Installation progress

M). Installation Completed.

N). Database Configuration Assistant: Database Setup Steps as given below.

O). Password management for SYS and SYSTEM database users.

Note: After this we can perform Password management as to specify passwords for SYS and

SYSTEM account and if we want to unlock any database user account by clicking the

Password Management button at the bottom right corner.

P). Oracle Database installation completed successfully.

Q). The Installation complete windows will confirm successful installation of the

Cluster.

Installing Oracle 11G on windows 2008R2 Cluster Node2.

A. On the secondary node(s) launch the setup as in “A” of First Node installation.

B. Select the Second option “Install Database Software only” to start installation, click.

The Oracle Installation Center will launch.

You can skip the email information part if needed.

You can skip the Software Update part if needed.

C. Select the Second option “Standard Edition One” to start installation, click.

D. Checking Prerequisite, Click Next.

E. Oracle Software installation completed successfully.

Follow the below steps to configure Oracle service in Windows cluster.

1. Right click on Services and applications, and click on Configure a Service or Application.

2. On Select Service or Application page, select Generic Service and click Next.

3. Select Service page appears. This page lists all the services that are running on the clustered

nodes. Select “Oracle Database and listener service” and click Next.

4. On Select Storage page, you have an option to choose a disk for the generic service. If the

generic service needs a disk resource, you can select a disk.

5. On Confirmation page, verify that the information is correct. If you need to make modifications,

you can use previous button to go back to the previous pages in the wizard and modify the

information. Click Next.

6. The Wizard should successfully create the generic service resource and bring the resource

online. A Summary page appears.

POST INSTALLATION TASKS

1. Creating listener on node 2, using NETCA utility

2. Copy Listener.ora, tnsnames.ora , password and spfileiifcldb.ora file from node 1 to node.

3. Creating Oracle database service same as in node 1 as follow: oradim -new -srvc OracleService

CLDB -startmode M -usrpwd sysdb -pfile

C:\app\oracluadmin\product\11.2.0\dbhome_1\database\INITCLDB -timeout 60

4. Putting database in Archive log mode.

5. Important Database Info:

ORACLE_SID= cldb ORACLE_BASE = C:\app\oracluadmin ORACLE_HOME = C:\app\oracluadmin\product\11.2.0\dbhome_1 Database file location: D:\APP\ORACLUADMIN\ORADATA\CLDB Archive file location: D:\app\oracluadmin\oradata\archive Control file location: D:\APP\ORACLUADMIN\ORADATA\CLDB\CONTROL01.CTL, D:\APP\ORACLUADMIN\FAST_RECOVERY_AREA\IIFCLDB\CONTROL02.CTL

Initialization Parameter file: D:\APP\ORACLUADMIN\DIAG\SPFILEIIFCLDB.ORA Connect string (used for make connections from oracle client frontend) : user/password@cldb (dummy user: scott ; password: tiger created in database) To connect Database refers below:

------------END OF THE DOCUMENT--------------