Oracle Database

ORA-09817: Write to audit file failed.

Bügün test veritabanım da çalışmak istediğimde aşağıdaki gibi bir hata aldım. Bu sıralar bu makinayı çok kurcalıyorum farkındayım : )

ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device

 

df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_node1230231-lv_root
                       34G   33G   0G   100% /
tmpfs                 4.0G  1.9G  2.2G  46% /dev/shm
/dev/sda1             485M   55M  405M  12% /boot

 

Çözüm şu şekilde;
/u01/oracle/app/oracle/admin/orcl/adump. içerisindeki audit dosyalarını temizlediğinizde probleminiz düzelecek.

cd /u01/oracle/app/oracle/admin/orcl/adump
rm *

Bugra Parlayan

I use this blog in my spare time to jot down thoughts and share my professional experiences. It’s my personal space to unwind and reflect. Feel free to share or reuse anything you find helpful here — just a small thank you is more than enough :) You can reach me at: bugra[@]bugraparlayan.com.tr

Related Articles

Back to top button
Close