今天在java内连接数据库时出现ORA-12154: TNS: 无法解析指定的连接标识符错误,结果发现是tnsname出现问题
出现错误的时候tnsname文件内容:
ORANGE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SKY-20151201KLV)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORANGE)
)
)
修改为
ORANGE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORANGE)
)
)
连接恢复正常,tnsname位置在F:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN文件夹里
但是换了之后pl\sql还是出现这个错误,再换为原来的,错误就没有了,不知道怎么回事,等待后续