oracle-sqldeveloper

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

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.

Solution

  • 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!