All Apps and Add-ons

Dbconnect issues with Oracle

robertlynch2020
Influencer

Hi

I am new to DB connect 3.3.1. I have it working for Sybase, but can't get it going for oracle.

I am trying to connect to Oracle DB 18c.

I have installed the drivers from oracle, but I am getting the following errors.

This is the configuration I was trying to use (below), however, I am getting an error in the logs saying 

"There was an error processing your request. It has been logged (ID cda8c0139c1f536e)." I have looked in the logs and I can see the following. not sure if related?

07-02-2020 11:20:40.681 +0200 WARN AuthorizationManager - Unknown role 'dbx_user'

[OCBC_PRTC]
connection_type = oracle
customizedJdbcUrl = jdbc:oracle:thin:@//dell1048srv@murex.com:1521/OCBC_PERFORMANCE_31_MX
database = OCBC_PERFORMANCE_31_MX
disabled = 0
host = DELL1048SRV
identity = OCBC_PERFORMANCE_31_MX
jdbcUseSSL = false
localTimezoneConversionEnabled = false
port = 1521
readonly = true
timezone = Europe/Paris  

Any help would be great thanks

2020-07-02 10_46_38-Configuration _ Splunk 8.0.3.png

Labels (1)
0 Karma
1 Solution

robertlynch2020
Influencer

So in the end it was something simple - we could not ping the DB server, however, I wish the message would have been better to help us to debug.

View solution in original post

0 Karma

robertlynch2020
Influencer

So in the end it was something simple - we could not ping the DB server, however, I wish the message would have been better to help us to debug.

0 Karma
Get Updates on the Splunk Community!

Index This | Why did the turkey cross the road?

November 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...