ORA－12545 连接因对象主机或对象不存在而失败

whywzf 2003-12-19 03:11:20

我这里出现的问题是：XP客户端（我的笔记本）的NET8 Configuration Assistant在测试数据库连接的时候报错：ORA－12545 连接因对象主机或对象不存在而失败。
（tnsping可以通）

而linux服务器端（我的台式机）的sqlplus可以登录使用了。

为什么一个能一个不能呢？

在XP上tnsnames.ora文件内容如下：
# TNSNAMES.ORA Network Configuration File: G:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

JADSMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SID = jadsms)
)
)

在linux上tnsnames.ora文件内容如下：
# TNSNAMES.ORA Network Configuration File: /disk1/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

JADSMS.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jadsms.jadeite)
)
)

68SERVERS.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SID = jadsms)
)
)

INST1_HTTP.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = jadsms.jadeite)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESETATION = RO)
)
)

linux下的listener.ora文件内容如下：
# TNSNAMES.ORA Network Configuration File: /disk1/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.17)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXPROC))
)
)
)

SID_LIST_LISNETER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /disk1/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = jadsms.jadeite)
(ORACLE_HOME = /disk1/oracle)
(SID_NAME = jadsms)
)
)
直接复制linux上的tnsnames到XP上，同样报错，请指教！

...全文