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前面不能有空格