我的tnsname出了怪现象,无法解决

显示全部楼层 · 2007-10-20 08:38:44

我的TNSNAMES.ORA
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = china-2f5138a29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
SQLNET.ORA
TRACE_LEVEL_CLIENT = SUPPORT
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME)
D:>TNSPING ORCL
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = china-2f5138a29)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (30 毫秒)
D:>sqlplus scott/tiger@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 1月 9 22:35:23 2008
Copyright (c) 1982, 2005, Oracle.All rights reserved.
就这样一直挂着也不报错,但如果我的tnsname的服务名写的不对就报ERROR:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务.无法解决,可能是我的机器主版问题吧

千问 · 2007-10-20 08:38:44

listener。ora文件内容是什么？

千问 · 2007-10-20 08:38:44

写的不对，应该报错的

千问 · 2007-10-20 08:38:44

十有八九是防火墙的事，前两天一位学员遇到了这种情况

千问 · 2007-10-20 08:38:44

同意warehouse的意见

千问 · 2007-10-20 08:38:44

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = china-2f5138a29)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

千问 · 2007-10-20 08:38:44

我是本机上，我现在把防火墙都关了，当我sqlplus scott/tiger@orcl 还是挂那里，也不报错。
我在其他机器上没有这个问题，我一直怀疑可能是我的戴尔机器问题。dbconsole也是启动就报错

千问 · 2007-10-20 08:38:44

贴这个看看
lsnrctl services

千问 · 2007-10-20 08:38:44

看下服务端的LISTENER.log