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

oracle-sqldeveloper

Each time I run Oracle SQL Developer or Oracle Data Modeler I receive this error message:

ora-01882 "timezone region not found"

Digging a this issue, I found that both Oracle SQL Developer and Oracle Data Modeler says that my timezone is Europe/Berlin, which is not listed into the Oracle's system view V$TIMEZONE_NAMES.

So, I need to change the timezone in Oracle SQL Developer (not the database) to match the most similar timezone found in V$TIMEZONE_NAMES.

Best Answer

If you need to change the time zone of Oracle SQL Developer (or Oracle Data Modeler), then this is how to do it:

  1. Go to the installation directory of Oracle SQL Developer.
  2. Open the file located at: sqldeveloper/bin/sqldeveloper.conf.
  3. At the end of file, add the following line: AddVMOption -Duser.timezone=GMT-4.

You will need to change the value GMT-4 to one that match one of the timezones in V$TIMEZONE_NAMES.

And that’s it!

Related Topic