SID错误导致的异常： org.apache.commons.dbcp.SQLNestedException

最新推荐文章于 2025-04-14 10:08:47 发布

原创最新推荐文章于 2025-04-14 10:08:47 发布 · 268 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #数据库

DateSource 专栏收录该内容

105 篇文章

订阅专栏

本文介绍了一个关于数据库连接失败的问题，具体表现为ORA-12505错误，原因是客户端使用的连接描述符中指定的服务标识符（SID）未被监听器识别。文章详细记录了错误堆栈，指出问题在于数据库SID配置不正确。

部署运行你感兴趣的模型镜像

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (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:
localhost:1521:oracl
)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
	... 28 more
Caused by: 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:
localhost:1521:oracl

原因：数据库SID错误

您可能感兴趣的与本文相关的镜像