Oracle Database

Logs Collected

The three types of logs collected are Alert, Listener, and Audit logs. Below is an example of the Alert and Audit logs.

1143

Oracle Database Audit Logs Example

1143

Oracle Database Alert Logs Example

Supported Versions

Oracle Database: 11.2.x - 18c+

Log Collection Setup

Follow these steps to set up log collection from Oracle Database.

Pre-requisites

Locate the local Oracle Database log locations.

Audit Log Location

You can find the Alert log location by running the following query while connected to the database.

select
   name 
from
   v$parameter
where
   name = 'audit_file_dest';

Alert Log location

You can find the Alert log location by running the following query while connected to the database.

select
   name 
from
   v$parameter
where
   name = 'background_dump_destination';

Listener Log Location

You can find the Alert log location by running the following command on the database host.

$ lsnrctl status

Configure a Oracle Source

  1. Install the BindPlane Log Agent on the host system.
  2. Login to BindPlane and select the Logs tab.
284

Logs Tab

  1. Select the Sources tab.
249

Sources Tab

  1. In the top-right portion of the screen, click on the Add Source Configuration button
576

Add Source Configuration Button

  1. Choose OracleDB
  2. Fill out the OracleDB log configuration options.
492

OracleDB Log Configuration Form

Choose the log types to collect from, and ensure the path is correct.