- 18 Jan, 2020
- 0 Comments
- 42 Secs Read
ORA-00604, ORA-01882 While Connecting With SQL Developer
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