Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm using Oracle 11.1.0.6.0 db, on Linux 64 bit server on Amazon cloud.

I'm getting following error when I run the connect command

SQL> connect / as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925

When I run this df -h command I'm not seeing the file system it's just showing as below

$ df -h
Filesystem Size Used Avail Use% Mounted on

I do not understand cause of this issue. Please let me know how to solve this issue

share|improve this question
1  
Seems that the filesystem on which the database is installed is readonly.? –  Benoit Dec 21 '11 at 16:09
    
Please update with output of mount (edit your question if possible) –  kubanczyk Dec 29 '11 at 23:00

3 Answers 3

Try this: connect to SQL*Plus, then do:

show parameter audit_file_dest

then exit SQL*Plus and do:

cd <path displayed above>
ls -ld .

What are the permissions? Ownership?

Perhaps a mounted filesystem has gone missing, and you don't have write permissions on the underlying mountpoint?

share|improve this answer

It seems to be a Linux issue, not an Oracle issue. The simplest solution, if possible, it to reboot your system.

If this does not solve the problem, note if there is anything interesting in /var/log/*.

If this turns into a system-related or filesystem-related question, ask it at Server Fault or, if you find it more appropriate, on unix.stackexchange.com

share|improve this answer
    
Mind-bogglingly, after searching here and there this is the only solution to my similar problem -- When trying to recreate a database (after Oracle "forgot" which control files it has created), for a particular SID I kept getting audit trail file errors even though other SIDs are fine. Until I restarted. –  michel-slm Sep 19 '12 at 4:14

If the file system is missing then you haven't mounted it. You say that you are on Amazon, Have you created an S3 volume for your datafiles and software, or did you just use instance storage?

If the latter then the instance store is not persistent (See this for a related question).

If you have used an S3 volume is it presented to the vm and then mounted?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.