My Oracle Support Banner

When Connecting With Sqldeveloper ORA-01882 Is Seen And Unable To Connect (Doc ID 1320425.1)

Last updated on NOVEMBER 01, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

When
Or using an Oracle 11.2.0.2 or 11.2.0.1 client and using the provided Sqldveloper tool
Or using  sqldeveloper Version 3 from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
you receive ORA-01882: timezone region not found when connecting to a database.
This is most seen when connecting to older database releases but is also possible with up to 11.2 databases
It may work with some and fail with others.

Solution

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