Loading

Oracle module

Prefer to use Elastic Agent for this use case?

Refer to the Elastic Integrations documentation.

This is a module for ingesting Audit Trail logs from Oracle Databases.

The module expects an *.aud audit file that is generated from Oracle Databases by default. If this has been disabled then please see the Oracle Database Audit Trail Documentation.

Tip

Read the quick start to learn how to configure and run modules.

This module has been tested with Oracle Database 19c, and should work for 18c as well though it has not been tested.

You can further refine the behavior of the oracle module by specifying variable settings in the modules.d/oracle.yml file, or overriding settings at the command line.

You must enable at least one fileset in the module. Filesets are disabled by default.

Each fileset has separate variable settings for configuring the behavior of the module. If you don’t specify variable settings, the oracle module uses the defaults.

For advanced use cases, you can also override input settings. See Override input settings.

Tip

When you specify a setting at the command line, remember to prefix the setting with the module name, for example, oracle.database_audit.var.paths instead of database_audit.var.paths.

Example config:

- module: oracle
  database_audit:
    var.input: file
    var.paths: /home/user/oracleauditlogs/*/*.aud
var.paths
An array of glob-based paths that specify where to look for the log files. All patterns supported by Go Glob are also supported here. For example, you can use wildcards to fetch all files from a predefined level of subdirectories: /path/to/log/*/*.log. This fetches all .log files from the subfolders of /path/to/log. It does not fetch log files from the /path/to/log folder itself. If this setting is left empty, Filebeat will choose log paths based on your operating system.
var.tags
A list of tags to include in events. Including forwarded indicates that the events did not originate on this host and causes host.name to not be added to events. Defaults to [oracle-database-audit].

Oracle Database fields are mapped to the current ECS Fields:

Oracle Fields ECS Fields
privilege host.user.roles
client_user client.user.name
userhost client.ip/domain
database_user server.user.name

For a description of each field in the module, see the exported fields section.