今天一台数据库登录报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
以上是小编为您精心准备的的内容,在的博客、问答、公众号、人物、课程等栏目也有的相关内容,欢迎继续使用右上角搜索按钮进行搜索oracle
, dev
, file
, 系统
, ora-09925
, 错误
, sda
Unable to read XML
oracle audit trail、audit trail file、audit trail、dba audit trail、audit trail参数,以便于您获取更多的相关知识。