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!

Using Machine Learning for Hunting Security Threats

REGISTER NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more ...

Security Highlights | November 2022 Newsletter

 November 2022 2022 Gartner Magic Quadrant for SIEM: Splunk Named a Leader for the 9th Year in a RowSplunk is ...

Platform Highlights | November 2022 Newsletter

 November 2022 Skill Up on Splunk with our New Builder Tech Talk SeriesCan you build it? Yes you can! *play ...