ORA-01882: timezone region %s not found [message #620081] |
Mon, 28 July 2014 11:37 |
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
|
|
|
|
|