SQLPLUS Connect, Startup Fails with ORA-09925: Unable to create audit trail file SVR4 Error: 13

advertisements

_____________________________________________________________________________________________________________________

Error Description:

Sqlplus / as sysdba or database startup command fails with ORA-09925: Unable to create audit trail file.

The subsequent OS errors will be different like

Linux-ia64 Error: 28: No space left on device

Linux-x86_64 Error: 27: File too large

SVR4 Error: 13: Permission denied

Solution Description:

Check the following item in your database.

1. Check whether your Audit directory physically exist or not

Location would be for 10gR2 and above $ORACLE_HOME/admin/<YOUR DB SID>/adump and prior release it would be $ORACLE_HOME/rdbms/audit

If you are able to connect to sqlplus / as sysdba check the parameter value for audit_file_dest to get the exact location

2. Check the directory permissions are set to 755 unix privileges
3. Make sure the file system which belongs to this Audit directory has enough free space to create the audit files. If there is no room for new audit files, remove old files using operating system commands.

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Schwyz viewed 'Oracle: SQL Query to Find out Index Name, Column N' 2 mins ago

A visitor from Kerala viewed 'Troubleshoot Fix error IMP-00038: Could not conver' 11 mins ago

A visitor from Kothanur viewed 'Fix ORA-15505: cannot start workload capture becau' 14 mins ago

A visitor from Milan viewed 'Oracle 12c 18c 19c: How to find out the Listener.l' 24 mins ago

A visitor from Louangphrabang viewed 'Data Pump (expdp/impdp) Tuning features - PARALLEL' 26 mins ago

Real-time | Get Script | More Info