在我删掉workspace下的.metadata文件,再次创建的新workplace后,以前可以正常连接数据库的Java程序报错,提示java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
程序连接oracle数据库,运行报错提示ORA-12505
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
2条回答 默认 最新
- 人海y 2017-04-03 11:09关注
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
))
ADR_BASE_LISTENER = D:\app\Administrator
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
(SID_NAME = orcl)
)
)解决 无用评论 打赏 举报