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!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

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

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...