Upgrade the Splunk Add-on for Oracle Database

Use the Install the Splunk Add-on for Oracle Database topic in this manual to install a new version of this add-on. Two new sourcetypes were added oracle:sqlMonitor and oracle:connections:poolStats that may need to be reflected as an Oracle database input in DB Connect.

oracle:sqlMonitor can be used for Oracle versions 19c and above

Upgrade from version 3.5.0 or later to 4.0.2 or later

When upgrading from version 3.5.0 or later to 4.0.2 or later, no change is required for file monitoring inputs. Version 4.0.2 of the Splunk Add-on for Oracle Database included multiple updates to sourcetypes, based on database entries. Update all Oracle database input in DB Connect to reflect the modifications:

1. In a Splunk instance with Splunk DB Connect installed, open Splunk DB Connect.
2. Navigate to the Inputs tab.
3. Select an input that uses an updated template. Use the Template column to filter your inputs by template.
4. In the Actions column, click Edit. The Edit input window appears.
5. In the Edit input window, click the Refresh icon on the right side.
6. Once the query is reloaded, click the Execute SQL button to execute the updated query.

   In some cases, none of the row is returned. This happens when dealing with sourcetype with a rising mode like oracle:audit:unified

7. Click Next.
8. Save your changes.