OS AUDIT ERROR IN ASM AND ORA-09925 in RDBMS
(Doc ID 1921650.1)
Last updated on DECEMBER 10, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
1] The following error message is reported in ASM alert.log
OS Audit file could not be created; failing after x retries
2] The following similar message is visible in RDBMS alert.log
Additional information: 9925
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '+DATA/asmdb/datafile/rcts.343.849109407'
ORA-01565: error in identifying file '+DATA/asmdb/datafile/rcts.343.849109407'
ORA-17503: ksfdopn:2 Failed to open file +DATA/asmdb/datafile/rcts.343.849109407
ORA-15055: unable to connect to ASM instance
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
NOTE: deferred map free for map id 180
WARNING: ASM communication error: op 18 state 0x40 (9925)
ERROR: slave communication error with ASM
NOTE: Deferred communication with ASM instance
Errors in file /u01/app/oracle/diag/rdbms/asmdb/ASMDB/trace/ASMDB_pmon_3692.trc:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '+DATA/asmdb/datafile/rcts.343.849109407'
ORA-01565: error in identifying file '+DATA/asmdb/datafile/rcts.343.849109407'
ORA-17503: ksfdopn:2 Failed to open file +DATA/asmdb/datafile/rcts.343.849109407
ORA-15055: unable to connect to ASM instance
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
NOTE: deferred map free for map id 180
WARNING: ASM communication error: op 18 state 0x40 (9925)
ERROR: slave communication error with ASM
NOTE: Deferred communication with ASM instance
Errors in file /u01/app/oracle/diag/rdbms/asmdb/ASMDB/trace/ASMDB_pmon_3692.trc:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
3] Logging in ASM instance produces the following error.
$ sqlplus / as sysasm
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
ORA-01075: you are currently logged on
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
ORA-01075: you are currently logged on
4] Filesystem for GRID home shows enough space
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/host_root
9.7G 1.8G 7.5G 19% /
/dev/mapper/host_var
4.9G 923M 3.7G 20% /var
/dev/mapper/host_usr
4.9G 3.4G 1.3G 74% /usr
/dev/mapper/host_crs_oracle
54G 23G 28G 46% /crs/oracle <<<<<<<<<------------ GRID HOME filesystem
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/host_root
9.7G 1.8G 7.5G 19% /
/dev/mapper/host_var
4.9G 923M 3.7G 20% /var
/dev/mapper/host_usr
4.9G 3.4G 1.3G 74% /usr
/dev/mapper/host_crs_oracle
54G 23G 28G 46% /crs/oracle <<<<<<<<<------------ GRID HOME filesystem
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |