oracle ORA-09925 Unable to create audit trail file

一、今天发下有一个服务器上的ORACLE数据库访问不了，用sqlplus也登录不上去报：

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  

根据报错内容可以看出是某个文件被设置成了只读，猜想是不是服务器突然关机导致文件出错，用重启大法试下，重启后结果好了。网上查了一下有的重启会不能进入正常的系统报：

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>   

最后,网上也有说是文件权限问题，修改下文件权限就行了，这里就不多说，可以自己网上找下有很多。