Fixing Timezone Issue on Oracle SQL Developer

If you login with SQL Developer and you get the following:

An error was encountered performing the requested operation:

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.
Vendor code 604

Do the Following:
edit file
and add
AddVMOption -Duser.timezone=”+02:00″
at the bottom of the file
OR AddVMOption -Duser.timezone=”GMT+2″

(Just change it according to your time zone…..)

Start SQL developer and To fix date time format go to :
Tools -> Preferences -> database -> nls and change date format to YYYY/MM/DD HH24:MI:SS (Or any of your desired time formats)

And to fix startup errors go to
{USER HOME}\AppData\Roaming\SQL Developer
and rename system4. to system4.

Leave a Reply

Your email address will not be published.

Reload Image