今天一台数据库登录报ORA-09925错误

 

 
  
  1. oracle@linux-37:~/oradata> sqlplus / as sysdba  
  2.  
  3. SQL*Plus: Release 11.1.0.6.0 - Production on Tue Nov 22 18:04:21 2011  
  4.  
  5. Copyright (c) 1982, 2007, Oracle.  All rights reserved.  
  6.  
  7. ERROR:  
  8. ORA-09925: Unable to create audit trail file  
  9. Linux-x86_64 Error: 30: Read-only file system  
  10. Additional information: 9925  
  11. 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
 /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
 修复成功，然后重启。
 
  
再试试登录数据库，问题解决
 
  

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