程序连接oracle数据库问题Cannot create PoolableConnectionFactory ...

时间:2023-03-09 09:25:15
程序连接oracle数据库问题Cannot create PoolableConnectionFactory ...

报错:

[ERROR] -- :: com.ipi.caee.InitServlet - 初始化数据加载异常
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: Got minus one from a read call)
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: Got minus one from a read call)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:)
at com.ipi.caee.app.service.system.ConfigManagerService$$EnhancerByCGLIB$$6556db91.loadSystemParameterList(<generated>)
at com.ipi.caee.base.quartz.SystemQuartz.loadConfigManager(SystemQuartz.java:)
at com.ipi.caee.base.common.ConfigManager.loadConfigManager(ConfigManager.java:)
at com.ipi.caee.base.common.InitLoad.init(InitLoad.java:)
at com.ipi.caee.InitServlet.init(InitServlet.java:)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:)
at java.util.concurrent.FutureTask.run(FutureTask.java:)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:)
at java.lang.Thread.run(Thread.java:)
Caused by: java.sql.SQLException: Io 异常: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:)
... more

问题可能原因:

1:数据库连接满了,扩大数据库连接池

2:所登录的机子IP不在sqlnet.ora内,加入后重启listerner即可

3:数据库负载均衡时,指定了(SERVER=DEDICATED),去除这个即可

问题检查:

1、查看当前连接和最高允许多少连接;

select count(*) from v$process ;    --当前的数据库连接数

select value from v$parameter where name ='processes';  --数据库允许的最大连接数

alter system set processes = 300 scope = spfile;  --修改最大连接数:

我的当前连接60,最高150,故不是因为连接数限制导致(ps:修改了连接数得重启)

2、你看看服务端sqlnet.ora 文件,有没有添加IP限制,监听日志里面有没有错误信息。

查看到sqlnet.ora中没有添加客户端,故将客户端ip添加

添加后并没有实时生效,必须执行lsnrctl reload,问题解决。(rac环境需要每个节点的文件都修改)

程序连接oracle数据库问题Cannot create PoolableConnectionFactory ...