|
LISTENERS_TEST =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibmsvr1_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ibmsvr2_vip)(PORT = 1521))
)
改为:
LISTENERS_SDDZYJ =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.201.42)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.201.43)(PORT = 1521))
)
也就是将host主机名改为ip地址
在ibmsvr1上增加以下部分
local_listener_rac =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.201.40)(PORT = 1521))
)
在ibmsvr2上增加以下部分
local_listener_rac =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.201.41)(PORT = 1521))
)
保存退出
查看两个节点的 listener.ora文件,最好将里面的主机名都改为ip地址
4,用system用户登录
执行
alter system set local_listener='local_listener_rac' scope=both;
5 重启所有实例 所有监听.
再从客户端连接 正常,
每次连接用 show parameter instance_name查看实例名, 负载均衡已经生效.
有人把remote_listener 参数置空 虽然连接正常但已经破坏了负载均衡.
阅读更多内容:<<上一页 · 1 · 2
|