CA WA DE does not start due to Exception: ORA-00257 archiver error

book

Article ID: 132238

calendar_today

Updated On:

Products

DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

The CA WA DE does not start or shuts down.  The tracelog and errors.txt show the following error.
 
20XXXXX 19:57:21.XXX [relationaldatabase] [ERROR] main: Exception: ORA-00257: archiver error. Connect internal only, until freed. 

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

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) 
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) 
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:308) 
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:364) 
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508) 
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203) 
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) 
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) 
at java.sql.DriverManager.getConnection(DriverManager.java:571) 
at java.sql.DriverManager.getConnection(DriverManager.java:187) 
at com.cybermation.espresso.rdbms.DBConnectionPool.newConnection(DBConnectionPool.java:746) 
at com.cybermation.espresso.rdbms.DBConnectionPool.getOrCreateConnection(DBConnectionPool.java:636) 
at com.cybermation.espresso.rdbms.DBConnectionPool.getConnection(DBConnectionPool.java:309) 
at com.cybermation.espresso.rdbms.RelationalDatabaseManager.canConnect(RelationalDatabaseManager.java:1440) 
at com.cybermation.espresso.bootstrap.ServerMain.createRelationalDatabaseManager(ServerMain.java:2189) 
at com.cybermation.espresso.bootstrap.ServerMain.main(ServerMain.java:288) 
20190511 19:57:21.455 [relationaldatabase] [ERROR] main: SQLCode: 257 SQLState: 64000 Message: ORA-00257: archiver error. Connect internal only, until freed.

 

Cause

The Oracle DB filesystem is out of space due to archiver error.

Environment

CA Workload Automation DE 
OS: Any
DB: Oracle 

Resolution

Clear the logs in database filesystem.

Additional Information

Consult Oracle on any archiver related issues and patches.