Fix ORA-09817: Write to audit file failed. SVR4 Error: 28: No space left on device

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Error Descirption:
Sqlplus “/ as sysdba” failing with ORA-09817 error.
bash-3.00$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jun 14 14:21:09 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-09817: Write to audit file failed.
SVR4 Error: 28: No space left on device
ORA-01075: you are currently logged on

Solution:
Check the file system space for ORACLE_HOME. It must be 100% full and it is not allowing oracle to create audit files. Try to find out some unwanted file from the file system and remove those. Make some room for new audit files.

Remove .aud, .trc, trm files from the file system

/export/home/oracle/product/10.2.0/Db_1/admin/orcl/adump
bash-3.00$ find . -name *aud -print|more
./rdbms/audit/ora_3430.aud
./rdbms/audit/ora_3459.aud
./rdbms/audit/ora_3527.aud
./rdbms/audit/ora_3578.aud
./rdbms/audit/ora_7423.aud
./rdbms/audit/ora_7556.aud
./rdbms/audit/ora_7732.aud

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer