Home » RDBMS Server » Server Administration » ORA-01882: timezone region %s not found (oracle 11.2.0.4.0 linux )
ORA-01882: timezone region %s not found [message #620081] Mon, 28 July 2014 11:37 Go to next message
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
Hi Team,

I am using Amazon RDS Oracle instance with above version. I am getting below error when i query dba_scheduler_jobs with timestamp related columns.
I am connecting through SQLPLUS ( CLIENT VERION: 10.2.0.4.0 )


SQL> select t.owner,job_name,job_Action,state,schedule_type,t.start_date from dba_scheduler_jobs t;
ERROR:
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
nls_sort                             string
nls_territory                        string      AMERICA
nls_time_format                      string
nls_time_tz_format                   string
nls_timestamp_format                 string
nls_timestamp_tz_format              string
SQL>


SQL> SELECT DISTINCT tzname FROM V$TIMEZONE_NAMES where tzname like 'Etc%';

TZNAME
----------------------------------------------------------------
Etc/GMT
Etc/GMT+3
Etc/GMT+7
Etc/GMT-11
Etc/GMT-3
Etc/GMT+10
Etc/GMT+9
Etc/GMT-2
Etc/GMT+8
Etc/GMT-10
Etc/GMT-5
Etc/Greenwich
Etc/UCT
Etc/Universal
Etc/GMT+0
Etc/GMT+5
Etc/GMT-8
Etc/GMT-9
Etc/UTC
Etc/GMT+2
Etc/GMT+4
Etc/GMT0
Etc/GMT-14
Etc/GMT+1
Etc/GMT-1
Etc/GMT-12
Etc/Zulu
Etc/GMT+11
Etc/GMT+12
Etc/GMT+6
Etc/GMT-0
Etc/GMT-13
Etc/GMT-4
Etc/GMT-6
Etc/GMT-7

35 rows selected.


SQL> SELECT FILENAME,VERSION from V$TIMEZONE_FILE;

FILENAME                VERSION
-------------------- ----------
timezlrg_20.dat              20



Could you please guide me how to suppress this ?

Thank you
Re: ORA-01882: timezone region %s not found [message #620082 is a reply to message #620081] Mon, 28 July 2014 11:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-01882: timezone region not found
 *Cause: The specified region name was not found.
 *Action: Contact Oracle Support Services.
Re: ORA-01882: timezone region %s not found [message #620083 is a reply to message #620082] Mon, 28 July 2014 11:54 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Could you please guide me how to suppress this ?
what does this mean?
Previous Topic: SYS,SYSDBA accounts locked
Next Topic: How to Partition existing Oracle 11g Table
Goto Forum:
  


Current Time: Thu Mar 28 07:18:56 CDT 2024