在oracle10g rac的安装过程中,,网络的设置需要谨慎,也极其重要。
以下将我的oracle10g rac环境的网络配置列举一下,供参考。
1.hosts文件的设置
由于rac要设置多个地址,所以需要准备好网络环境,我的hosts文件设置如下:
#
# 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.监听器的配置
我的监听器文件配置如下:
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.tnsnames.ora文件配置
网络服务名等配置如下:
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))
)
这就是主要的一些配置文件,其中,oracle的相关配置文件都是自动生成的,vip可以实现故障时的自动切换。
