Hello All, Running Splunk v7, Splunk Add-on for Oracle Database v3.7.0, InfoSec App for Splunk 1.5.3. I was able to get a Universal Forwarder installed on a staging DB server and we now have the Audit logs flowing in and they seem to be getting parsed appropriately; i.e. fields look like they're being extracted correctly, etc. The issue I seem to be running into is that we're not getting the individual users that are supposedly logging in, the database_user field shows up as just a slash, "/", or user is always SYSDBA. Can anyone who has this app setup and working well comment on how you got it setup to monitor authentications? We do want to track changes, as well, but we want to be able to watch login success and failure first.
... View more
Hello All, We have an Oracle test server sending plain text audit logs via syslog to Splunk, and though we have the InfoSec and Splunk Add-On for Oracle Database add-ons installed, the logs are not getting the appropriate CIM-compliant sourcetypes added to them so they're not showing up as expected in the authentications area of the IS dashboards and searches. We decided to go with plain text audit logs as we didn't need the inventory and performance events, so opted against using DB Connect. Using a forwarder is not out of the question, we just chose syslog since it meant not having to install anything on the Oracle server. I've been reading the documentation and it seems unclear whether the Splunk Add-On for Oracle Database add-on must be installed on indexers in addition to the search head in order for the sourcetypes, tags, etc to get added like I thought they would. The documentation says it's conditional: "Required if you are monitoring files locally on Oracle servers with universal forwarders." Since we're not using a forwarder, perhaps I just missed something in the configuration of the add-on? As far as I can tell all the apps and their pre-reqs are configured and enabled. Edited for additional info: Splunk 7, Splunk Add-on for Oracle v3.7.0, and it appears we have one search head and two indexers.
... View more