用Navicat lite 连接oracle 10g报错 12514

[emjava]

用Navicat lite 连接oracle 10g报错 12514

错误 代码是12514 提示：listrner does not currently know of service requested in connect descriptor

我找个网上的很多的办法 ，也修改了listrner.ora 和tnsnames.ora两个文件还都是一样的出错，请教各位怎么办？

下面是我修改之后的代码：

listener.ora :


# listener.ora Network Configuration File: E:\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 = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)


(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)



LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = Java-PC)(PORT = 1521))
)
)


下面是tnsnames.ora:

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

MLDN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Java-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mldn)
)
)

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


我还试过这种办法：

tnsping IP 和 tnsping orcl都是一样的结果.

C:\Users\Java>tnsping 192.168.0.107

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 29-9月 -
2011 00:29:14

Copyright (c) 1997, 2006, Oracle. All rights reserved.

已使用的参数文件:
E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 EZCONNECT 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.168.0.107))(A
DDRESS=(PROTOCOL=TCP)(HOST=192.168.0.107)(PORT=1521)))
TNS-12535: TNS: 操作超时



请大家帮我找找错误，在此谢谢大家呢！

[jdsnhan]

tnsping 本地服务名.
tnsping MLDN 看看什么效果。

[emjava]

这个可以了啊,但是我还是不能用navicat连接oracle啊,

C:\Users\Java>tnsping MLDN

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 01-10月-
2011 19:47:06

Copyright (c) 1997, 2006, Oracle. All rights reserved.

已使用的参数文件:
E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Java-PC)
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mldn)))
OK (40 毫秒)


这是用你给我的方法 ,但是用navicat连接oracle还是出上面一样的错误,请教怎么解决?急,谢谢!

[iqlife]

重新启动试试，按照如下步骤执行，先关闭数据库，关闭监听，启动数据库，启动监听，试试

[emjava]

3楼的，我已经试过了重启，但是还是出现一样的错误 ，我在网上找了好多的办法，但是就是不行，不过用sqlplusw能连接。什么问题也没有，但是一用navicat连接就出现listener的错误 ，请求帮助！谢谢