topic Re: Can an Oracle database be used as a data source for Splunk DB Connect? in Getting Data In

Can an Oracle database be used as a data source for Splunk DB Connect?

vassi203 — Thu, 07 Aug 2014 16:27:16 GMT

Hello,

I have my log files stored on an Oracle Database. I would like Splunk to view those log files and use them as a data source.

I work at a lab information management systems software company, and we create the LIMS systems and they of course do a lot of logging to an oracle database using log4j.

Can splunk view those logs and use them as a data source? Thanks

Re: Can an Oracle database be used as a data source for Splunk DB Connect?

sroback_splunk — Thu, 07 Aug 2014 16:51:34 GMT

Hi. Yes, you can use the Splunk DB Connect app (installed on a Splunk Enterprise instance) to view, query, and input data from your Oracle database into Splunk for search and analysis.

For download and installation instructions:
http://docs.splunk.com/Documentation/DBX/1.1.4/DeployDBX/Installtheconnector

For db compatibility and requirements:
http://docs.splunk.com/Documentation/DBX/1.1.4/DeployDBX/Deploymentrequirements

Re: Can an Oracle database be used as a data source for Splunk DB Connect?

pmdba — Fri, 08 Aug 2014 03:49:46 GMT

Also take a look at this white paper: http://apps.splunk.com/app/1538. It's a basic step-by-step “how to” for Oracle DB monitoring using a variety of data inputs including various log files, the audit trail, trigger-based TCP inputs, shell scripts, and Splunk DB Connect. Common lookup tables, field extractions, reports, and dashboards are also described.