Adsense Ad

Thursday, 1 June 2017

Oracle: ORA-00257 Error Message

ORA-00257 Error Message

Learn the cause and how to resolve the ORA-00257 error message in Oracle.

Description

When you encounter an ORA-00257 error, the following error message will appear:
  • ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed

Cause

While trying to archive a redo log file, the ARCH process encountered an error.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

This error can be caused when the destination device does not have enough storage space to store the redo log file.

Option #2

Check that the initialization parameter ARCHIVE_LOG_DEST in the initialization file is set correctly.
It may be helpful to check the archiver trace file for more details on the problem.
Note: If this problem is not resolved, Oracle will stop executing transactions.

No comments: