Wednesday, April 15, 2015

ORA-09925: Unable to create audit trail file

Issue.

-bash-4.1$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 16 09:45:39 2015

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

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

-bash-4.1$ ps -ef |grep pmon
oracle 12446     1   0 09:43:30 ?           0:00 ora_pmon_OBITEST
oracle 12481 12367   0 09:50:01 pts/1       0:00 grep pmon

-bash-4.1$ kill -9 12446

-bash-4.1$ mkdir -p /data01/TEST/admin/TEST/adump
-bash-4.1$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 16 09:53:13 2015

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

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 5463277568 bytes
Fixed Size                  2191256 bytes
Variable Size            1342181480 bytes
Database Buffers         4110417920 bytes
Redo Buffers                8486912 bytes
Database mounted.
Database opened.
SQL>
SQL>

No comments:

Post a Comment