DB Connect Oracle timezone region not found

[steven7537]

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

[pmdba]

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.