Splunk Search

DB Connect Oracle timezone region not found

steven7537
Explorer

Hi everyone,

When I try and connect to my oracle database with Splunk DB Connect I get the following error:

error getting database connection: ORA-00604 error occurred at recursive level 1 ORA-01882 timezone region not found

I don't get this error when connecting over command line or through SQL developer...if I did I would add -Duser.timezone="blah" or edit the defaultconnecterproperties.properties to ignore timezones.

any suggestions would be much appreciated!

Thanks,
steven7537

0 Karma

pmdba
Builder

The ORA-01882 is due to a change of functionality in JDBC 11.2 in conjunction with a default timezone name/region on the client that is not supported by the database. The change of functionality is to use timezone name/region directly if it is a known Oracle one rather than convert to a GMT offset.

The solution is to use a timezone supported by the database. This can be done by setting the TZ environment variable. When TZ is set, its value will be used rather than the operating system default timezone.

0 Karma
Get Updates on the Splunk Community!

Index This | What did the zero say to the eight?

June 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

Splunk Observability Cloud's AI Assistant in Action Series: Onboarding New Hires & ...

This is the fifth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Now Playing: Splunk Education Summer Learning Premieres

It’s premiere season, and Splunk Education is rolling out new releases you won’t want to miss. Whether you’re ...