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.
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
- Install the BindPlane Log Agent on the host system.
- Login to BindPlane and select the Logs tab.
- Select the Sources tab.
- In the top-right portion of the screen, click on the Add Source Configuration button
- Choose OracleDB
- Fill out the OracleDB log configuration options.
Choose the log types to collect from, and ensure the path is correct.
Updated over 4 years ago