My Oracle Support Banner

AVDF 20.2: AVDF database crashes automatically (Doc ID 2855138.1)

Last updated on MARCH 21, 2022

Applies to:

Oracle Audit Vault and Database Firewall - Version 20.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

AVDF database shutdown automatically. The instance termination is seen in the dbfw alert.log

alert__ASM_bkp.log
#######################


2022-01-10T13:24:12.600695+00:00
ERROR: ALTER DISKGROUP SYSTEMDATA DISMOUNT /* asm agent stack shutdown *//* {0:0:12704} */
2022-01-10T13:25:07.995396+00:00
WARNING: client [dbfwdb:dbfwdb:ASM] cleanup delayed; waited 16884s, pid 24731 mbr 0x0
2022-01-10T13:26:11.163214+00:00
WARNING: client [dbfwdb:dbfwdb:ASM] cleanup delayed; waited 16944s, pid 24731 mbr 0x0
2022-01-10T13:27:14.331417+00:00
WARNING: client [dbfwdb:dbfwdb:ASM] cleanup delayed; waited 17004s, pid 24731 mbr 0x0
2022-01-10T13:28:07.196769+00:00
WARNING: CLMN has failed to cleanup a dead process for 1400 attempts
2022-01-10T13:28:17.499128+00:00
WARNING: client [dbfwdb:dbfwdb:ASM] cleanup delayed; waited 17064s, pid 24731 mbr 0x0
2022-01-10T13:29:20.667167+00:00
WARNING: client [dbfwdb:dbfwdb:ASM] cleanup delayed; waited 17124s, pid 24731 mbr 0x0
2022-01-10T13:30:19.033894+00:00
System State dumped to trace file /var/lib/oracle/diag/asm/+asm/+ASM/trace/+ASM_ora_17397.trc
2022-01-10T13:30:20.364918+00:00
Shutting down ORACLE instance (abort) (OS id: 17671)
Shutdown is initiated by oraagent.bin@avs005056b9dfbd (TNS V1-V3).<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
License high water mark = 19
USER (ospid: 17671): terminating the instance
2022-01-10T13:30:21.373205+00:00
Instance terminated by USER, pid = 17671
2022-01-10T13:30:21.452218+00:00
Instance shutdown complete (OS id: 17671)
2022-01-10T14:01:45.022711+00:00
MEMORY_TARGET defaulting to 1128267776.

instance_number obtained from CSS = 1, checking for the existence of node 0...
* node 0 does not exist. instance_number = 1
Starting ORACLE instance (normal) (OS id: 6243)<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
2022-01-10T14:01:45.077554+00:00

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.