You have no oracle clients installed

Follow / 21 Nov 2009 at 4:18am

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.

Replies

  • Follow / 21 Nov 2009 at 10:06pm

    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.

    ________________________________________

  • Follow / 21 Nov 2009 at 11:27pm

    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.

  • Follow / 22 Nov 2009 at 4:06am

    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
    >

  • Follow / 22 Nov 2009 at 1:27pm

    What windows you have 32 or 64 bit?

  • Follow / 22 Nov 2009 at 9:37pm

    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.

  • Follow / 22 Nov 2009 at 10:35pm

    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.
    4) Set in System variables "ORACLE_PATH" and then the name of your client home
    5) 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
    http://damir-vadas.blogspot.com

  • Follow / 23 Nov 2009 at 8:53am

    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.

  • Follow / 23 Nov 2009 at 1:56pm

    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
    http://damir-vadas.blogspot.com

  • Follow / 23 Nov 2009 at 4:04pm

    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

  • Follow / 23 Nov 2009 at 4:44pm
    image001.png

    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?

  • Follow / 23 Nov 2009 at 5:05pm
    image001.png

    Jeff,

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

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

    ________________________________

    Jeff,

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

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

  • Follow / 23 Nov 2009 at 5:06pm
    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
  • Follow / 23 Nov 2009 at 5:09pm
    image001.png

    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…

  • Follow / 23 Nov 2009 at 9:13pm
    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
    >
    >
    >
    >
  • Follow / 23 Nov 2009 at 10:35pm
    image001.png

    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
    http://damir-vadas.blogspot.com

    ________________________________

    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
    http://damir-vadas.blogspot.com