关闭

tnsnames.ora中的连接串

标签: tnsping tnsnames.ora
546人阅读 评论(0) 收藏 举报
分类:

简易连接:

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)) 

)


简易连接:

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)) 

)

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:186753次
    • 积分:3432
    • 等级:
    • 排名:第10099名
    • 原创:156篇
    • 转载:7篇
    • 译文:3篇
    • 评论:20条
    文章分类
    最新评论