若两个服务(rambles是本地机器名,dellserver是另外一台)这样子描述,
则使用 connect odscommon/odscommon@ldp 能够连接成功,
但是 connect odscommon/odscommon@tst 就报错说TNS:无法解析服务名LDP =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rambles)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldp.rambles)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tst.dellserver)
)
)
)但是若描述成:LDP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rambles)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldp.rambles)
)
)
TST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tst.dellserver)
)
)
则刚好反过来——使用 connect odscommon/odscommon@tst 能够连接成功,
但是 connect odscommon/odscommon@ldp 就报错说TNS:无法解析服务名请问这是什么问题?哪位大哥帮我一把,分不够可以再送
则使用 connect odscommon/odscommon@ldp 能够连接成功,
但是 connect odscommon/odscommon@tst 就报错说TNS:无法解析服务名LDP =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rambles)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldp.rambles)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tst.dellserver)
)
)
)但是若描述成:LDP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rambles)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldp.rambles)
)
)
TST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tst.dellserver)
)
)
则刚好反过来——使用 connect odscommon/odscommon@tst 能够连接成功,
但是 connect odscommon/odscommon@ldp 就报错说TNS:无法解析服务名请问这是什么问题?哪位大哥帮我一把,分不够可以再送
此外,另外,我还想问一下,是不是两个NET服务都都是连到同一台机器上的!
LDP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rambles)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldp.rambles)
)
)
TST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tst.dellserver)
)
)
这种格式才是正确的,不过不建议你用ip地址试一下,你说的这种现象只能是出在了HOST = dellserver和SERVICE_NAME = tst.dellserver这两个地方了
我曾经的用过的如下配置:
D7I =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.60.180.1)(PORT = 1521))
(CONNECT_DATA = (SID = d7i))
)
)
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rambles)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldp.rambles)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tst.dellserver)
)
)
)这个TST没有设置。LDP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rambles)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ldp.rambles)
)
)不能连,也许 是你的本地监听服务,或是配制有错误
LDP =
(DESCRIPTION_LIST=
我看了看net service的文档,好像可以这么写的:(
connect odscommon/odscommon@tst 就一定要有个
TST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tst.dellserver)
)
)
的吗?在解析的时候就是用那个TST定位然后获取后面的信息?——我昨晚回去的时候关机了,今天过来发现已经可以了,放弃了采用DESCRIPTION_LIST的方式,但是就是不懂为什么DESCRIPTION_LIST的方式不行。谢谢各位的讨论,我过会儿就结贴了,大家有什么说法,赶紧贴啊^_^