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