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

用PLSQL Developer连接Oracle数据库时报错，.\Oracle\product\10.2.0\db_1\network\ADMIN\tnsnames.ora 文件为手工配置

经多次尝试，发现是\tnsnames.ora文件中命名的多了空格导致的问题，去掉后就可以了。

如下：

错误格式：

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.62)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )


  BSDORCL_44 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.50.44)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = bsdorcl)
      (SERVER = DEDICATED)
    )
  )

将BSDORCL_44 = 前面的空格去掉即可（即顶格）