tnsnames.ora中的连接串

简易连接：

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