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 = oraclecustomizedJdbcUrl = jdbc:oracle:thin:@//firstname.lastname@example.org:1521/OCBC_PERFORMANCE_31_MXdatabase = OCBC_PERFORMANCE_31_MXdisabled = 0host = DELL1048SRVidentity = OCBC_PERFORMANCE_31_MXjdbcUseSSL = falselocalTimezoneConversionEnabled = falseport = 1521readonly = truetimezone = Europe/Paris
Any help would be great thanks
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