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
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
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.
Best answer it was Scalzo thank you.
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:
any idea?
thank you
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”
Hi thank you for your answer. but I have bad news 
I have set up as per your recommendation:
then I try to enter to toad:
look the path valid and the oci.ddl also.
But it shows me THE SAME error.
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
Hi Damir,
I’m thinking is something related to my local WINDOWS variables.
but what variable should I change in my pc ??
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)
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
