-
错误问题:ORA-12505
出现原因:
org.springframework.transaction.CannotCreateTransactionException:
Could not open JDBC Connection for transaction; nested exception is weblogic.jdbc.extensions.PoolDisabledSQLException:
weblogic.common.resourcepool.ResourceDisabledException: Pool JDBC Data ORA-12505,TNS:listener does not currently know of SID given in connect descriptor. ...
Caused by: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException:Pool JDBC Data Source-0 is suspended.
Cannot allocate resurces to applications.
解决方法:
1> 检查数据库中当前的 sid
:
select INSTANCE_NAME from v$instance;
2> 查看 weblogic 中关于 数据库连接池的配置,配置名称为 <