All Apps and Add-ons

Splunk DB Connect: Why am I receive an Oracle connection error "error occurred at recursive SQL level 1 ORA-01882: timezone region not found"?

nuaraujo
Path Finder

Hello all,

I am using Splunk DB connect v3.0.1, and I am trying to connect to an Oracle database.

I am using jdk1.8.0_121, as required, and in my JVM options(server.vmopts) I have

-Duser.timezone="UTC" -Ddw.server.applicationConnectors[0].port=9998

When I go to Data Lab -> SQL Explorer, I am able to choose the Oracle connection, I can choose the Schema, and I can see the list of tables. However, when i click in one of the table names( select * from SCHEMA.TABLE_NAME) I always get the following error:

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

Can someone help me to solve this issue?

Thanks in advance.

0 Karma
1 Solution

jcoates_splunk
Splunk Employee
Splunk Employee
0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee
0 Karma

nuaraujo
Path Finder

Thanks jcoates.

You post redirected me to the real problem. My DB version is 11.2.0.3.0 , and I was using ojdbc7.jar. I changed the driver to ojdbc6.jar, and it worked without issues.

Thank you for your help.

Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...