ORA-00604
If you encounter ORA-00604 (ORA-00604: error occured at recursive SQL level 1) in SQLDeveloper while connecting to Oracle 11g database; here's what needs to be done:
Edit
SQL_DEV_INSTALL_DIR/sqldeveloper/bin/sqldeveloper.conf
, and add the following line: # Set timezone for IST AddVMOption -Duser.timezone="+05:30"
Another option (if you know the region code) is to provide the TZ code instead: AddVMOption -Duser.timezone=CET
Restart SQLDeveloper and the error should be gone!