We help IT Professionals succeed at work.

Oracle error ORA-01882 timezone region not found

Yvette
Yvette asked
on
I installed SQLDeveloper 3 on Windows 7 and trying to connect to the database 10g R2 I get the following error: Ora-01882 timezone region not found. I can access the database from sqlplus, no problem.
I did the following:
in sqldeveloper.conf, I added AddVMOption -Duser,timezone="+02:00"
upgraded Java to Java 6 Update 31
set environment variable TZ to OEZ-02
set environment variable JAVA_OPTS to -Duser.timezone="+02:00"
Nothing helps.
Can you please assist?
Thank you
Comment
Watch Question

Author

Commented:
Sorry, spelling mistake in the previous post, should read:
in sqldeveloper.conf, I added AddVMOption -Duser.timezone="+02:00"
Senior Oracle DBA
CERTIFIED EXPERT
Commented:
Check out this post:

https://forums.oracle.com/forums/thread.jspa?threadID=2196497

In there it details how to get the names of the time zones.  It appears that using the names rather than the offsets works better.

Author

Commented:
Thanks. You sent me in the right direction. Most importantly, it depends on WHERE you put the AddVMOption -Duser.timezone parameter in sqldeveloper.conf. Add it to the end and it will not work.