ORA-01882: timezone region %s not found ERROR in Toad/sqlplus

If you are facing the following issue on your workstation, then you need to update your client timezone files.

clip_image002

I found the issue on IHORIZD connecting via Toad and running ‘Select * from dba_scheduler_jobs’.

The following metalink article resolves this issue – 417893.1 (How To Apply The V4 DST Patches To Windows Clients or Servers )

Background information on the error given in this article ID 414590.1 (Time Zone IDs for 7 Time Zones Changed in Time Zone Files Version 3 and Higher, Possible ORA-1882 After Upgrade)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: