<div>
Sorry, spelling mistake in the previous post, should read:<br />
in sqldeveloper.conf, I added AddVMOption -Duser.timezone=&quot;+02:00&quot;
</div>


Sorry, spelling mistake in the previous post, should read:
in sqldeveloper.conf, I added AddVMOption -Duser.timezone="+02:00"

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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.<br />
I did the following:<br />
in sqldeveloper.conf, I added AddVMOption -Duser,timezone=&quot;+02:00&quot;<br />
upgraded Java to Java 6 Update 31<br />
set environment variable TZ to OEZ-02<br />
set environment variable JAVA_OPTS to -Duser.timezone=&quot;+02:00&quot;<br />
Nothing helps.<br />
Can you please assist?<br />
Thank you
</div>
</div>


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

Oracle error ORA-01882 timezone region not found

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.