My Oracle Support Banner

DEADLOCK DETECTED in /var/log/messages in AVDF (Doc ID 2185535.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

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

Symptoms

Reported issues due to this problem so far:

1. The audit trail is going down automatically

2. AVDF not able to capture user login/logout events

Following message appear in /var/log/messages file

DEADLOCK DETECTED ( ORA-00060 )

[Transaction Deadlock]

The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:

 

Deadlock graph:
---------Blocker(s)--------
---------Waiter(s)---------
Resource Name process session holds waits process session holds
waits
TM-00013223-00000000 114 36 SX 109 272
X
UL-40000036-00000000 109 272 X 114 36
S

session 36: DID 0001-0072-00001353 session 272: DID 0001-006D-000079B7
session 272: DID 0001-006D-000079B7 session 36: DID 0001-0072-00001353

 

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


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