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_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string orcl
SQL> show parameter instance_name
NAME 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)
)
)
plsql连接oracle出现ORA-12154: TNS: 无法解析指定的连接标识符
最新推荐文章于 2024-02-27 08:57:17 发布