ORA-00257 归档程序错误。在释放之前仅限于内部连接案例

现象

shell

========== Running state of HUAWEI infoX IAG system 20100407 09:09:05 ==========
The path of the installation : /home/mmsg/mms_home. 
The monitor process  is running well-balanced . pid:7753

=============================== List of Local IP ===============================
10.164.75.102       127.0.0.1           192.168.100.106     
[2010-04-07 09:09:05.527] DB Error :ORA-00257: 归档程序错误。在释放之前仅限于内部连接
 dbname:"mmsgdb_222", dbuser:"mmsg"

尝试登录数据库

shell

164 mmsg01 [mmsg] :/home/mmsg>sqlplus mmsg/mmsg@mmsgdb_222

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Apr 7 09:09:54 2010

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

ERROR:
ORA-00257: 归档程序错误。在释放之前仅限于内部连接


Enter user-name: mmsg
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:

原因

shell

00257, 00000, "archiver error. Connect internal only, until freed."
// *Cause:  The archiver process received an error while trying to archive
//       a redo log.  If the problem is not resolved soon, the database
//       will stop executing transactions. The most likely cause of this
//       message is the destination device is out of space to store the
//       redo log file.
// *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.

查看数据库日志运行模式，发现是在归档模式下，上述错误码信息显示是out of space to store the redo log file.存储空间不足。

查看文件系统

shell

oracle@mmsg:~> df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda2             30969600   3364888  26031548  12% /
udev                   8218880       176   8218704   1% /dev
/dev/sda5             50150072  29613880  17988688  63% /home
/dev/sda6             41286796  39191128         0 100% /opt
opt空间已满！

完整解决方法，请查阅我的github blog：Oracle案例--错误码之ORA-00257 | Transcendent (gavin-wang-note.github.io)

来源: Transcendent
文章作者: Gavin Wang
文章链接: Oracle案例--错误码之ORA-00257 | Transcendent
本文章著作权归作者所有，任何形式的转载都请注明出处。