• Home
• 

• Products
• DbaBar

• Oracle administration made easy

• OraSpy

• Simple Oracle monitoring

• Oracle Locator Express

• The Oracle Home Selector Replacement

• Oracle Password Changer

• Change (expired) passwords

• Oracle Listener Remover

• Remove obsolete Listeners on Windows

• Actions
• Download

• Download Free Products and Trials

• Buy Licenses

• Buy an official license

• Support

• Get support for our products

• Oracle Error Codes

• Oracle Error Messages Explained

• DbMotive
• About Us

• Everything you want to know about us

• News

• Jan 27th: New Oracle Locator Express Release

• Sitemap

• Browse our website

 ORA-00257: Archiver error. Connect internal only, until freed

Your database is running in ARCHIVELOG mode:


SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

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.



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.