# OCI version is not supported.

**URL:** <https://forums.toadworld.com/t/oci-version-is-not-supported/10146>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 12, 2011, 9:24am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146 "2011-01-12T09:24:06Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 9:24am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/1 "2011-01-12T09:24:06Z")

</div>

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](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](http://www.environment-agency.gov.uk)

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 12, 2011, 9:34am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/2 "2011-01-12T09:34:47Z")

</div>

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 …

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 9:46am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/3 "2011-01-12T09:46:32Z")

</div>

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]

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 12, 2011, 9:52am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/4 "2011-01-12T09:52:16Z")

</div>

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 …

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 10:00am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/5 "2011-01-12T10:00:41Z")

</div>

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]

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 12, 2011, 10:27am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/6 "2011-01-12T10:27:46Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 10:34am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/7 "2011-01-12T10:34:01Z")

</div>

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](http://www.environment-agency.gov.uk)

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 12, 2011, 2:35pm UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/8 "2011-01-12T14:35:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 12, 2011, 2:41pm UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/9 "2011-01-12T14:41:36Z")

</div>

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 ???

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 13, 2011, 2:00pm UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/10 "2011-01-13T14:00:10Z")

</div>

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]

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 13, 2011, 4:08pm UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/11 "2011-01-13T16:08:14Z")

</div>

Always glad to assist a long time toad supporter like yourself 🙂

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 14, 2011, 8:30am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/12 "2011-01-14T08:30:29Z")

</div>

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]

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [January 14, 2011, 8:32am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/13 "2011-01-14T08:32:51Z")

</div>

Out of curiosity, does Toad report that your homes are invalid? What about your User PATH variable, are they listed there?

Michael

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 14, 2011, 8:34am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/14 "2011-01-14T08:34:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [January 14, 2011, 8:37am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/15 "2011-01-14T08:37:30Z")

</div>

A machine can have more than one PATH, I wonder if it was set at one level, and  
not another?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 14, 2011, 8:40am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/16 "2011-01-14T08:40:30Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 14, 2011, 8:48am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/17 "2011-01-14T08:48:59Z")

</div>

Hi Michael,

> Out of curiosity, does Toad report that your homes are invalid? What  
> about your User PATH variable, are they listed there?  
> Yes. The one I have on PATH is listed as valid. The XE, the 10g  
> (10.2.0.5) and a couple on a network drive, are all listed in red on the  
> connection screen and show up as invalid because "bin is not on the  
> path" - but it does exist.

--  
Cheers,  
Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 14, 2011, 8:50am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/18 "2011-01-14T08:50:29Z")

</div>

Hi Bert,

> 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  
> Trust me, I've got enough troubles to be sorting out, I'm definitely  
> moving on! And yes, she had a proper install of 10205 client not instant  
> client.

Thanks again.

--  
Cheers,  
Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 14, 2011, 8:52am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/19 "2011-01-14T08:52:30Z")

</div>

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]

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 14, 2011, 8:59am UTC](https://forums.toadworld.com/t/oci-version-is-not-supported/10146/20 "2011-01-14T08:59:07Z")

</div>

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]

[Next page](https://forums.toadworld.com/t/oci-version-is-not-supported/10146.md?page=2)
