Sometime when you try to connect to oracle database using sql developer tool, you will see the below error message
Problem Statement
An error was encountered performing the requested operations: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found OO604. 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
Solution
- First we need to check the timezone of the database
SELECT * FROM V$TIMEZONE_NAMES WHERE TZNAME LIKE 'America%';
2. Edit the sqldeveloper.conf file sqldevelopersqldeveloperbinsqldeveloper.conf and add the following line
AddVMOption -Duser.timezone=America/Santiago
Save the configuration file and restart the sql developer.
#ORA-00604 #ORA-01882
