Monday, January 28, 2013

ORA-01882 - SQL Developer

Oracle SQL Developer Version 3.2.20.09
Windows 7 (x64)

When trying to configure a database connection following error appears:

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

According to metalink note 1477929.1 it is a SQL Developer configuration issue. The SQL Developer cannot recognize the correct timezone.
The workaround is to add the following line into %SQLDEVELOPER%/sqldeveloper/bin/sqldeveloper.conf file (make a backup of this file first).

AddVMOption -Duser.timezone="+02:00"

Save the file and then restart SQL Developer.

1 comment: