search cancel

Unable to start WP and CP processes receiving ORA-00257 error


Article ID: 88119


Updated On:


CA Automic Workload Automation - Automation Engine


All the Automation Engine Work Processes (WPs) and Communication Processes (CPs) are down and in the Automation Engine logs display the above ORA-00257 error.

Error Message in WP / CP logs:

U0003590 UCUDB - DB error: 'OCILogon', 'ERROR ', '', 'ORA-00257: archiver error. Connect internal only, until freed.'

Error message in JCP trc files:

----------------------- Stack Trace -----------------------
com.automic.database.api.DBException: java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.


Database: Oracle


This is an Oracle error (ORA-00257) generated when Oracle runs out of space in the filesystem, usually ocurring while trying to archive a redo log


ORA-00257 is caused by situations which are completely contained within the scope and purview of Oracle's products and are outside of Automic's responsibility.

This error is captured in our log files, however, it is being returned from Oracle.

It could indicate the database is out of space. This could happen when the archiver process gets an error trying to archive redo logs.

Contact your Oracle Database Administrator or the Oracle Customer Support team and have them analyze the issue.

Usually, cleaning the Oracle filesystem from previous traces/dumps should fix the issue.