RAC on Windows 2003

Pre-Installation tasks include: Check public interface is first in bind order Disable Windows Media Sensing for TCP/IP Disable Write Caching on Shared Storage Enable Auto-mounting Local drives must be accessible from all nodes Environment variables System clocks must be synchronized
13
© 2006 Julian Dyke
juliandyke.com
Auto-Mounting
To enable auto-mounting use: C:> DISKPART DISKPART> AUTOMOUNT ENABLE Automatic mounting of new volumes enabled DISKPART> EXIT Repeat on each node in the cluster Restart all nodes after configuring this setting
11
Байду номын сангаас
© 2006 Julian Dyke
juliandyke.com
Disk Manager
To start the Disk Management tool: Start->Administrative Tools->Computer Management-> Storage->Disk Management Alternatively the Disk Management tool can be started from the command line using: C:> DISKMGMT.MSC
9
© 2006 Julian Dyke
juliandyke.com
Windows Media Sensing for TCP/IP
Windows Media Sensing for TCP/IP must be disabled To check this Run REGEDT32.EXE Navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\ Services\Tcpip\Parameters Add the following registry entry: Right click on right hand pane and select New -> DWORD value Value Name: Value: DisableDHCPMediaSense 1
4
© 2006 Julian Dyke
juliandyke.com
Shared Oracle Home
Oracle Clusterware (CRS) MUST be installed in a local directory on each node Oracle Database Software can be installed in a shared Oracle home on the cluster file system
8
© 2006 Julian Dyke
juliandyke.com
Public Interface Bind Order
The public interface must be the first in the bind order To check this Start Windows Explorer Right click on My Network Places and choose Properties In the Advanced menu click Advanced Settings... In the Adapters and Bindings tab If the public interface is not the first name listed Click the arrow to move it to the top of the list Click OK to save the setting
5
© 2006 Julian Dyke
juliandyke.com
Installation
6
© 2006 Julian Dyke
juliandyke.com
Pre-Installation Steps
7
© 2006 Julian Dyke
juliandyke.com
Pre-Installation Steps
14
© 2006 Julian Dyke
juliandyke.com
Local Drive Accessibility
Local drives must be accessible from all nodes To check local drive accessibility: For each node For each local drive to be used by the Oracle installation Use NET USE command to confirm accessibility For example if Oracle will be installed on E$ in a two-node cluster containing nodes RAC1 and RAC2 On RAC1: NET USE \\RAC2\E$ On RAC2: NET USE \\RAC1\E$
Write Caching must be disabled on shared storage To disable write caching at operating system level: Start->Settings->Control Panel->Administrative Tools-> Computer Management->Device Manager->Disk Drives Expand the disk drives list Double-click the first drive listed On the Disk Properties tab uncheck the write cache enabled option Repeat for all remaining disk drives Not necessary if using HP Array Manager as write caching is automatically disabled at operating system level
RAC on Windows 2003
Julian Dyke Independent Consultant
Web Version
1
© 2006 Julian Dyke
juliandyke.com
Introduction
This presentation describes Windows specific RAC configuration issues including: Installation Pre installation steps Installing Oracle Clusterware Installing Oracle Database Software Patches Post installation steps Administration Services Networking
12
© 2006 Julian Dyke
juliandyke.com
Auto-Mounting
Auto-mounting must be enabled when using RAC with raw partitions RAC with cluster file system Oracle Clusterware Logical drives for ASM Auto-mounting must be enabled on each node in the cluster To check if auto-mounting is enabled use: C:> DISKPART DISKPART> AUTOMOUNT Automatic mounting of new volumes disabled
3
© 2006 Julian Dyke
juliandyke.com
Overview
Oracle RAC is available on Windows in Standard Edition Enterprise Edition Standard Edition must use Automatic Storage Management (ASM) Enterprise Edition can use Automatic Storage Management (ASM) Oracle Cluster File System (OCFS)
16
© 2006 Julian Dyke
juliandyke.com
Time Synchronization
It is recommended that the system clocks are synchronized between all nodes in the cluster appears to be less important in Oracle 10g Release 2 than in previous RAC versions To synchronize the system clocks enable the Windows Time Service on one node The current time server for a node can be discovered using: NET TIME /QUERYSNTP The current SNTP server is: node2 The current time server for a node can be set using: NET TIME /SETSNTP:<hostname> For example: NET TIME /SETSNTP:SGHRAC1
NOTE - It is recommended that you backup the registry before making changes using REDEDT32.EXE / REGEDIT.EXE
10
© 2006 Julian Dyke
juliandyke.com
Write Caching
15
© 2006 Julian Dyke
juliandyke.com
Environment Variables
On each node the following environment variables must be set TEMP TMP By default these are set to %USERPROFILE%\Local Settings\Temp Oracle recommends these are redefined as follows TEMP=C:\TEMP TMP=C:\TMP These settings should be the same on each node
2
© 2006 Julian Dyke
juliandyke.com
Warning
This presentation is intended to supplement information in the Oracle documentation It is NOT intended to replace the Oracle documentation Most of the information contained in this presentation was correct for Oracle 10.2 Some information applies to earlier releases Where appropriate this is highlighted in the slides