Configure Splunk DB Connect v3.8.0 inputs for the Splunk Add-on for Oracle Database

To gather inventory and performance data from your Oracle Database Server, the Splunk Add-on for Oracle Database leverages Splunk DB Connect. This topic presents the instructions for DB Connect version 3.8.0.

Set up the database connection

1. Download the JDBC driver for Oracle database from https://www.oracle.com/database/technologies/jdbc-upc-downloads.html.

2. Place the driver file called ojdbc*.jar in $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/ on the part of your Splunk Enterprise architecture performing the data collection.

3. Still on the part of your Splunk Enterprise architecture performing data collection, go to Splunk DB Connect in Splunk Web.

4. Create an identity for establishing a connection to a database. Make sure the DB user for this identity has access to Oracle auditing data.

Use the Splunk DB Connect GUI to create a database connection

To create a database connection to the Oracle Database Server using the Splunk DB Connect GUI:

Refer to the "Create and manage database connections" in the Splunk DB Connect manual for step-by-step instructions for using the GUI to set up a new database connection.

Configure the inputs using the Splunk DB Connect GUI

If you want to create Oracle database input, choose the template created for Splunk Add-on for Oracle Database under Template field of DB Connect.