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

book

Article ID: 88119

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.

Cause

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

Environment

Database: Oracle

Resolution

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.