My Oracle Support Banner

Retrieving Audit Setting Using AVDF Fails With 'Failed to connect to DB' Error (Doc ID 2589826.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

After implementing Audit policy on the Secured Target database using AVDF getting following error while retrieving the audit settings.

'Failed to connect to DB'

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
 1. In the tnsnames.ora (located under $ORACLE_HOME/network/admin) on the Audit Vault Server create a TNS Alias (as "oracle" user) to the Secured Target 
 2. Try to connect to the Secured Target (from Audit Vault server using SQL*Plus) using the TNS Alias created in Step#1
 3. If the connection is Successful modify the Connection String for the Secured Target in Audit Vault UI and update same as what's added in Step#1
References


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