I know I’ve seen this before, but I can’t find it now!
I have a colleague using Toad 9.5, with an Oracle 10.2.0.5 client to
connect to an Oracle 11.2.0.2 database.
When she connected, or attempts to, she gets an error popup that says
“OCI version 0.2083473045.2552.79945200.1306316 is not supported” but
the OCI version number in the error is total fiction.
I know she’s got 10.2.0.5 installed and on her path, and I’ve checked
http://toadfororacle.com/entry.jspa?externalID=4266&categoryID=391 to be
sure that Toad 9.5 can work with a 10g client (it can, it works with and
11.1 client too at that version). Plus I have used Toad 9.5 with the
same 10g install client to connect to databases with no problems.
I’m slightly puzzled here, it looks like Toad is getting some
information from the oci.dll (Guessing!) and trying to check the OCI
version and on finding this wrong OCI version is barfing.
However, I’ve no idea how Toad is getting this wrong version.
Any clues?
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Does she have the check box make this the default home checked? For that
connection did she specify a different home than the 10g? Open the toad oracle
home browser and look there for some extra insights …
Hi Bert,
Does she have the check box make this the default home checked? For that
connection did she specify a different home than the 10g? Open the toad
oracle home browser and look there for some extra insights …
Yes, I've had her open up the home browser and so on, everything is
valid. She has made it the default home, The other homes are flagged as
invalid.
This is the very first time she has used Toad, she is a tester testing a
system we have converted to run on 11g. We need the 10g client because
11g won't install on a Windows 2000 system. We wiil upgrade to Windows 7
"at some point soon".
It's also the very first time that Toad has been installed on her desktop.
--
Cheers,
Norm. [TeamT]
I have a Win 2000 VM with toad and oracle client setup exactly as she does and I cannot reproduce the problem (i.e. I can connect). So I suspect that something is amiss. But later today I will dig deeper into my VM and see if I can cause it to happen …
Hi Bert,
I have a Win 2000 VM with toad and oracle client setup exactly as she
does and I cannot reproduce the problem (i.e. I can connect). So I
suspect that something is amiss. But later today I will dig deeper into
my VM and see if I can cause it to happen ....
Thanks Bert. Appreciate it.
My problem is that she is remote and on a different network, so I'd like
to be able to remote control her box, but I can't. She's in an isolated
test environment, in a different data centre run bty a different company.
Life is hard sometimes!
There's no rush on this, she's logged the problem as a "defect" in our
transformation, so we'll get a list of things to fix at some point. We
can worry about it then.
--
Cheers,
Norm. [TeamT]
Does she have one of those Oracle Apps clients that installs an instant client, a “normal” client, and a bunch of other stuff? We’ve seen problems in the past with clients like this. I’m sorry I can’t remember the exact name for them. I think you can solve the problem by rearranging your system path (move the instant client folder after the ‘normal’ client, if I remember correctly)
Hi John,
Does she have one of those Oracle Apps clients that installs
an instant client, a "normal" client, and a bunch of other
stuff? We've seen problems in the past with clients like
this.
No. This was a standard Oracle 10g client, installed using the Agency
packaged up version of the Oracle Installer. I helped test out the
package by installing and using the same client on my desktop. It is all
legal and above board. Plus, there are no other clients installed by the
application.
The client is installed on the box first. The application is installed
separately and assumes the existence of a client.
Then Toad is installs and picks up what it can from the environment. My
desktop and hers are almost the same, except she is on the "right"
network to see the 11g database and all I have is the old 9i version.
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
I just now tested this as follows:
Windows 2000 (with all of the current updates as of today)
Install Oracle client 10.2.0.1 using “run time” 213 MB option
Install Oracle patch 10.2.0.5
Install Toad 9.5.0.31
Connect to remote Oracle 11gR2 database - no problems
Dumb question - did she install the 32-bit client. I know there is no 64-bit Win2K desktop - not sure about server, think no there too - but maybe she installed the wrong client and oracle installer did not detect 32 vs 64 bit on such an old and unsupported OS ???
Evening Bert,
I've been away all day today at a meeting, so apologies for the
tardiness of my reply.
Dumb question - did she install the 32-bit client. I know there is no
64-bit Win2K desktop - not sure about server, think no there too - but
maybe she installed the wrong client and oracle installer did not detect
32 vs 64 bit on such an old and unsupported OS ????
No, it's definitely 32 bit as I have exactly the same client installed.
I'll try and get onto her desktop, or have it brought over from wherever
she is and see if I can investigate it further. Remote diagnostics with
a non-technical person is no fun!
Thanks for your experiments too. Appreciate it.
--
Cheers,
Norm. [TeamT]
Always glad to assist a long time toad supporter like yourself 
Afternoon all,
On 13/01/11 22:08, Bert Scalzo wrote:
Always glad to assist a long time toad supporter like yourself
Thanks.
It's amazing how getting onto the box in question can make a whole world
of difference.
With the wonders of modern technology, a hole poked in a firewall or
two, a dedicated IP address and Remote Desktop, I was finally able to
get at the box in question.
The answer was simple, the PATH did not have the 10g client's bin folder
on it - contrary to what I had been told. I added it, and Toad worked
with no problems.
Now, this puzzles me a tad, but I'm not going to waste any time on it.
My 10g client's bin folder is also not on my PATH, but it works! Go figure!
In fact, of all the Oracle Clinets I have on my desktop, only one is on
the PATH (9.2.0.8) but Toad 9.6 and 10.5 can use any of them I choose.
Spooky.
Anyway, thanks to all who took the time to reply/investigate.
--
Cheers,
Norm. [TeamT]
Out of curiosity, does Toad report that your homes are invalid? What about your User PATH variable, are they listed there?
Michael
If it was an instant client then PC must have either bin in path or tns_admin
env var set. Was she using instant client (I think you already said no –
but are you sure). But since it now works – whew – time to move on J
A machine can have more than one PATH, I wonder if it was set at one level, and
not another?
Norm, I think the registry gives us the exact path to the oci.dll of each of
your clients, so that’s how we can work without it. I think. I’m
saying this without looking in our source. That doesn’t explain why it
works for them but not you. Maybe her registry pointed to a bad location. Just
guessing again.
Anyway, glad it’s fixed.
Hi Jeff,
A machine can have more than one PATH, I wonder if it was set at one
level, and not another?
Can it? In control panel I can set my login's additional PATH folders or
the ALL USERS PATH folders, but the two are combined.
I know I can have a new PATH when I start a CMD session, change the PATH
and run an application from within that CMD session, but I don't know if
that's what you mean?
--
Cheers,
Norm. [TeamT]
Hi John,
Norm, I think the registry gives us the exact path to the oci.dll of
each of your clients, so that’s how we can work without it. I think.
I’m saying this without looking in our source. That doesn’t explain
why it works for them but not you. Maybe her registry pointed to a bad
location. Just guessing again.
Good call John, I hadn't checked that. I just "remoted" into the box
again and checked - the oci.dll is valid and her registry points to a
valid location.
Not to worry, it's fixed now.
--
Cheers,
Norm. [TeamT]
