Splunk ITSI

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!

CX Day is Coming!

Customer Experience (CX) Day is on October 7th!! We're so excited to bring back another day full of wonderful ...

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...