You have no oracle clients installed

Toad for Oracle
1

Hello. I am sure this question has come up numerous times so I apologize in advance for asking this. I have Oracle 10g installed (10.2.0.4) and TOAD 9.0. I have running Oracle instances and can access them on this system via SQLPLUS with no issue. When I start up TOAD I get the error message: “You have no Oracle clients installed.”

I have verified that I have an Oracle_Home set in the registry. I have found no way to correct this problem. I would be extremely grateful if someone could point me in the right direction.

Thank you in advance.

Andrew.

2

On the connection screen for toad, at the bottom, you should see a dropdown control that shows your installed oracle clients/oracle homes. Guessing it’s empty for you…

To the right of that is an ellipsis … button. Click on that. Toad will attempt to diagnose your installation issue.

Could be your PATH isn’t upated to include OCI.DLL or maybe Toad can’t find your TNSNames.ORA file.

3

Hi Jeff,

Thanks for your reply. I tried what you suggested but when I click on this elipses I get the following error message from TOAD:

“You do not have any Oracle homes installed!”

I definitely do have an Oracle home installed and can see this clearly defined as a registry entry. I also have checked that the value of my Oracle home is accurately reflected in my PATH variable.

Do you have any other suggestions?

Thank you so much for your assistance and advice.

Sincerely,

Andrew.

4

mine is located at
$ORACLE_HOME/BIN/oci.dll

08/29/2005 07:47 PM 344,064 oci.dll

Martin Gainty

Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

To: toad@yahoogroups.com

5

What windows you have 32 or 64 bit?

6

Thanks for your reply. I am running 32 bit so there should be no issue in this regard. Thank you for your reply. I am at a loss of how to have TOAD recognize I have an Oracle client installed.

Sincerely,

Andrew.

7

Hi!

  1. Right click on your Computer icon, Properties
  2. Advanced, Environement variables
    In PATH ensure that your Oracle home (your client) is first in definition (I.e.
    c:\oracle\client32\bin). With this you ensure that this home will be first to
    use in Oracle.
  3. Set in System variables “ORACLE_PATH” and then the name of your client home
  4. Here you might have a problem with tnasnames.ora and sqlnet.ora fiels but to
    fuixed hat google for “TNS_ADMIN” pattern

With those two settings you must be able to have right choice in Toad. If still
have some problems then your PC is really messed up with several versions…the
best way is to uninstall them and start all again!

P.S.
Oracle software (not Toad) is known as very “concentrate” software … just two
directories and on registry entry. Another problem is administrating multiple
ORACLE_HOMEs…but this has nothing with Toad

Hope this helps,
Damir Vadas

8

Hi Damir,

Thanks so much for your suggestions. I have done exactly as you instructed but I am still getting the same error. I only have one ORACLE_HOME and I created the ORACLE_PATH variable as well that has the same value as the Oracle home. I am not sure what the issue is. I have the 10g Oracle database installed on this system so I have the Oracle server software and the Oracle Client software all installed in the same ORACLE_HOME. I am wondering if this is the problem. I do not have this issue with TOAD using the 9i client. TOAD just seems completely unwilling to recognize there is any Oracle databases or client software installed even though I can easily access the databases via sqlplus. This is very frustrating as I don’t want to have to revert back to 9i.

If you have any other suggestions I would be very grateful.

Sincerely,

Andrew.

9

Hi Andrew,

  1. “ORACLE_PATH variable” should be normal PATH not some other…
  2. Oracle Client software all installed in the same ORACLE_HOME This is wrong
    !!! This ORACLE_HOME is damaged…so uninstall them both. Put them in separate
    directories …otherwise you have mixed Oracle versions. Trust me this is the
    case.
  3. Obviously if your 9i software works… this is the problem. Try to put in
    that 9i HOME the same client software form 10g client-it will be damaged as
    well!

Do not mix in the same directories any different installation of Oracle if it is
not specified to do so. If you separate them it will always a way to put them
together…

Hope this helps
Damir Vadas

10

Hi Andrew,

I’m curious, what is the full version of Toad that you have installed? I was looking through the Toad 9.0.1 release notes and found the following bug listed as “fixed” for this patch:

“No Oracle homes installed” message on startup in some cases (30599)

Thanks,
Brad

11

I have a local 10g server with client installed all in same location.

C:\orcle\product\10.2.0\db_2

The client files are included in the various subdirectories.

As long as we can find the BIN directory in your PATH somewhere and your
TNSNAMES.ORA file somewhere there or in your SQLPATH, I think you should be good
to go.

What does your screenshot of this screen display?
image001.png

12

Jeff,

Different types of Oracle software in the same home is highly avoidable option…

Damir Vadas

Jeff,

Different types of Oracle software in the same home is highly avoidable
option…

Damir Vadas


image001.png

13

Don’t forget the button on connect screen next to the oracle home selection - it’s a mini browser for the registry entries related to oracle - and offers some nice features such as “check the values” for reasonableness … You might open this up too to see if there are multiple homes. A common mistake is to have two oracle homes with the tns names file in just one location. Then sql plus and other tools may work since they may default to that home. But then toad needs told where to point - so that we too can see the proper tns names data

14

This is the default installation option. Full install of 10gR2 Windows.

Do you have a metalink document to suggest otherwise? Mayhaps I need to change
my ways…
image001.png

15

When you do a full server install of 10gR2 (or 9i, or 8i, or 8.0, or
...) on any Unix platform you get the client tools for free in the same
ORACLE_HOME.
You should never mix clients and/or server software of different
versions in one OH.

Peter

Jeff Smith schreef:

This is the default installation option. Full install of 10gR2 Windows.

Do you have a metalink document to suggest otherwise? Mayhaps I need
to change my ways…

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Damir Vadas
Sent: Monday, November 23, 2009 10:05 AM
To: toad@yahoogroups.com
Subject: Re: [toad] Re: You have no oracle clients installed

Jeff,

Different types of Oracle software in the same home is highly
avoidable option...

Damir Vadas
http://damir-vadas.blogspot.com

16

Jeff,

I do not have an Meatlink note for that…

But at the end of this topic (either I do not understand you or you donot understand me) I’ll give one example.

Let us suppose you install Oracle 10gR2 database , I think 10.2.01 is the first release for 10gR2 for Win32. Then you install in THE SAME DIRECTORY Oracle Client 10gR1 (10.1.x). Now tell me, what version is installed…libraries are overwritten!!! ANd you have a mix of homes so please do understand that this is far form ok situation. I didn’t want to involve patches and upgrades which are in those situations impossible!

For the end let me tell you I have successfully installed Oracl 10gR2 RAC with 3 database (PROD, TEST and PROD2) with ASM and CRS ORACLE_HOMES - Totally 5 of them. In RAC installation there is a must to install CRS software separate from ASM and others database software. And the best practice is to have ASM in separate home as well (beside database). For that you may read in 10gR2 RAC installation guide

Hope this helps and ends this multipel HOME story.

Damir Vadas

Jeff,

I do not have an Meatlink note for that…

But at the end of this topic (either I do not understand you or you donot
understand me) I’ll give one example.

Let us suppose you install Oracle 10gR2 database , I think 10.2.01 is the first
release for 10gR2 for Win32. Then you install in THE SAME DIRECTORY Oracle
Client 10gR1 (10.1.x). Now tell me, what version is installed…libraries are
overwritten!!! ANd you have a mix of homes so please do understand that this
is far form ok situation. I didn’t want to involve patches and upgrades which
are in those situations impossible!

For the end let me tell you I have successfully installed Oracl 10gR2 RAC with 3
database (PROD, TEST and PROD2) with ASM and CRS ORACLE_HOMES - Totally 5 of
them. In RAC installation there is a must to install CRS software separate from
ASM and others database software. And the best practice is to have ASM in
separate home as well (beside database). For that you may read in 10gR2 RAC
installation guide

Hope this helps and ends this multipel HOME story.

Damir Vadas


image001.png

17

Peter,

I think the whole story starts with problems with Toad and this is strictly
connected with windows environment. I agree with you but please let us focus on
the topis of this forum…a

Hope you do understand me.

Damir Vadas

18

Right.

But if you JUST install Oracle 10gR2 in one fell swoop, there should be no
prolems. Client/Server goes down to the same directory, and that’s fine.
Your supposition does raise some interesting questions, but you shouldn’t need
to install the client after you install Oracle server/database.
image001.png

19

Jeff,

Now I realize that I’m speaking with someone from quest…whose guys I find very open minded…So now I’d like to clear up the term:
“10gR2 in one fell swoop, there
should be no prolems”
What do you mean by this…I do not understand that.

From my point of view, for give me for he term, “your exibition” with one hoem and two installation is far far away from the standindgs that should be explained on forum like toad, where many has not so much of knowledge in Oracle and experimenting in this way may lead more problems then benefits.

In all my carrier I have heard for plenty of qurious Oracle problems…just a few …very few of them I sam personally. Why ? Because I didn’t want to experiment on things that are not experimental-Oracle is not such an software.
Hope this helps,
Damir Vadas

P.S:
Would you on teh same box, over Windows XP installation install Win XP SP1 in the same directory? I’m pretty sure you will not…So why Oracle should be different?
:wink:

P.S:
According first sentence, I’m pretty sure that you and me have crossed each other in discussion…or at least I do not understand your standing. Once again cannot believe that you may recommend to anyone to install two versions of Oracle software in the same ORACLE_HOME…

Jeff,

Now I realize that I’m speaking with someone from quest…whose guys I find very
open minded…So now I’d like to clear up the term:
“10gR2 in one fell swoop, there should be no prolems”
What do you mean by this…I do not understand that.

From my point of view, for give me for he term, “your exibition” with one hoem
and two installation is far far away from the standindgs that should be
explained on forum like toad, where many has not so much of knowledge in Oracle
and experimenting in this way may lead more problems then benefits.

In all my carrier I have heard for plenty of qurious Oracle problems…just a
few …very few of them I sam personally. Why ? Because I didn’t want to
experiment on things that are not experimental-Oracle is not such an software.
Hope this helps,
Damir Vadas

P.S:
Would you on teh same box, over Windows XP installation install Win XP SP1 in
the same directory? I’m pretty sure you will not…So why Oracle should be
different?
:wink:

P.S:
According first sentence, I’m pretty sure that you and me have crossed each
other in discussion…or at least I do not understand your standing. Once again
cannot believe that you may recommend to anyone to install two versions of
Oracle software in the same ORACLE_HOME…
image001.png

20

Jeff,

“Client/Server goes down to the same directory, and that’s
fine.”
Could you explain that please…Now I see that I really do not agree with you in any way…Please read my previous reply and my standing why such a procedure should not be used in Oracle.

If you install Oracle server installation (from standard to server either), you have the most that Oracle software can install and this is far from “classic client software” installation which install only drivers and reduced set of tools and libraries. Administrator version is something that I strongly advice as installation type for that type of software…especially when you need it to support Toad. Even thought I’ll always recommended 10gR2Win32 against 11g Win32 because it has is tha last version that have sqlplusw.exe, true windows application for manipulation with sql.

Damir Vadas

Jeff,

" Client/Server goes down to the same directory, and that’s fine."
Could you explain that please…Now I see that I really do not agree with you in
any way…Please read my previous reply and my standing why such a procedure
should not be used in Oracle.

If you install Oracle server installation (from standard to server either), you
have the most that Oracle software can install and this is far from “classic
client software” installation which install only drivers and reduced set of
tools and libraries. Administrator version is something that I strongly advice
as installation type for that type of software…especially when you need it to
support Toad. Even thought I’ll always recommended 10gR2Win32 against 11g Win32
because it has is tha last version that have sqlplusw.exe, true windows
application for manipulation with sql.

Damir Vadas


image001.png