ORA-12154: TNS:could not resolve the connect idendifier specified

xdy3008 2010-06-21 04:14:10

情形：
通过Net Configuration Assistant 进行本地Net服务名测试均测试通过，可是用SQLplus和PL/SQL developer或者用命令行链接都错误
ORA-12154: TNS:could not resolve the connect idendifier specified ，这是为什么呢？

tnsnames.ora 为：



# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.



cog =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.225.106.30)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = cog)

    )

  )

  

orcl =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.225.106.30)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

listner.ora 为



SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = C:\oracle\product\10.2.0\client_1)

      (PROGRAM = extproc)

      (GLOBAL_DBNAME = orcl)

      (ORACLE_HOME = C:\oracle\product\10.2.0\client_1)

      (SID_NAME = orcl)

      (GLOBAL_DBNAME = cog)

      (ORACLE_HOME = C:\oracle\product\10.2.0\client_1)

      (SID_NAME = cog)

    )

  )



LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.225.106.30)(PORT = 1521))

    )

  )

...全文

602 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

iqlife 2010-06-23

打赏
举报

http://computerName:1158/em
这个好像要在服务器设置机器名解析才可以...9I的用NET ASSISTANT MANAGEMENT设置,10G的,不太懂

xdy3008 2010-06-22

打赏
举报

终于整好了，其实原因我还是没弄明白，服务用命令行启动了很多次，

另外一个是，把环境变量中的 C:\oracle\product\10.2.0\client_1 去掉了，而且还tnsnames.ora 尽量用utf-8格式，另外管理页面用 http://localhost:1158/em 进去就正常，用http://computerName:1158/em 进去就死活页面加载不了。。。很莫明其妙。

iqlife 2010-06-21

打赏
举报

我下班了,找了篇帖子,你看看能否解决....
http://topic.csdn.net/u/20090718/12/df94cff2-2bb4-4863-ac1a-fb3e2d4fa889.html

iqlife 2010-06-21

打赏
举报

运行lsnrctl status看看实例注册的状态。

xdy3008 2010-06-21

打赏
举报

sorry, 通过测试tnsping，
tnsping orcl
tnsping cog
均通过。

已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.225.106.30)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (30 毫秒)

但是sqlplus仍旧无法链接。

xdy3008 2010-06-21

打赏
举报

C:\Documents and Settings\231145>tnsping 10.225.106.30

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-6月 -
2010 16:29:44

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

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

TNS-03505: 无法解析名称

--------------------

这是什么原因呢？

iqlife 2010-06-21