Using TNS with Oracle database collections
This article describes how to configure Funnelback to connect to distributed Oracle databases configured with TNS names.
Oracle databases have support for distributed databases using their proprietary TNS names configuration.
Funnelback can be configured to use the
tnsnames.ora file when crawling.
The following steps configure Funnelback to use a
Download the Oracle JDBC drivers (note you must use the Oracle JDBC driver v10.2.0.1.0 or newer)
Create a database collection as per normal
tnsnames.orafile to the collection’s configuration folder
Add the following to the
collection.cfgfor the database collection:
db.jdbc_urlto be the following format:
<TNSNAME>with the identifier from the
If using Funnelback 12.4 or earlier you also need to patch the