Database Administration (MOSC)

MOSC Banner

ora-01882 timezone region not found

edited Aug 14, 2014 5:01AM in Database Administration (MOSC) 1 commentAnswered

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
------------------------------------ ----------- ------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center