During the installation of Oracle10g RAC, it is extremely important to exercise caution when setting the network.
The following lists the network configurations of my Oracle10g RAC environment for your reference.
1. settings of the hosts file
Because RAC needs to set multiple addresses, you need to prepare the network environment. My hosts file settings are 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. Listener Configuration
The configuration of my listener file is 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 = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.19.11)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
|
3. Configure the tnsnames. ora File
The Network Service name and other configurations are 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 file. The Oracle configuration files are automatically generated, and the VIP can automatically switch during the fault.
