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
sqldeveloper\ide\bin\ide.conf
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.1.0.19.07 to system4.1.0.18.07