Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ora-01882 "timezone region not found" with 3.0.03.97 but not with 3.0.03.45

CharonMar 24 2011 — edited Apr 8 2011
I installed the version 3.0.03.97 of SQL-Developer and now get an ora-01882 when I connect to a DB. I don't get this Problem when using version 3.0.03.45.

Putting "AddVMOption -Duser.region=DE" in the sqldeveloper.conf didn't solve this problem though.

The problem happens both with the connection-type "simple" and "TNS".

I am on 32bit Windows 7 Professional.
Java JDK is jdk1.6.0_23.
Oracle Instantclient is 11.1.0.1.0
Database is version 9.2.0.1.0

Anyone got this problem too? What changed between both versions of the SQL-Developer?

Regards
Markus

Edited by: Charon on Mar 24, 2011 11:52 AM

Comments

Jim Smith Mar 24 2011
Have you changed JDK?

Look in Help | About | Properties. Is there a difference in "user.timezone?"
Charon Mar 24 2011
Just 5min ago I tried with the newest JDK 1.6.0_24 and still have the same problem.

In both versions of SQL-Developer the "Help | About | Properties" shows the same user.timezone "Europe/Berlin".

Anything else I could check?

Thanks
Markus
Charon Mar 24 2011
I found something but need confirmation:
SQL-Developer says my timezone is "Europe/Berlin".

If I run this:
SELECT *
FROM   V$TIMEZONE_NAMES
WHERE  tzname LIKE 'Europe/%'
I get no hits with "Berlin" in it but quite a few others.

One of them is "Europe/Istanbul".

If I now add "AddVMOption -Duser.timezone=Europe/Istanbul" to my sqldeveloper.conf I can finally connect to my Database!

So does version 3.0.03.97 of SQL-Developer somehow check this view for available timezones? Did the previous version not check this? Whats the solution for me then? (using the Istanbul timezone here doesn't seem right to me)

Regards
Markus
willirob Mar 30 2011
I have the same problem connecting to 10g db with sqldev 3.0.04.34.

Connect fine to 11g db.
willirob Mar 30 2011
fixed on mine by adding my timezone to sqldeveloper.conf

AddVMOption -Duser.timezone="+02:00"
Charon Mar 31 2011
I still have the problem with 3.0.04.34 but could solve it with this:
AddVMOption -Duser.timezone=CET

Since I am not really sure what the consequences of this are I think it's not right.
I live in germany, and just two days ago summer time began. So half of a year this setting is not right for me and I would have to change it every half year!
Aleksander Stopar Apr 1 2011
With CET you should be OK, CET is shifted +/- 1 hour in regard to summer/winter time

check out http://wwp.centraleuropeantime.eu/



bye
Charon Apr 1 2011
Thanks for the info! Nice to know that this should work right for me then.

I still don't understand why I have to create this setting at all though.

Regards
Markus
787935 Apr 8 2011
Hi,

I had a similar problem, and it was solved by adding that line:-
AddVMOption -Duser.timezone="+02:00"

Bye
452831 Apr 8 2011
The alternative on Linux would be set TZ variable to CET. In my case it is CEST (summer time) and it does not work:

export TZ=CET
sqldeveloper


I suspect it shall be a list of timezones in sqldeveloper to match against to, so it may be an easy fix. Would anyone report a bug?
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2011
Added on Mar 24 2011
10 comments
18,129 views