pl/sql 远程连接数据库 ora-12154 '' TNS:could not resolve the connect identifier specified'
之前连上过,后来装了本地数据库,pl/sql现在能连上本地的,但是远程就会出现这个错误。环境变量设了
TNS_ADMIN:D:\oracle\product\instantclient_11_2 、
D:\oracle\product\instantclient_11_2 下 tnsnames.ora
“# tnsnames.ora Network Configuration File: D:\oracle\product\instantclient_11_2\tnsnames.ora
# Generated by Oracle configuration tools.
jswrmis =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.140)(PORT = 1521))
(CONNECT_DATA =
(SID = jswrmis)
(SERVER = DEDICATED)
)
)
E-LEARNING-NEW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.140)(PORT = 3306))
(CONNECT_DATA =
(SID = E-LEARNING-NEW)
(SERVER = DEDICATED)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SID = ORCL)
(SERVER = DEDICATED)
)
)”
但是只有最后一个ORCL 也就是本地的可以连上。求助求助
------解决思路----------------------
