plsql报： 监听程序当前无法识别连接描述符中请求的服务

[noia_zhou]

我在用plsql时，报： 监听程序当前无法识别连接描述符中请求的服务，我看是配置的问题，可以试了几次又不对
---------------------------
listener.ora：
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 = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
---------------------------
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
大家帮看看是哪里出问题嘛，在线等，急啊

[wangzk0206]

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = orcl)
)
)

你最好去NET MANAGER中配置

[noia_zhou]

把机器重新改了个机器名，重启后，修改配置，把localhost修改为机器名后终于可以正常登陆了，不知道以后时间长了，连接还会不会出问题？唉，担心啊。。。

[wangzk0206]

修改了机器名后会有很多潜在的问题

所以建议若是正式库千万别改机器名

[noia_zhou]

感谢love_2008(love2008) 的回复，修改机器名后可以连接了，但是监听列表里没加orcl的定义，就是你说的：
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
加与不加，有什么不同呢？

[noia_zhou]

你说的对，机器名还是不要修改的好

[noia_zhou]

现在的配置是：
---------------------------
listener.ora：
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 = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = GAB-L)(PORT = 1521))
)
)
---------------------------
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = GAB-L)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
感觉还是不稳定，担心什么时候就启动不起来了，有需要改进的吗？

本来打算在SID_LIST_LISTENER里添加orcl的定义，可是加了后登陆出问题，又改回来了了。最好那位大大把修改好后完整的配置贴出来看看