配置连接文件参考:
# tnsnames.ora network configuration file: c:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
# generated by oracle configuration tools.
60 =
(description =
(address_list =
(address = (protocol = tcp)(host = 数据库ip地址)(port = 数据库服务端口))
)
(connect_data =
(service_name = testdb)
)
)
61 =
(description =
(address_list =
(address = (protocol = tcp)(host = 数据库ip地址)(port = 数据库服务端口))
)
(connect_data =
(sid = testdb)
)
)
注:60,61为服务的名称,可以自己随意设定
# tnsnames.ora network configuration file: c:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
# generated by oracle configuration tools.
60 =
(description =
(address_list =
(address = (protocol = tcp)(host = 数据库ip地址)(port = 数据库服务端口))
)
(connect_data =
(service_name = testdb)
)
)
61 =
(description =
(address_list =
(address = (protocol = tcp)(host = 数据库ip地址)(port = 数据库服务端口))
)
(connect_data =
(sid = testdb)
)
)
注:60,61为服务的名称,可以自己随意设定