ORA-01882: timezone region %s not found
Recently we got this error while running via TOAD
select * from dba_scheduler_jobs;
The error message itself turns out not very informative.
01882, 00000, "timezone region %s not found"
// *Cause: The specified region name was not found.
// *Action: Please contact Oracle Customer Support.
In short, the error is because there are 7 timezone region IDs changed from version 3 and above. If you have old Timezone data from Version 2 that using one of these IDs the error raises.
In our case, server had time zone files were already upgraded so running same query on the DB server was working fine. So to fix it we had fix it on the client side,
1) Download patch 5731535 for a 10.2.0.X client ( 10.2.0.1 to 10.2.0.3)
2) Copy the 2 .dat files located at Client_patch\5731535\files\oracore\zoneinfo and the readme.txt file into the %ORACLE_HOME%\oracore\zoneinfo directory on your oracle client.
3) restart the TOAD
Ref : Metalink Doc ID: 414590.1 and 417893.1
Subscribe to:
Post Comments (Atom)
Posts
2 comments:
Hi,
when i execute the query
select * from User_Scheduler_Jobs
i also get the error
ORA-01882: timezone region %s not found
can any one help me.
my oracle client version 10.1.0.2.0
Try this:
BEGIN
DBMS_SCHEDULER.set_scheduler_attribute (
attribute => 'default_timezone',
value => 'US/Eastern');
END;
Post a Comment