Connections Fail With "ORA-01882: timezone region not found" After Upgrade From JDBC 11.1 To 11.2 Or Later (Doc ID 1068063.1)

Last updated on JULY 28, 2017

Applies to:

JDBC - Version 11.1.0.6 and later
Oracle WebLogic Server - Version 12.1.2.0.0 to 12.1.2.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

A standalone java application connects to a version 10.2.0.4 database via JDBC/Thin 11.2.0.1. The application runs on several machines. The machines have different Unix operating systems.

Consistently, when trying to connect to the database, the application running on one specific machine fails with:

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


An errorstack trace for ORA-01882 identifies the failing statement:

ksedmp: internal or fatal error
ORA-01882: timezone region not found
Current SQL statement for this session:
ALTER SESSION SET TIME_ZONE='Africa/Lome' NLS LANGUAGE = 'AMERICAN'
NLS TERRITORY='AMERICA'


The issue does not occur with JDBC/Thin 11.1.0.7.
The issue does not occur when the application runs on other machines.

Changes

Upgraded JDBC from 11.1.0.7 to 11.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