ora-12154无法解析指定的连接标识符

qiumenglu

刚刚创建Oracle，使用plsql客户端登陆时报错

tnsnames.ora内容如下：
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =uf001186)(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)
    )
  )

*************************************

sqlnet.ora内容如下：
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

**************************************************

listener.ora内容如下：
# listener.ora Network Configuration File: D:\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 =ORCL)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (SID_NAME = ORCL)
    )
)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST =uf001186)(PORT = 1521))
    )
  )


请求各位大侠帮忙看看，着急！！！！！！！！！！！！！！！

jackson198574

回复 1# qiumenglu


    把tnsnames.ora中的host = 后面改正主机IP试试。

qiumenglu

回复 2# jackson198574


    谢谢，已经解决了！

jackson198574

回复 3# qiumenglu


    客气，欢迎多来交流 ~~~

dzminglong

   写成计算机名字也是可以的，不过你需要在客户端的hosts文件加条记录。