oracle plsqldevelope无法登录 12514错误但是sqlplus可以登录

[油区波斯猫]

配置文件如下
# listener.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2011-20111022NM)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)



# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ABC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.34.83)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

[油区波斯猫]

在线求指导

[油区波斯猫]

这是我的在电脑服务里面的服务名：OracleServiceORACLELCH、OracleOraDb10g_home1TNSListener

[iqlife]

监听启动了？CMD里运行 LSNRCTL STATUS，没有启动就运行LSNRCTL START

[forgetsam]

ABC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.34.83)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 这里是你数据库的服务名，把它改成ORACLELCH )
)
)

[NLP爱好者]

你的SID是 orcl 还是PLSExtProc ，根据SID修改成一致。

[油区波斯猫]

[Quote=引用 4 楼 forgetsam 的回复:]

ABC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.34.83)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 这里是你数据库的服务名，把它改成ORACLELCH )
)
)
[/Quote]

貌似我就是这么用的，改成了oraclelch.domain 就成功了
谢谢啊。现在网速太慢了，等快了一定给高分，虽然在你评论之后我就搞定了