My Oracle Support Banner

ORA-00604 : Error Occurred At Recursive SQL level 1 ORA-01882: Timezone Region Not Found (Doc ID 1477929.1)

Last updated on SEPTEMBER 04, 2023

Applies to:

Oracle SQL Developer - Version 3.1 and later
Microsoft Windows x64 (64-bit) - OS Version: 7
Apple Mac OS X (Intel) (64-bit)


Latest version of SQL Developer 64-bit was downloaded (3.1) for Windows 7 (64-bit) OR MacOS and the old settings were migrated when installing and was prompted for. However, upon successful migration when trying to expand a Database Connection and browse, the following error is thrown:

An error was encountered performing the requested operation:++

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
00604. 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



No Changes. Settings were migrated.


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

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