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

Last updated on JULY 28, 2017

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 11.2.0.3 and it is the database which has the JNDI data source to then connect to the application database which was version 11.2.0.3 and was upgraded to 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 upgraded 12.2.0.1 application database succeeds.

Changes

JDBC driver was upgraded to version 12.2.0.1.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms