Link to home
Create AccountLog in
Avatar of Yvette
Yvette

asked on

Oracle error ORA-01882 timezone region not found

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
Avatar of Yvette
Yvette

ASKER

Sorry, spelling mistake in the previous post, should read:
in sqldeveloper.conf, I added AddVMOption -Duser.timezone="+02:00"
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Yvette

ASKER

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.