出现ORA-12154: TNS: 无法处理服务名错误
我在vs2005下直接调试可以显示数据
但是发布到本机就显示上面的错误
本机已安装oracle9.2
listener配置
# LISTENER.ORA Network Configuration File: c:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.127.18.3)(PORT = 1521))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = uant)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = uant)
)
)
tnsnames配置
# TNSNAMES.ORA Network Configuration File: c:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adp-gzc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)GOENSOFT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.127.18.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = uant)
)
)
请问是什么问题呀
我在vs2005下直接调试可以显示数据
但是发布到本机就显示上面的错误
本机已安装oracle9.2
listener配置
# LISTENER.ORA Network Configuration File: c:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.127.18.3)(PORT = 1521))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = uant)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = uant)
)
)
tnsnames配置
# TNSNAMES.ORA Network Configuration File: c:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adp-gzc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)GOENSOFT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 198.127.18.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = uant)
)
)
请问是什么问题呀
解决方案 »
- oracle排名查询
- 请帮忙写个触发器
- 在AIX环境实际应用下,对于应用的oracle,平时最容易发生的问题大致有哪些?(只列出常见问题即可,不用作答,回答更加感谢)
- 请教大家一个oracle数据库的sql语句
- 还是不明白Oracle返回值这一块,急用,大家帮忙吧
- 用随机值更新的问题
- 能够通过bat/dos 取得plsql返回值么?
- LECCO SQL Expert for Oracle 有在用的吗?
- Oracle和SQLSREVER(或国产数据库达梦)的SQL语句语法区别主要是什么地方?
- 求:Oracle事务处理比较完整的一个例子
- 为什么建了同义词却在应用时候总是出错误,总是识别不出来呢?
- 触发器可以捕获select语句吗?
tnsping可以通的