【ORACLE】ORA-09925 Unable to create audit trail file

今天临时加班接手同事夜间升级的RAC库。登录第一节点报错

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

$ 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日志：

?

1 2 3 4 5 6

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的设置

?

1 2 3 4 5 6

SQL> show parameter audit_file_dest   NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest                      string      /u01/app/oracle/admin/abce/adump SQL>

　　

在第一节点查找adump目录，发现不存在。

 

解决方案：
使用oracle用户新增目录

?

1	mkdir -p /u01/app/oracle/admin/abce/adump