Oracle 10g RAC Network settings

During the installation of the oracle10g RAC, the network settings need to be cautious and extremely important.

The following is a list of my oracle10g RAC Environment's network configuration for your reference.

1.hosts File Settings

Since RAC has to set up multiple addresses, the network environment needs to be ready, and my Hosts file is set as follows:

#

# Internet Host Table

#

127.0.0.1 localhost

172.16.19.11 Db210-rac1 db210-rac1.hurray.com.cn Loghost

172.16.19.211 DB210-RAC1VIP db210-rac1vip.hurray.com.cn

192.168.18.11 Db210-rac1priv db210-rac1priv.hurray.com.cn

192.168.19.11 DB210-RAC1HB db210-rac1hb.hurray.com.cn

172.16.19.12 Db210-rac2 db210-rac2.hurray.com.cn

172.16.19.212 DB210-RAC2VIP db210-rac2vip.hurray.com.cn

192.168.18.12 Db210-rac2priv db210-rac2priv.hurray.com.cn

192.168.19.12 DB210-RAC2HB db210-rac2hb.hurray.com.cn

2. Configuration of the Listener

My listener file is configured as follows:

bash-2.05$ Cat Listener.ora

# LISTENER.ORA.DB210-RAC1 Network Configuration

File:/opt/oracle/product/10.2.0/db/network/admin/listener.ora.db210-rac1

# Generated by Oracle configuration tools.
LISTENER_DB210-RAC1 =

(Description_list =

(DESCRIPTION =

(Address_list =

(address = (PROTOCOL = TCP) (HOST = DB210-RAC1VIP) (PORT = 1521) (IP = i)

)

(Address_list =

(address = (PROTOCOL = TCP) (HOST = 172.16.19.11) (PORT = 1521) (IP = i)

)

(Address_list =

(address = (PROTOCOL = IPC) (KEY = Extproc))

)

)

)


3.tnsnames.ora file Configuration

The Network service name is configured as follows:

bash-2.05$ Cat Tnsnames.ora

# Tnsnames.ora Network Configuration File:/opt/oracle/product/10.2.0/db/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

EYGLE2 =

(DESCRIPTION =

(address = (PROTOCOL = TCP) (HOST = DB210-RAC2VIP) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = eygle)

(instance_name = eygle2)

)

)
EYGLE1 =

(DESCRIPTION =

(address = (PROTOCOL = TCP) (HOST = DB210-RAC1VIP) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = eygle)

(instance_name = eygle1)

)

)

Eygle =

(DESCRIPTION =

(address = (PROTOCOL = TCP) (HOST = DB210-RAC1VIP) (PORT = 1521))

(address = (PROTOCOL = TCP) (HOST = DB210-RAC2VIP) (PORT = 1521))

(load_balance = yes)

(Connect_data =

(SERVER = dedicated)

(service_name = eygle)

(Failover_mode =

(TYPE = SELECT)

(method = BASIC)

(retries = 180)

(DELAY = 5)

)

)

)

Listeners_eygle =

(Address_list =

(address = (PROTOCOL = TCP) (HOST = DB210-RAC1VIP) (PORT = 1521))

(address = (PROTOCOL = TCP) (HOST = DB210-RAC2VIP) (PORT = 1521))

)

This is the main configuration files, where Oracle's related configuration files are automatically generated, VIP can be implemented when the failure of automatic switching.