How to change the timezone of Oracle SQL Developer / Oracle Data Modeler? -

How to change the timezone of Oracle SQL Developer / Oracle Data Modeler? -

each time run oracle sql developer or oracle info modeler receive error message:

ora-01882 "timezone part not found"

digging issue, found both oracle sql developer , oracle info modeler says timezone europe/berlin, not listed oracle's scheme view v$timezone_names.

so, need alter timezone in oracle sql developer (not database) match similar timezone found in v$timezone_names.

if need change time zone of oracle sql developer (or oracle info modeler), how it:

go installation directory of oracle sql developer. open file located at: sqldeveloper/bin/sqldeveloper.conf. at end of file, add together next line: addvmoption -duser.timezone=gmt-4.

you need alter value gmt-4 1 match 1 of timezones in v$timezone_names.

and that’s it!

oracle-sqldeveloper