【ORACLE】ORA-09925 Unable to create audit trail file
2022-06-03 10:59 abce 阅读(694) 评论(0) 编辑 收藏 举报今天临时加班接手同事夜间升级的RAC库。登录第一节点报错
$ sqlplus /nolog SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 3 10:38:51 2022 Version 19.14.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. SQL> conn /as sysdba ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 2: No such file or directory Additional information: 9925 ORA-01075: you are currently logged on SQL>
查看alert日志：
OS Audit file could not be created; failing after 6 retries 2022-06-03T10:29:38.076034+08:00 OS Audit file could not be created; failing after 6 retries 2022-06-03T10:30:03.510360+08:00 OS Audit file could not be created; failing after 6 retries 2022-06-03T10:30:08.514569+08:00
在第二个节点登录，可以正常登录。查看一下audit_file_dest的设置
SQL> show parameter audit_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /u01/app/oracle/admin/abce/adump SQL>
在第一节点查找adump目录，发现不存在。
解决方案：
使用oracle用户新增目录
mkdir -p /u01/app/oracle/admin/abce/adump
