GY1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)GY2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
(LOAD_BANLANCE = YES)
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
GY3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
(LOAD_BANLANCE = YES)
(failover = on)
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
以上这样配置tns的区别是什么啊。
192.168.0.1是服务器的漂移地址,
192.168.0.2 192.168.0.3 是实际地址。
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)GY2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
(LOAD_BANLANCE = YES)
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
GY3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
(LOAD_BANLANCE = YES)
(failover = on)
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
以上这样配置tns的区别是什么啊。
192.168.0.1是服务器的漂移地址,
192.168.0.2 192.168.0.3 是实际地址。
2、只能在连接时FAIL OVER,负载均衡。
3、同2,默认failover = on