ORA-01882: timezone region %s not found
tfaJul 9 2010 — edited Jul 13 2010When executeing the following query using sqldeveloper Version 2.1.0.63 the query never completes.
select * from dba_scheduler_jobs;
I see the following message above the query result window. "Execting:select * from dba_scheduler_jobs in .219 seconds".
The query does not complete and there is no error written to the log.
Running the query in sql plus resulted in the following error.
SQL> select * from dba_scheduler_jobs;
ERROR:
ORA-01882: timezone region %s not found
After seeing this error in sqlplus our DBA executed actions listed on metalink note 414590.1. This has now corrected the issue in sqlplus but the original issue in sqldeveloper still exists even after the change to the database.
What is causing the ORA-01882 error and how can I correct it?