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

打开plsql安装目录下的tnsnames.ora

检查配置是否正确 ORCL=  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))    )    (CONNECT_DATA =      (SID = ORCL)    )  )

记得最前面orcl 前面不能有空格