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!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...