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

Source: Internet
Author: User
Tags reserved oracle database sqlplus linux

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.