Sqlexception: ORA-00257: Archiver error. Connect Internal only, until Freed

Asked

Viewed 1,279 times

1

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

The process was working, but now this presenting 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 disk space error from the database.

How do I solve such a problem?

java database oracle

  • See if this helps: https://www.techonthenet.com/oracle/errors/ora00257.php

  • 1

    I had seen this link but it was not clear how to execute the solution.

1 answer

0


The problem was really oracle ARCHIVE space which was full. And according to the DBA when that space is too full Oracle starts to reject the connections causing error.

The ARCHIVES was cleaned and the error stopped

Browser other questions tagged java database oracle

You are not signed in. Login or sign up in order to post.