数据库环境 : 11.2.0.4.0
系统 版本: Red Hat Enterprise Linux Server release 6.4 (Santiago)
IP:
# Public
192.168.8.59 rac1
192.168.8.60 rac2
# Virtual
192.168.8.61 rac1-vip
192.168.8.62 rac2-vip
# Private
10.10.10.40 rac1-priv
10.10.10.50 rac2-priv
# SCAN
192.168.8.63 scan-ip
配置tnsnames.ora
rac =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan-ip)(PORT = 3536))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
检查scan监听
[grid@rac2 ~]$ srvctl status scan_listener
SCAN 监听程序 LISTENER_SCAN1 已启用
SCAN 监听程序 LISTENER_SCAN1 正在节点 rac2 上运行
[grid@rac2 ~]$ srvctl config scan_listener
SCAN 监听程序 LISTENER_SCAN1 已存在。端口: TCP:3536
服务器本地测试正常
使用oracle client 测试,配置tnsnames.ora,配置scan-ip
rac =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.63 )(PORT = 3536))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
登录sqlplus 连接
检查如下本地连接正常
检查RAC 节点1 配置
节点2配置
发现问题HOST 配置都是hostname,解决如下:
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.61)(PORT=3536))))' scope=both sid='rac1';
SQL> alter system register;
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.62)(PORT=3536))))' scope=both sid='rac2';
SQL> alter system register;
再次连接如下:
OK,完成
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30327022/viewspace-2129013/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30327022/viewspace-2129013/