Database Error in Administrator logs or Hawk Logs (DB Based Domain) **Error**Caused by: java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-00257: archiver error. Connect internal only, until freed.********
Article ID: KB0092552
Updated On:
| Products | Versions |
|---|---|
| TIBCO Administrator | - |
| Not Applicable | - |
Description
Resolution:
ORA-00257 indicates the archiver process received an error while trying to archive a redo log.
The most likely cause of this message is the destination device is out of space to store the
redo log file.
Your database is running in ARCHIVELOG mode, because the database is running in archive log mode, the redo log files are archived to an archive destination. (one of) the destination(s) have no sufficient space left to write the archived redo logs to.
Action: Check archiver trace file for a detailed description of the problem. Also verify that the
device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.
SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
SQL> select destination from v$archive_dest;
...
Check if there is sufficient space left, if not, archive the archived redo logs to tape/other disk/...
The database should free itself after this error. If this is not the case try issuing the alter
system archive log all; command connected AS SYSDBA.
Issue/Introduction
Feedback
