【BUG】eclipse连接oracle数据库失败：ORA-12505

最新推荐文章于 2022-05-10 16:40:23 发布

xuana0919

最新推荐文章于 2022-05-10 16:40:23 发布

阅读量1.1k

点赞数

文章标签：数据库 eclipse oracle descriptor jdbc exception

本文链接：https://blog.csdn.net/xuana0919/article/details/6881681

版权

当使用Eclipse尝试连接Oracle数据库时遇到ORA-12505错误，通过修改applicationContext配置文件，将JDBC数据库配置中的service name替换为sid name，可以解决问题。具体步骤包括查看数据库当前的sid name。参考相关链接以获取详细操作指南。

摘要由CSDN通过智能技术生成

错误代码如下：

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC connection; nested exception is 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
The Connection descriptor used by the client was:
128.64.96.33:1522:CLPM0701

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
The Connection descriptor used by the client was:
128.64.96.33:1522:CLPM0701

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
	at oracle.jdbc.driver.T4CConnec