java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress

2024-04-21 11:09•python•阅读 3895

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)

at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:287)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:356)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)

at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)

at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)

at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)

at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1a0e99 -- Acquisition Attempt Failed!!! Clearing pending acquires.

While trying to acquire a needed new resource, we failed

to succeed more than the maximum number of allowed

acquisition attempts (30).

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@b46504 -- Acquisition Attempt Failed!!! Clearing pending acquires.

While trying to acquire a needed new resource, we failed

to succeed more than the maximum number of allowed

acquisition attempts (30).

---------------------------------以上为启动tomcat后所报的错误：

在网上搜罗了半天，大多数说是oracle 文件误删造成的。造成数据库ORA-01033 没法登陆等等

但是我的项目不影响访问，数据库也可以正常连接。就是在项目启动加载连接时配置是会出现这个错误。

早了半天没找到，但是把问题锁定在配置上，于是删了项目重新导入没有改配置前的项目备份。项目启动有恢复到正常情况。

据报错日志分析： c3p0连接池间隔性的加载了两次，在最后一次加载时报错。。。