Hello,
my configuration is Splunk Version 5.0.3, Build 163460, Splunk DB Connect Version 1.0.11. I connect to a MySQL DB all works fine. I trying connect to an Oracle DB 11g. I setup the driver ojdbc6.jar in the folder //&SplunkHome/splunk/etc/apps/dbx/bin/lib. In the File &splunk_Home/splunk/etc/apps/dbx/local/databases.conf i setup database.sid = true, the Connection Manager tell no errors, if i'm select something, a error appear:
command="dbquery", Error getting database connection: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Where is my mistake?
The database.conf file:
database.sid = true
[INEK]
disabled = 0
database = INEK
host = 'full-host'
password = passowrd
port = 1521
readonly = 1
type = oracle
username = SPLUNK
[MySQL ] database = splunk
host = hostname
password = password
port = 3306
readonly = 1
type = mysql
username = splunk
... View more