ora-01882 timezone region not found
I am getting this error while I running the following query on oracle 11g in Red hat linux box.
select * from dba_scheduler_jobs;
The error message itself turns out not very informative.
ORA : 01882, "timezone region %s not found"
SQL> show parameter nls
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string
nls_comp string BINARY
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------