ORACLE RAC连接，tns配置

最新推荐文章于 2024-07-17 15:02:13 发布

原创最新推荐文章于 2024-07-17 15:02:13 发布 · 1.5k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

当前文章被以下社区和专栏收录：

文章详细介绍了如何通过tns配置连接到OracleRAC集群，包括使用SCANIP进行静态连接，以及两种VIP连接方式：负载均衡和固定连接到第一个节点。每种配置都涉及TCP协议、主机名、端口、服务名以及故障切换和重试机制。

tns通过scanip连接
RACSCANIP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SCANIP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

tns通过vip连接，负载均衡
RACVIP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP2)(PORT = 1521))
)
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = BASIC)
(RETRIES = 5)
(DELAY = 1)
)
)
)

tns通过vip连接固定第一个连接
RACVIP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP2)(PORT = 1521))
)
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = BASIC)
(RETRIES = 5)
(DELAY = 1)
)
)
)