Oracle Database
Configure Oracle Database Log Source with observIQ


Supported Versions
Oracle Database Enterprise Edition and Standard Edition versions 11.2.0.3 and greater
Configuration
Option | Description |
---|---|
Audit Logs | Use this field to verify the path to the Audit log file and adjust default as needed (/u01/app/oracle/product//dbhome_1/admin//adump/*.aud). |
Truncate Audit Action | Toggle check box to choose whether or not to truncate the audit log field action. |
Alert Logs | Use this field to verify the path to the Alert log file and adjust default as needed (/u01/app/oracle/product//dbhome_1/diag/rdbms///trace/alert_.log). |
Listener Logs | Use this field to verify the path to the Listener log file and adjust default as needed (/u01/app/oracle/product//dbhome_1/diag/rdbms//*/alert/log.xml). |
Start At | Choose whether to start reading from the beginning or end of a file with "end" being the default. |
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
Log Types
Types |
---|
oracledb.audit |
oracledb.alert |
oracledb.listener |
Dashboards
Users can configure dashboards using visualizations. More information can be found on our visualizations and dashboards page.
Advanced
For more information on the advanced configuration capabilities, see our detailed plugin guide here.
Updated 9 months ago