• No results found

This Document explains the installation of Oracle service on Windows Cluster

N/A
N/A
Protected

Academic year: 2021

Share "This Document explains the installation of Oracle service on Windows Cluster"

Copied!
21
0
0

Loading.... (view fulltext now)

Full text

(1)

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.

(2)

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.

(3)

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.

(4)

C).

You can skip the email information part if needed.

D).

You can skip the Software Update part if needed.

(5)

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.

(6)

G).

Select Single instance database installation and click Next Button

to continue.

H).

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

(7)

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

J).

Setup Prerequisite Checks.

(8)

K).

Setup Pre-stage Summary.

L).

Installation progress

(9)

M). Installation Completed.

N).

Database Configuration Assistant: Database Setup Steps as given below.

(10)

(11)
(12)

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.

(13)

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

(14)

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.

(15)

You can skip the email information part if needed.

(16)

C.

Select the Second option “

Standard Edition One

” to start installation, click.

(17)

E.

Oracle Software installation completed successfully.

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

(18)

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.

(19)

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

(20)

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

(21)

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:

References

Related documents

This article explains how quick and easy it is to connect to an Oracle 11g server from SAS running on a Linux client using the DataDirect Connect for ODBC Oracle Wire

Data using Oracle OLAP 11g Data using Oracle OLAP 11g Data using Oracle OLAP 11g Data using Oracle OLAP 11g Data using Oracle OLAP 11g Data using Oracle OLAP 11g Data using Oracle

•Deploying Oracle Data Guard with Oracle Database Appliance, An Oracle White Paper, April 2012 •Data Guard 11g Installation and Configuration On Oracle RAC Systems, White Paper,

Reference: Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server 11g Release 1, Running the Installation Program in Graphical Mode. Reference: Oracle Fusion

Reference: Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server 11g Release 1, Running the Installation Program in Graphical Mode. Reference: Oracle Fusion

The Oracle Warehouse Builder 11g Release 1 (11.1) documentation set includes these publications:.. ■ Oracle Warehouse Builder Installation and Administration Guide ■ Oracle

Finally, we note that a crucial issue in both current and future biodiesel production is economic viability, specifically enhanced by the profitable use of glycerol by-products

The last five sections covered the guiding sub-research questions which included teachers’ understanding of the child-friendly school environment concept,