Splunk Search

DB Connect Oracle timezone region not found


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!


0 Karma


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!

Admin Your Splunk Cloud, Your Way

Join us to maximize different techniques to best tune Splunk Cloud. In this Tech Enablement, you will get ...

Cloud Platform | Discontinuing support for TLS version 1.0 and 1.1

Overview Transport Layer Security (TLS) is a security communications protocol that lets two computers, ...

New Customer Testimonials

Enterprises of all sizes and across different industries are accelerating cloud adoption by migrating ...