Splunk IT Service Intelligence

splunk db connect ORA-01882: timezone region not found

arun_kant_sharm
Path Finder

Hi Experts

I am getting below error :
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
alt text
Its working fine for oracle 12c servers but show below error while execute on 11g servers.

Labels (1)
0 Karma

PavelP
Motivator

here is a similar question and two possible solutions (set timezone or switch to ojdbc6.jar): https://answers.splunk.com/answers/507910/splunk-db-connect-why-am-i-receive-an-oracle-conne.html

0 Karma

arun_kant_sharm
Path Finder

Thanks PavelP,

But please suggest how I connect oracle-12c and oracle-11g both to our Splunk DB connect app.
At now my DB connect app properly working with 12c but I want to monitor 11g also, both version use different drivers version.

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...