Toad World® Forums

ORA-01882 when I Want to view records con DBA_SCHEDULER_JOBS Toad 10.6


#1

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


#2

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

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.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

Best answer it was Scalzo thank you.


#4

Hi, thank for your answer, but although I have oracle cliente 9i, I’m logging with oracle client 10.2 into Oracle RAC database 11.2.0.4. take a look of this:

toad connect.png

any idea?

thank you


#5

this is Oracle but what is your path value when you run Toad?

Try to place in cmd next three statements, which will overwrite possible problems that you suffer:

set ORACLE_HOME=c:\oracle\product\10.2.0\client_1

set PATH=c:\oracle\product\10.2.0\client_1\bin;%PATH%

“c:\Program Files\Quest Software\Toad for Oracle 10.6\Toad.exe”


#6

Hi thank you for your answer. but I have bad news :frowning:

I have set up as per your recommendation:

seteo DOS.png

then I try to enter to toad:

config del ora home y path.png

look the path valid and the oci.ddl also.

But it shows me THE SAME error. :frowning:


#7

Ok.

Now please reproduce the same two lanes but skip Toad.exe and instead that place:
sqlplus.exe user/pwd@db
with the same user you are using in Toad.

And then try the same command, which gives you an error in Toad.

Please let me see the whole output from sqlplus login to end of sql statements (mask sensitive data if you mind)

Brg,
Damir


#8

Hi Damir,

I’m thinking is something related to my local WINDOWS variables.connection sql.png

but what variable should I change in my pc ??


#9

I don’t think this is about variables on your PC. I think a newer Oracle client will fix this. If your Oracle database is version 11.2, your client really should be the same (or higher)


#10

Hi!

Now we have a proven fact that error is not coming from Toad but from Oracle installation (configuration).

AFAICS, you are attacking 10.2.0.5 x64 database through 10.2.0.1 x32 client. Such a combination should run 100% and it is certified as well.
We’ll it is not easy to find the root of problem, but maybe re installation of your Oracle Client in same directory.

If you doubt in your local environments, then from same cmd, please give us a list of “set” command.

Brg
Damir