CODEWITHSUNDEEP
oracle-sqldeveloper
Rubens Mariuzzo
Rubens Mariuzzo

Reputation: 29241

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.

Upvotes: 27

Views: 66609

Answers (6)

Ruvini
Ruvini

Reputation: 27

For the country Sri Lanka (GMT +5:30), add the following line to the sqldeveloper.conf file located at the bin folder of the sqldeveloper installation path.

AddVMOption -Duser.timezone=GMT+5.30

Upvotes: -1

muqofa
muqofa

Reputation: 1

This worked for me

AddVMOption -Duser.timezone=GMT+7

Tq

Upvotes: -1

Indrajeet Singh
Indrajeet Singh

Reputation: 2989

Try:

  • Oracle Sql Developer 4.1.3
  • Open config file.
  • sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
  • Add end of the file.
  • AddVMOption -Duser.timezone=GMT
  • Restart your Oracle Sql Developer.

Upvotes: 10

Aasim Chaudhary
Aasim Chaudhary

Reputation: 91

This worked for me

AddVMOption -Duser.timezone=GMT+5

Upvotes: 9

Martin de Haij
Martin de Haij

Reputation: 1

For me this worked:

1)

When in Windows 8, make sure you have authorization/rights over the sqldeveloper folder (for me this is C:\Program Files\sqldeveloper, do a right-mouse click here and choose "Properties..." and then "Security" tab and on that tab press the "Edit" button and give yourself all the rights. [I have to guess these names in English because my Windows is not English)]

2) then follow the steps from Rubens Mariuzzo above, except the last one

3) AddVMOption -Duser.timezone=GMT+1

SELECT * FROM v$timezone_names gave me both Europe/Amsterdam and Europe/Berlin as options (both are GMT+1 but my location is Europe/Amsterdam). However using either of these names stil gave the ora-01882 "timezone region not found", only after changing to "timezone=GMT+1" did the bug disappear

Upvotes: 0

Rubens Mariuzzo
Rubens Mariuzzo

Reputation: 29241

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!

Upvotes: 51

Related Questions