My Oracle Support Banner

ORA-604 and ORA-01882 With JDBC Connections to Database 11.2.0.3 (Doc ID 2291718.1)

Last updated on AUGUST 30, 2023

Applies to:

JDBC - Version 11.2.0.3.0 and later
Information in this document applies to any platform.

Symptoms

 
There are 2 databases: One is database version 11.2.0.3 and the other is database version 12.2.0.1 (an 11.2.0.3 database which has the JNDI data source to then connect to the application database which is 12.1.0.2).

After these changes, when trying to connect with JDBC 12.2 to the 11.2.0.3 JNDI database, the connection fails with the errors:

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

Connecting directly with JDBC 12.2.0.1 to the 12.2.0.1 application database succeeds.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.