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

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

2、检查配置是否正确

ORCL=  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))    )    (CONNECT_DATA =      (SID = ORCL)    )  )

3、记得最前面orcl

前面不能有空格