ORA-00925

SYMPTOMS

 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 11 13:34:07 2024

Copyright (c) 1982, 2013, 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

CAUSE

The audit_file_dest directory does not exist or has insufficient permission.

SOLUTION

~]$ mkdir -p $ORACLE_BASE/admin/coco/adump
~]$ chmod 750 $ORACLE_BASE/admin/coco/adump
~]$ ls -ld $ORACLE_BASE/admin/coco/adump
drwxr-x--- 2 oracle oinstall 4096 Feb 11 13:46 /u01/app/oracle/admin/coco/adump