debugMinor
ORA-09925: Unable to create audit trail file
Viewed 0 times
filecreateauditunabletrailora09925
Problem
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
When I run this df -h command I'm not seeing the file system it's just showing as below
I do not understand cause of this issue. Please let me know how to solve this issue
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: 9925When 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 onI do not understand cause of this issue. Please let me know how to solve this issue
Solution
Try this:
connect to SQL*Plus, then do:
then exit SQL*Plus and do:
What are the permissions? Ownership?
Perhaps a mounted filesystem has gone missing, and you don't have write permissions on the underlying mountpoint?
connect to SQL*Plus, then do:
show parameter audit_file_destthen exit SQL*Plus and do:
cd
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?
Code Snippets
show parameter audit_file_destcd <path displayed above>
ls -ld .Context
StackExchange Database Administrators Q#9923, answer score: 3
Revisions (0)
No revisions yet.