Oracle ORA-09925 Error: Unable to create audit trail file

Today a database login report ORA-09925 error

oracle@linux-37:~/oradata> sqlplus/as sysdba  
     
sql*plus:release 11.1.0.6.0-production on Tue Nov 22 18:04:21 201 1  
     
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 I nformation:9925  
ora-01075:you are currently logged on

The official description of the error is as follows:

ORA-09925 Unable to create audit trail file

Cause:oracle wasn't 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.

Before that mistake, remember it was like a filesystem full.

So look at the file system first.

linux-37:~ # DF

FileSystem 1k-blocks Used Available use% mounted on

More Wonderful content: 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 278492 1%/DEV/SHM

Find the file system is not full, then first restart the machine to try,

The machine does not enter the system properly after reboot.

Tips:

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)

·

The original file system is a problem, run fsck.ext3 to repair

Fsck.ext3-y/dev/sda5

The repair succeeds and then restarts.

Try the login database again, problem solving

oracle@linux-37:~> sqlplus/as sysdba  
     
sql*plus:release 11.1.0.6.0-production on Tue Nov (18:45:48)  
     
Co Pyright (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 o Ption
     
sql>

This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/723052