ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME！

显示全部楼层 · 2005-2-28 12:57:00

我用tnsping可以ping通要连的服务器，可是，我用sqlplus就出现标题所示的错误？
有什么可能的原因吗？

千问 · 2005-2-28 12:57:00

看看你的tnsnames.ora文件是什么样的？在哪个目录下？

千问 · 2005-2-28 12:57:00

我也遇到同样的问题，期待中。。。

千问 · 2005-2-28 12:57:00

还有，要看看服务器上的listener.ora文件。

千问 · 2005-2-28 12:57:00

可以用命令:lsnrctl->status,检查监听器的状态，然后看看tnsnames.ora中所配置的服务名是否正确

千问 · 2005-2-28 12:57:00

应该是你的连接字符串配置的有问题：你看一下tnsnames.ora 文件中 host= 后面的是不是你的服务器的ip 应该是ip错了

千问 · 2005-2-28 12:57:00

tnsnames.ora,listener.ora,就这俩地方，查查吧

千问 · 2005-2-28 12:57:00

192.168.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID= ORCL)
)
)

千问 · 2005-2-28 12:57:00

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = teamtrack)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = teamtrack)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = orcl)
)
)

千问 · 2005-2-28 12:57:00

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
Start Date
26-FEB-2003 10:43:05
Uptime
5 days 2 hr. 7 min. 38 sec
Trace Level
off
Security
OFF
SNMP
OFF
Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
Listener Log File C:\oracle\ora81\network\log\listener.log
Services Summary...
PLSExtProc
has 1 service handler(s)
orcl
has 1 service handler(s)
orcl
has 2 service handler(s)
The command completed successfully
LSNRCTL>