NXLog User Guide

109.22. Oracle OCI (im_oci)

This module can read input from an Oracle database.

Warning

This module is deprecated, please use the im_odbc module instead.

109.22.1. Configuration

The im_oci module accepts the following directives in addition to the common module directives. The DBname, Password, and UserName directives are required.

DBname: Name of the database to read the logs from.

Password: Password for authenticating to the database server.

UserName: Username for authenticating to the database server.

ORACLE_HOME: This optional directive specifies the directory of the Oracle installation.

SavePos: This boolean directive specifies that the last row ID should be saved when NXLog exits. The row ID will be read from the cache file upon startup. The default is TRUE: the row ID is saved if this directive is not specified. Even if SavePos is enabled, it can be explicitly turned off with the global NoCache directive.

109.22.2. Examples

Example 560. Reading Logs from an Oracle Database

This configuration will read logs from the specified database and write them to file.

nxlog.conf


  1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

  <Input oci>
    Module          im_oci
    dbname          //192.168.1.1:1521/orcl
    username        user
    password        secret
    #oracle_home    /home/oracle/instantclient_11_2
</Input>

<Output file>
    Module          om_file
    File            tmp/output
</Output>

<Route oci_to_file>
    Path            oci => file
</Route>