oracle ORA-09925錯誤：Unable to create audit trail file

今天一台資料庫登入報ORA-09925錯誤

oracle@linux-37:~/oradata> sqlplus / as sysdba       SQL*Plus: Release 11.1.0.6.0 - Production on Tue Nov 22 18:04:21 2011       Copyright (c) 1982, 2007, Oracle.  All rights reserved.       ERROR:  ORA-09925: Unable to create audit trail file  Linux-x86_64 Error: 30: Read-only file system  Additional information: 9925  ORA-01075: you are currently logged on

該錯誤的官方描述如下：

ORA-09925 Unable to create audit trail file

Cause: Oracle was not able to create the file being used to hold audit trail records.

Action: Check the UNIX error number for a possible operating system error. If there is no error, contact Oracle Support Services.

之前碰到過該錯誤，記得當時好像是檔案系統滿了。

所以先查看下檔案系統

linux-37:~ # df

Filesystem           1K-blocks      Used Available Use% Mounted on

更多精彩內容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

/dev/sda2             41286828   2748468  36441076   8% /

udev                   1025804       356   1025448   1% /dev

/dev/sda5             51613016  40310456   8680756  83% /home

/dev/sda3             51613048   6702328  42288912  14% /opt

tmpfs                   278528        36    278492   1% /dev/shm

發現檔案系統沒滿，那麼先把機器重啟下試試，

重啟後機器不能正常進入系統。

提示：

Press enter for maintenance

(or type Control-D to continue):

/dev/sda5 contains a file system with errors, check forced.

/dev/sda5: Inodes that were part of a corrupted orphan linked list found.

……

/dev/sda5: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY.

(i.e., without -a or -p options)

·

原來是檔案系統有問題，運行fsck.ext3進行修複

fsck.ext3 -y /dev/sda5

修複成功，然後重啟。

再試試登入資料庫，問題解決

oracle@linux-37:~> sqlplus / as sysdba       SQL*Plus: Release 11.1.0.6.0 - Production on Tue Nov 22 18:45:48 2011       Copyright (c) 1982, 2007, Oracle.  All rights reserved.            Connected to:  Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production  With the Partitioning option     SQL>

本文出自 “richard的筆記-積微成著” 部落格，請務必保留此出處http://zxf261.blog.51cto.com/701797/723052