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.
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.________________________________________
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.
mine is located at$ORACLE_HOME/BIN/oci.dll08/29/2005 07:47 PM 344,064 oci.dllMartin Gainty______________________________________________Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaengersein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitungoder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich demAustausch von Informationen und entfaltet keine rechtliche Bindungswirkung.Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftungfuer 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: email@example.com>
What windows you have 32 or 64 bit?
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.
Hi!1) Right click on your Computer icon, Properties2) Advanced, Environement variablesIn 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 touse in Oracle.4) Set in System variables "ORACLE_PATH" and then the name of your client home5) Here you might have a problem with tnasnames.ora and sqlnet.ora fiels but tofuixed hat google for "TNS_ADMIN" patternWith those two settings you must be able to have right choice in Toad. If stillhave some problems then your PC is really messed up with several versions...thebest way is to uninstall them and start all again!P.S.Oracle software (not Toad) is known as very "concentrate" software ... just twodirectories and on registry entry. Another problem is administrating multipleORACLE_HOMEs...but this has nothing with ToadHope this helps,Damir Vadashttp://damir-vadas.blogspot.com
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.
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 separatedirectories ...otherwise you have mixed Oracle versions. Trust me this is thecase.3) Obviously if your 9i software works.... this is the problem. Try to put inthat 9i HOME the same client software form 10g client-it will be damaged aswell!Do not mix in the same directories any different installation of Oracle if it isnot specified to do so. If you separate them it will always a way to put themtogether...Hope this helpsDamir Vadashttp://damir-vadas.blogspot.com
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
I have a local 10g server with client installed all in same location.C:\orcle\product\10.2.0\db_2The client files are included in the various subdirectories.
As long as we can find the BIN directory in your PATH somewhere and yourTNSNAMES.ORA file somewhere there or in your SQLPATH, I think you should be goodto go.What does your screenshot of this screen display?
Jeff,Different types of Oracle software in the same home is highly avoidable option...Damir Vadashttp://damir-vadas.blogspot.com
Jeff,Different types of Oracle software in the same home is highly avoidableoption...Damir Vadashttp://damir-vadas.blogspot.com
This is the default installation option. Full install of 10gR2 Windows.Do you have a metalink document to suggest otherwise? Mayhaps I need to changemy ways…
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 Vadashttp://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 donotunderstand me) I'll give one example.Let us suppose you install Oracle 10gR2 database , I think 10.2.01 is the firstrelease for 10gR2 for Win32. Then you install in THE SAME DIRECTORY OracleClient 10gR1 (10.1.x). Now tell me, what version is installed...libraries areoverwritten!!!!! ANd you have a mix of homes so please do understand that thisis far form ok situation. I didn't want to involve patches and upgrades whichare in those situations impossible!For the end let me tell you I have successfully installed Oracl 10gR2 RAC with 3database (PROD, TEST and PROD2) with ASM and CRS ORACLE_HOMES - Totally 5 ofthem. In RAC installation there is a must to install CRS software separate fromASM and others database software. And the best practice is to have ASM inseparate home as well (beside database). For that you may read in 10gR2 RACinstallation guideHope this helps and ends this multipel HOME story.Damir Vadashttp://damir-vadas.blogspot.com