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.
If you need to change the time zone of Oracle SQL Developer (or Oracle Data Modeler), then this is how to do it:
sqldeveloper/bin/sqldeveloper.conf.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!
sqldeveloper.conf in the following location: /Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.confTry:
This worked for me
AddVMOption -Duser.timezone=GMT+5
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
This worked for me
AddVMOption -Duser.timezone=GMT+7
Tq
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
