SOLVED

ORA-00604, ORA-01882 While Connecting With SQL Developer

Asked by OracleDba••18 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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
OracleDba•

Post Your Solution