OS Audit file could not be created； failing after 6 retries

下午有客户找过来，说数据库无法使用了，立刻查看alert日志，报错如下。

Sun Oct 08 12:46:59 2023
OS Audit file could not be created; failing after 6 retries
Sun Oct 08 12:47:36 2023
OS Audit file could not be created; failing after 6 retries
Sun Oct 08 12:48:45 2023
OS Audit file could not be created; failing after 6 retries
Sun Oct 08 12:50:59 2023
OS Audit file could not be created; failing after 6 retries
Sun Oct 08 12:51:05 2023
OS Audit file could not be created; failing after 6 retries
Sun Oct 08 12:51:12 2023
OS Audit file could not be created; failing after 6 retries
Sun Oct 08 12:51:21 2023
OS Audit file could not be created; failing after 6 retries

使用sqlplus登录报错如下，问题较为明显是审计数据太大导致的问题

$  sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 9 17:12:32 2023

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

ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on

切换到审计目录下查看，近1900万，第一次知道，极限值为18921899

#cd /u01/app/oracle/admin/orcl/adump/
# ls |wc -l
18921899

处理办法

#  find /u01/app/oracle/admin/orcl/adump/  -name "*.aud"  -mtime +0 | xargs rm -rf "*.aud"

 
操作系统版本：CentOS release 6.10 (Final)

#  getconf ARG_MAX
2621440