配置连接文件参考:
# 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为服务的名称,可以自己随意设定