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!

Data Preparation Made Easy: SPL2 for Edge Processor

By now, you may have heard the exciting news that Edge Processor, the easy-to-use Splunk data preparation tool ...

Introducing Edge Processor: Next Gen Data Transformation

We get it - not only can it take a lot of time, money and resources to get data into Splunk, but it also takes ...

Tips & Tricks When Using Ingest Actions

Tune in to learn about:Large scale architecture when using Ingest ActionsRegEx performance considerations ...