ORA-12154:TNS:无法解析指定的连接标识符！

当连接oracle数据库时，报错：ORA-12154:TNS:无法解析指定的连接标识符！

看到错误，要分析一下为啥出错！实在不知道那就百度一下了！

首先看看配置文件里面配置了没有；

E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN下：

tnsnames.ora文件：

# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

SZQX2_100.153.98.23 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 100.153.98.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SZQX2)
      (SERVER = DEDICATED)
    )
  )

SZQX1_100.153.98.23 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 100.153.98.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SZQX1)
      (SERVER = DEDICATED)
    )
  )

SZQX_100.153.99.211 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 100.153.99.211)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SZQX)
      (SERVER = DEDICATED)
    )
  )
  
100.153.98.34 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 100.153.98.34)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SZQX)
      (SERVER = DEDICATED)
    )
  )

要想连接oracle数据库，必须在该文件中配置相关信息。

具体不清楚可以参考友情链接：ORA-12154:TNS:无法解析指定的连接标识符！