Not sure what you mean by "path to the database". DB Connect uses JDBC; JDBC will require a hostname (localhost in your case), a port number (generally 1521), and a service name or Oracle SID to identify the actual database. All of that information can be obtained from the Oracle lsnrctl command: "lsnrctl status" run as the oracle user on the *NIX database host (or as a Windows administrator on a Windows server). For a complete step-by-step guide to configuring Splunk and DB Connect for Oracle, check out this add-on: Real-Time Oracle 11g Log File Analysis
You may also need to verify that any local host firewall is configured to allow connections to the Oracle Listener.
... View more