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.

Oracle Database Audit Logs ExampleOracle Database Audit Logs Example

Oracle Database Audit Logs Example

Oracle Database Alert Logs ExampleOracle Database Alert Logs Example

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.
Logs TabLogs Tab

Logs Tab

  1. Select the Sources tab.
Sources TabSources Tab

Sources Tab

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

Add Source Configuration Button

  1. Choose OracleDB
  2. Fill out the OracleDB log configuration options.
OracleDB Log Configuration FormOracleDB Log Configuration Form

OracleDB Log Configuration Form

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