For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

 

 

 

Donald K. Burleson

Oracle9i RAC Tips

Using Windows Cluster

This section discusses the steps involved in setting up a RAC system on a Windows platform.

Hardware / System Details

There are different configurations for Windows NT and 2000. Please consult the specific Hardware/Software/Variance information provided by your hardware vendor. Fig 6.12 shows the certified combination of servers/processors, interconnect technology, and storage types.

Fig 6.12 Windows based Clusters

However, there are some restrictions as shown below:

  • Oracle RAC is not supported on 64-bit Intel Architecture Systems in production environments.

  • AMD processor systems are not supported.

  • Network Attached Storage is not supported with Real Application Clusters on Windows.

  • When using the SCSI based storage array, a RAC cluster is limited to two nodes.

  • iSCSI technology is not supported.

This information is likely to change, as Oracle and other vendors continuously certify new hardware. It is suggested that the reader consult the hardware vendor to find out the latest position of certification.

Setup the External and Internal NIC

First, set up the servers or nodes with the appropriate operating system and apply the necessary service packs.

Within the network settings of Windows, create at least two entries for the NIC(s) that have been installed.

When assigning the bindings of the NIC(s) within the Windows Networking Properties, ensure that the public IP is listed at the top for all settings. The private NIC(s) should be listed below the public NIC settings. This can be verified at the command prompt by running the command ipconfig /all to verify that the public IP address is listed first.

It is recommended to use a network switch for interconnecting between nodes rather than a crossover cable. Most cluster hardware vendors will have this as a requirement. Also, ensure that the external or public hostnames are defined in the directory network services (DNS), and that the correct IP addresses resolve for all nodes in the cluster. Ensure that the internal or private hostnames are defined in the HOST file on all nodes of the cluster. This file is located in the WINDOWS_HOME\System32\drivers\etc directory.

Checking Access to Other Nodes within Windows

Oracle recommends using either the same username or password on each node in a cluster, or a domain username with administrative privileges on all local nodes when installing or performing administrative tasks. All nodes must be in the same domain.

Ensure that each node has administrative access to all directories within the Windows environment by running the following at the command prompt:

NET USE \\host_name\C$

The hostname is the public network name for the other nodes. If we plan to install the ORACLE_HOME onto a drive location other than C:\ check that administrative share as well.

For example, if the WIN_HOME is on the C:\ drive and we are installing the ORACLE_HOME onto the E:\ drive of all nodes, we will run the following from a command prompt on node 1 of a four-node cluster:

NET USE \\node2\C$

NET USE \\node3\C$

NET USE \\node4\C$

NET USE \\node2\E$

NET USE \\node3\E$

NET USE \\node4\E$


For more information, see the book Oracle 11g Grid and Real Application Clusters  - 30% off if you buy it directly from Rampant TechPress .  Written by top Oracle experts, this RAC book has a complete online code depot with ready to use RAC scripts.


For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

 

 


 

 

image

image

image  

image

image

image

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: