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

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.

 

Environment

CA Workload Automation DE 
OS: Any
DB: Oracle 

Cause

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

Resolution

Clear the logs in database filesystem.

Additional Information

Consult Oracle on any archiver related issues and patches.