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

  1. 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

Leave a Reply