SQLException: ORA-00257: archiver error. Until only freed

1

Have an Oracle database connection that makes a simple insertion into the database.

The process was working, but you are now experiencing the error below.

2017-07-13 14:25:55.929 ERROR 12062 --- [nerContainer-21] c.z.h.p.HikariPool                       : monitorPool - Exception during pool initialization.

java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed.

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:444) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:407) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:416) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) ~[ojdbc6-11.2.0.4.jar!/:11.2.0.4.0]
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95) ~[HikariCP-java7-2.4.11.jar!/:?]
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101) ~[HikariCP-java7-2.4.11.jar!/:?]
    at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341) ~[HikariCP-java7-2.4.11.jar!/:?]
    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193) ~[HikariCP-java7-2.4.11.jar!/:?]
    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428) [HikariCP-java7-2.4.11.jar!/:?]
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499) [HikariCP-java7-2.4.11.jar!/:?]
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112) [HikariCP-java7-2.4.11.jar!/:?]
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97) [HikariCP-java7-2.4.11.jar!/:?]

I use Hikari as a connection pool manager.

Apparently to be a database disk space error.

How do I resolve this problem?

    
asked by anonymous 13.07.2017 / 20:18

1 answer

0

The problem was actually oracle ARCHIVE space that was full. And according to the DBA when this space is too full Oracle begins to reject the connections causing the error.

The ARCHIVES has been cleaned and the error has stopped.

    
14.07.2017 / 18:25