ORA-09817: Write to audit file failed.

on 11:01 PM

[oracle@exdprd]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 26 07:59:43 2018

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

ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on

Workaround :

1. Check the free space of mount point /u01 

[oracle@exdprd]$ df -h

2. Remove old and unwanted trace and audit files.

3 . Check the space now on mount pount /u01

4. Now we will be able to login successfully. 

0 comments:

Post a Comment