Configure/Add the Target Databases on AVDF to monitor

by sys_oracleon Posted on

Below are the high level steps to add the target databases on AVDF using GUI console

Step-1 Login to the AV Console using AVADMIN

Step-2 Download agent from AVDF console

Step-3 Transfer agent software to Target DB server

Step-4 Register Agent for Target DB server on AV console

Step-5 Install the Agent on target database server

Step-6 Register Target DB on AV console

Follow below steps to add the target databases on AVDF using GUI console

Step-1 Login to the AV console using avadmin user

Step-2 Under the Agent tab download the Audit Vault Agent only as of now as below steps in snap

Apologies:- Snaps are blur due to security reasons.

Step-3 Transfer agent software to Target DB server

Step-4 Register Agent for Target DB server on AV console

Provide the Name of Agent and IP Address of DB server and Click on Save button

Example:- Name is EBSDB

It will generate a key, Please copy the activated Key from screen

Under the Agent tab (marked as green color), Copy the Activation key and follow the next steps as below

Apologies:- Snaps are blur due to security reasons.

Step-5 Install the Agent on target database server

Now Login to target database server and check the java version

Install the AV Agent software on target DB server as below

Command:- java -jar agent.jar -d /u02/my_location/AVAGENT

Now start the Agent as below snap

Command:- cd /u02/my_location/db/AVAGENT

./agentctl start -k (This will ask the activation key as –k)

Note: - Do not use –k again to start/stop agent

Check the status of the Agent on AVDF GUI console as below

Apologies:- Snaps are blur due to security reasons.

Execute below script on Target Database for granting privileges for different types of Reports to the schema

1- Create schema in target db and

2. Go to the location of- /u02/db/AVAGENT/av/plugins/com.oracle.av.plugin.oracle/config

Three modes to granting privileges for schema inside the target database

1. SETUP mode for granting Audit collection and Audit policy management privileges

2. SPA mode for granting stored procedure auditing privileges

3. ENTITLEMENT mode for granting entitlement retrieval privileges

4. DBSAT new in 20.9 onwards

Execute as below scripts within the target database for setup

@oracle_user_setup.sql avdf setup (where avdf is the schema created inside the target DB)

Execute as below scripts within the target database for SPA

@oracle_user_setup.sql avdf spa (where avdf is the schema created inside the target DB)

Execute as below scripts within the target database for ENTITLEMENT

@oracle_user_setup.sql avdf ENTITLEMENT (where avdf is the schema created inside the target DB)

Step-6 Register Target DB on AVDF GUI console

login as avadmin Av console --> target tab --> Click register tab --> fill the below mention entries and save.

Apologies:- Snaps are blur due to security reasons.

Fill the details related to Target Database for register as below snap and Save

Database has been added to the AVDF, Check the status as below

Apologies:- Snaps are blur due to security reasons.

Next -> Configure the mail-id to get the Alert or Notification on mail

Configure the AVDF with below related articles: –

Caution: It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
A. Rawat
Email: 88arawat@gmail.com