本文共 800 字,大约阅读时间需要 2 分钟。
plsql连接oracle出现ORA-12154: TNS: 无法解析指定的连接标识符问题 plsql配置文件tnsnames.ora中的原配置文件中的内容为 orcl (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.89)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wmprod) ) ) 后经查询发现我的oracle中的SERVICE_NAME和sid不一样 SQL> show parameter db_nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_name string orclSQL> show parameter instance_nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------instance_name string wmprod把tnsnames.ora中的配置文件修改后可以正常连接 orcl (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.89)(PORT = 1521)) ) (CONNECT_DATA =(SID = wmprod) ) )
转载地址:http://mbsni.baihongyu.com/