topic Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"? in Security

Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

muralianup — Tue, 15 Dec 2015 15:02:10 GMT

After going through some of the posts here, I am still facing the same issue. Basically trying to connect to an Oracle DB. Got past the error when I unchecked the "Validate Connection", but when I try to get the table information from the DB Connect, I am getting the error:

command="dbinfo", Error getting database connection: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

The host & DB has timezone set to Japan. I've tried adding combinations like TZ=JST & TZ=Asia/Tokyo to the /dbx/local/props.conf & /dbx/local/props.conf as follows:

[host::serverjap]
TZ = JST

Restarted Splunk, no luck, then changed the TZ to TZ=Asia/Tokyo, restarted Splunk again.

Any suggestions ?

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

ppablo — Tue, 15 Dec 2015 18:09:24 GMT

Hi @muralianup

Just gathering more information for users in the community to help you, but are you using DB Connect 1 or DB Connect 2? You didn't specify in your post.

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

muralianup — Wed, 16 Dec 2015 09:38:49 GMT

Sorry, forgot. I am using DB Connect 1. Because of the error, I created the inputs.conf entry manually, updated props.conf (in /dbx/local, /dbx/default, /search/props.conf with the TZ vaule as mentioned in my previous post. Restarted Splunk each time. But still cannot connect to the DB due to TimeZone error.

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

jkat54 — Wed, 16 Dec 2015 11:15:13 GMT

Have you tried googling the oracle error without including splunk in your results?

http://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found

http://www.smartmarmot.com/workaround-to-the-issue-ora-01882-timezone-region-not-found-when-connection-to-oracle/

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

muralianup — Wed, 16 Dec 2015 11:22:52 GMT

Yes I did. The thing is, I already have a dozen of other DBs connected to Splunk (MSSql & Oracle) which didn't have any problem like this. I do not want to make any changes in the jdbc settings or something within Splunk. I read adding TZ variable in props.conf should sort the issue but seems like It's not. I am running version 6.0 by the way.

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

gsoros — Fri, 18 Dec 2015 15:21:29 GMT

I'm having the exact same problem but using DB Connect 2 and Spunk v6.2.2

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

gsoros — Fri, 18 Dec 2015 15:47:47 GMT

From the stackoverflow answer, adding "-Duser.timezone=GMT" to the JVM Options under Settings in the App fixed the problem.

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

muralianup — Fri, 18 Dec 2015 16:00:23 GMT

It does. But when I go to the DBConnect & select the DB to see the table content, its waiting forever to complete; not returning any DB table contents..yet.. Even if I specify a table name that exists in that DB.
But any idea if the timestamp will be in the GMT afterwards ?

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

jkat54 — Fri, 18 Dec 2015 16:31:49 GMT

Oracle will change all the timestamps to GMT.

Can you mark this answer as correct to help others quickly find solutions?

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

jkat54 — Fri, 18 Dec 2015 16:33:22 GMT

Thanks for the up vote gsoros. Glad I could help, sorry to make you read but you found exactly what I was hoping you would find. Pat yourself on the back!

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

muralianup — Fri, 18 Dec 2015 16:41:15 GMT

Timestamp conversion to GMT will be an issue for us. But yes, it does get rid of the timezone error, but as I said its not returning any tables from the DB Connect's DB Info Option.

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

jkat54 — Fri, 18 Dec 2015 21:53:55 GMT

Would you prefer "-Duser.timezone=EST"?

You dont have to use GMT, you can export from ORA in any timezone.

Anyways, you have a new question now and we've resolved the original error message you were receiving.

Re: Splunk DB Connect 1: Why am I getting Oracle DB connection Error "ORA-01882: timezone region not found"?

jkat54 — Fri, 08 Sep 2017 20:31:49 GMT

@muralianuo did this answer your question? If so can you mark it as the answer please?