ORA-09925: Unable to create audit trail file

auditoracle

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

Best Answer

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?

Related Solutions

Linux – Oracle returns an error ORA-01031: insufficient privileges

Something must have gone wrong at the O/S level - check this page for some steps to track down the problem

Oracle 12 startup issue: disk full

The database in the above will not open. Start the database in MOUNT mode, and clean up the archivelog area.

rman
RMAN> connect target sys/(the password)
RMAN> startup mount
RMAN> catalog recovery area;

Now you could clean up archivelogs, for example:

RMAN> delete archivelog all;

Finally, open the database:

RMAN> alter database open;

To prevent this from happening in the future, schedule a regular database backup + archivelog backup that deletes archivelogs. If you do not need backups and archivelogs, just disable archivelog mode while in MOUNT stage:

alter database noarchivelog;

Best Answer

Related Solutions

Linux – Oracle returns an error ORA-01031: insufficient privileges

Oracle 12 startup issue: disk full

Related Question