- 最后登录
- 2014-1-9
- 在线时间
- 14 小时
- 威望
- 0
- 金钱
- 75
- 注册时间
- 2013-5-28
- 阅读权限
- 10
- 帖子
- 2
- 精华
- 0
- 积分
- 0
- UID
- 1111
|
1#
发表于 2013-8-7 15:11:17
|
查看: 2173 |
回复: 0
配置remote listener可以实现负载均衡,需要在tnsname.ora配置remote listener,PMON会通过remote listener将本地的实例注册到远程的节点,数据库是怎么实现将本地实例注册到其他节点那?
[oracle@rac2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 7 00:39:47 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter listen
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
remote_listener string LISTENERS_RAC
tnsname.ora
LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
)
LISTENERS_RAC_BAK =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
)
我做了一个测试,将LISTENERS_RAC改成只有本机的ip,重启监听,本地和远程节点依然还是可以监听到2个节点的实例,
只有重启数据库实例,各节点才不会有其他节点的注册进来的实例,重启实例后再将2个ip都重新添加到LISTENERS_RAC,重启监听,各节点的监听,依然无法监听到其他节点的实例(alter system register;等待超过半个小时依然无效果?)
这个remote listener的配置是如何生效的?是否由PMON注册到远程的节点? |
|