DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, July 15, 2017

ORA-09925: Unable to create audit trail file WHILE sqlplus / as sysdba

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 6 14:30:37 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on


It’s easy to resolve ora-09925 if you can sqlplus / as sysdba.
You can create pfile from your spfile, change audit location, shutdown your DB and startup with newly changed pfile by yourself.

Solution:

If you can not sqlplus / as sysdba, you can run this one-liner:

## Go to your alert.log dir:
cd /u01/app/oracle/diag/rdbms/YOURDB/YOURDB/trace
mkdir -pv $(dirname $(tail -1000 alert*.log | grep "Could not open audit file" | awk -F":" '{print $2}' |\tail -1)) 2>/dev/null