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

$ sqlplus / as sysdba

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

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

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.


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

  • July 15, 2017 | 16 views
  • Comments