tnsnames.ora中的连接串

最新推荐文章于 2026-04-18 23:24:07 发布

原创最新推荐文章于 2026-04-18 23:24:07 发布 · 1.3k 阅读

0 ·

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

收录于

Network

本文详细介绍了 Oracle 数据库的不同连接方式，包括简易连接、单实例连接及 RAC 连接，并提供了具体的连接字符串示例。

简易连接：

ecss=ecss.db.paic.com.cn:1528/ecss

单实例连接串

bicss=(description =(address = (protocol = tcp)(host =bicss.db.paic.com.cn)(port = 1534))(connect_data = (sid = bicss)))

RAC连接串

kiss1 =
(description =
(address = (protocol = tcp)(host = kiss1.db.paic.com.cn)(port = 1534))
(connect_data = (service_name = kiss.world)(instance_name=kiss1))
)

kiss2=
(description =
(address = (protocol = tcp)(host = kiss2.db.paic.com.cn)(port = 1534))
(connect_data = (service_name = kiss.world)(instance_name=kiss2))
)

kiss =
(description =
(address = (protocol = tcp)(host = kiss1.db.paic.com.cn)(port = 1534))
(address = (protocol = tcp)(host = kiss2.db.paic.com.cn)(port = 1534))
(load_balance = yes)
(failover = on)
(connect_data =
(server = dedicated)
(service_name = kiss.world)
(failover_mode=(type=select)(method=basic))
)
)