oracle client 低于 oracle server 端，导致报错ORA-01882

May '14

Hi
I wANT to view records from DBA_SCHEDULER_JOBS but it shows me this error

select * from SYS.DBA_SCHEDULER_JOBS t
*
Error at line 1
ORA-01882: no se ha encontrado la región de la zona horaria %s

Be aware that it is the first time that we are select this table after the upgrade from oracle single db 10205 to oracle rac 11204 (standard ed)

But when I run this query on my SQL*Plus everything is right. I mean, All is ok.

How can I fix this on Toad ???

thank you

Bert_Scalzo · May '14

From Dell Support web site knowledge base:

Toad for Oracle Knowledge Article 25830

·
Title

ORA-01882 error when viewing Jobs in schema browser (SYS Schema)

·
Description

When accessing Oracle 10g database and logged on as SYS use, when trying to view Jobs in Schema Browser it will give an Ora-Error 01882 error.

·
Cause

Oracle Client Version : 9.0.4.0.1 which is unsupported by oracle with 10G

·
Resolution

To resolve this issue upgrade to a higher Oracle client.

·
Additional Information

Metalink 397766.1

From: chijar [mailto:bounce-chijar@toadworld.com]

Sent: Friday, May 09, 2014 10:35 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] ORA-01882 when I Want to view records con DBA_SCHEDULER_JOBS Toad 10.6

Thread created by chijar

Hi

I wANT to view records from DBA_SCHEDULER_JOBS but it shows me this error

select * from SYS.DBA_SCHEDULER_JOBS t

Error at line 1

ORA-01882: no se ha encontrado la región de la zona horaria %s

Be aware that it is the first time that we are select this table after the upgrade from oracle single db 10205 to oracle rac 11204 (standard ed)

But when I run this query on my SQL*Plus everything is right. I mean, All is ok.

How can I fix this on Toad ???

thank you

To reply, please reply-all to this email.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.