Home » SQL & PL/SQL » Client Tools » TOAD says : You have no oracle clients installed
TOAD says : You have no oracle clients installed [message #272067] Wed, 03 October 2007 22:46 Go to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
what's wrong with this error
i have oracle clients 9i and TOAD version 9
i check with sqlplus, and its work successfully
but i try with TOAD, then show message "You have no oracle clients installed"

screenshot
  • Attachment: toaderr1.JPG
    (Size: 52.94KB, Downloaded 5087 times)

[Updated on: Wed, 03 October 2007 23:28]

Report message to a moderator

Re: TOAD says : You have no oracle clients installed [message #272068 is a reply to message #272067] Wed, 03 October 2007 22:47 Go to previous messageGo to next message
BlackSwan
Messages: 22515
Registered: January 2009
Senior Member
>what's wrong with this error
There is nothing wrong with this error.
Re: TOAD says : You have no oracle clients installed [message #272070 is a reply to message #272068] Wed, 03 October 2007 23:17 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
other screenchot
  • Attachment: toaderr2.JPG
    (Size: 98.41KB, Downloaded 7566 times)
Re: TOAD says : You have no oracle clients installed [message #272072 is a reply to message #272070] Wed, 03 October 2007 23:33 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
help me to resolve this error

other screenshot

  • Attachment: toaderr3.JPG
    (Size: 103.49KB, Downloaded 5634 times)

[Updated on: Wed, 03 October 2007 23:35]

Report message to a moderator

Re: TOAD says : You have no oracle clients installed [message #272099 is a reply to message #272072] Thu, 04 October 2007 00:58 Go to previous messageGo to next message
Maaher
Messages: 7041
Registered: December 2001
Senior Member
What do you see when you click the detail button ("...") next to the listbox of the installed clients? You should see a list of installed clients, even if they are invalid.

MHE
Re: TOAD says : You have no oracle clients installed [message #272108 is a reply to message #272099] Thu, 04 October 2007 01:22 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
Maaher wrote on Thu, 04 October 2007 12:58
What do you see when you click the detail button ("...") next to the listbox of the installed clients? You should see a list of installed clients, even if they are invalid.

MHE



when i click the detail button ("...") then show message
"You do not have any Oracle homes installed"
screenshot in the above post.file name toaderr3.jpg
Re: TOAD says : You have no oracle clients installed [message #272112 is a reply to message #272108] Thu, 04 October 2007 01:25 Go to previous messageGo to next message
Maaher
Messages: 7041
Registered: December 2001
Senior Member
What does the registry say? Is the Oracle_Home present in there?

MHE
Re: TOAD says : You have no oracle clients installed [message #272115 is a reply to message #272108] Thu, 04 October 2007 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute regedit.
Go to HKLM\Software\ORACLE
Right click and choose "export"
Then post the result.

Regards
Michel

Re: TOAD says : You have no oracle clients installed [message #272121 is a reply to message #272115] Thu, 04 October 2007 01:33 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
this is export result from the registy
  • Attachment: oracle.reg
    (Size: 101.00KB, Downloaded 7442 times)
Re: TOAD says : You have no oracle clients installed [message #272123 is a reply to message #272121] Thu, 04 October 2007 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Rename it as ".txt", due to proxy/firewall restrictions, I can't download "reg" file.

Regards
Michel
Re: TOAD says : You have no oracle clients installed [message #272124 is a reply to message #272123] Thu, 04 October 2007 01:44 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
Smile ohh.. im so sory
this file in format .txt
  • Attachment: oraclereg.txt
    (Size: 101.00KB, Downloaded 6849 times)
Re: TOAD says : You have no oracle clients installed [message #272126 is a reply to message #272124] Thu, 04 October 2007 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry still can't, maybe someone else can analyze it.

Regards
Michel
Re: TOAD says : You have no oracle clients installed [message #272130 is a reply to message #272126] Thu, 04 October 2007 01:53 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
it's ok Smile

how about you Maaher?
Re: TOAD says : You have no oracle clients installed [message #272150 is a reply to message #272130] Thu, 04 October 2007 02:20 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here it is:
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Oracle]
"inst_loc"="C:\\Program Files\\Oracle\\Inventory"
"ORACLE_HOME"="C:\\DevSuiteHome"
"ORACLE_HOME_NAME"="DEFAULT_HOME1"
"API"="C:\\DevSuiteHome\\dbs"
"ORACLE_GROUP_NAME"="Oracle - DEFAULT_HOME1"
"NLS_LANG"="NA"
"OLEDB"="C:\\ORACLE9i\\oledb\\mesg"
"VOBHOME2.0"="C:\\ORACLE9i"
"OO4O"="C:\\ORACLE9i\\oo4o\\mesg"

[HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\ALL_HOMES]
"HOME_COUNTER"="5"
"DEFAULT_HOME"="DEFAULT_HOME1"
"LAST_HOME"="4"

[HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\ALL_HOMES\ID1]
"NAME"=hex(2):4f,00,72,00,61,00,4e,00,54,00,00,00
"PATH"=hex(2):43,00,3a,00,5c,00,4f,00,72,00,61,00,4e,00,54,00,00,00
"NLS_LANG"=hex(2):41,00,4d,00,45,00,52,00,49,00,43,00,41,00,4e,00,5f,00,41,00,\
  4d,00,45,00,52,00,49,00,43,00,41,00,2e,00,57,00,45,00,38,00,49,00,53,00,4f,\
  00,38,00,38,00,35,00,39,00,50,00,31,00,00,00

[HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\ALL_HOMES\ID1\ntinstall]
"MOH Icons"="exec"
"Shareable"="TRUE"

[HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\ALL_HOMES\ID1\ntinstall\OCSM Groups]
"Run From Server"="res:US,prodmsg:US,script:US,dll:US"
"Full Download"="ntcompat,exec,deinstl"

[HKEY_LOCAL_MACHINE\SOFTWARE
Re: TOAD says : You have no oracle clients installed [message #272153 is a reply to message #272150] Thu, 04 October 2007 02:23 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can you locate the TNSNAMES.ORA file (should be in ORACLE_HOME\NETWORK\ADMIN directory)? How does it look like?
Re: TOAD says : You have no oracle clients installed [message #272154 is a reply to message #272150] Thu, 04 October 2007 02:25 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
how to resolve this
tnsnames.ora already in the folder network\admin\
Re: TOAD says : You have no oracle clients installed [message #272156 is a reply to message #272154] Thu, 04 October 2007 02:29 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How to resolve what?

If TNSNAMES.ORA exists, what happens when you click the "TNSnames Editor" button?

I have a feeling that we're chasing witches here. Perhaps you should just reinstall TOAD.
Re: TOAD says : You have no oracle clients installed [message #272160 is a reply to message #272156] Thu, 04 October 2007 02:34 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
How to resolve what? - the registry

If TNSNAMES.ORA exists, what happens when you click the "TNSnames Editor" button? - Access violation at address 00C776EF in module 'TOAD.exe'. Read of address 0000001C.

i already reinstall TOAD for many times..

Re: TOAD says : You have no oracle clients installed [message #272166 is a reply to message #272160] Thu, 04 October 2007 02:53 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm ... so it isn't Oracle to blame. Did you try to contact Quest Software and ask for help?
Re: TOAD says : You have no oracle clients installed [message #272213 is a reply to message #272166] Thu, 04 October 2007 04:36 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
i have been uninstall all oracle in my computer and delete all registry entries..
now i reinstall oracle clients 9i and got new registry.
but TOAD still not detect oracle home
Sad
  • Attachment: oraclereg.txt
    (Size: 27.14KB, Downloaded 1166 times)
Re: TOAD says : You have no oracle clients installed [message #278411 is a reply to message #272213] Sat, 03 November 2007 21:24 Go to previous messageGo to next message
maxel
Messages: 11
Registered: October 2007
Junior Member
for a long time i still can't resolve this problem,
now im back to TOAD 8 and try TOAD 9.1
both of them working properly Razz
Re: TOAD says : You have no oracle clients installed [message #421088 is a reply to message #272067] Fri, 04 September 2009 03:29 Go to previous messageGo to next message
overtheclock
Messages: 3
Registered: September 2009
Junior Member
I have the same problem with TOAD
what you solution??

Re: TOAD says : You have no oracle clients installed [message #421092 is a reply to message #421088] Fri, 04 September 2009 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Isn't the solution in the previous answer?

Regards
Michel
Re: TOAD says : You have no oracle clients installed [message #421099 is a reply to message #421092] Fri, 04 September 2009 04:08 Go to previous messageGo to next message
overtheclock
Messages: 3
Registered: September 2009
Junior Member
Sorry but i canĀ“t quite get it??
pls explain...
Re: TOAD says : You have no oracle clients installed [message #421100 is a reply to message #421099] Fri, 04 September 2009 04:12 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which TOAD version did you install?
Re: TOAD says : You have no oracle clients installed [message #421102 is a reply to message #421100] Fri, 04 September 2009 04:16 Go to previous messageGo to next message
overtheclock
Messages: 3
Registered: September 2009
Junior Member
Toad 9.5

Are you usig win xp 64 bits???
Re: TOAD says : You have no oracle clients installed [message #421123 is a reply to message #421102] Fri, 04 September 2009 06:41 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Who, me? No, I do not.

So, you are saying that TOAD 9.5 installed on MS Windows XP 64-bit raises "you have no Oracle clients installed" error. Right?

Did you install Oracle client (possibly Oracle Instant Client)?
Re: TOAD says : You have no oracle clients installed [message #422021 is a reply to message #272067] Sun, 13 September 2009 11:47 Go to previous messageGo to next message
funky
Messages: 4
Registered: December 2007
Location: Zagreb
Junior Member
You cannot use the 64-bit Oracle client - you must use the 32-bit client on 64-bit OS.
Cool
Re: TOAD says : You have no oracle clients installed [message #474663 is a reply to message #272067] Tue, 07 September 2010 23:54 Go to previous messageGo to next message
pointers
Messages: 345
Registered: May 2008
Senior Member
I just got the same problem.

I have installed oracle 11g R2 (64 bit) in Windows 7 opearting system (64 bit). I am able to connect oracle from sql*plus. But when i try to connect from toad 9.7.5 I get an error saying oracle client is not installed.
As per the previous threads I understood that we cant use oracle client (64 bit) for toad. Is that right.

Could you please help me how to overcome this issue.

Regards,
Pointers
Re: TOAD says : You have no oracle clients installed [message #474664 is a reply to message #474663] Tue, 07 September 2010 23:57 Go to previous messageGo to next message
BlackSwan
Messages: 22515
Registered: January 2009
Senior Member
>I have installed oracle 11g R2 (64 bit) in Windows 7 opearting system (64 bit). I am able to connect oracle from sql*plus.
So problem is not with anything Oracle.
Post problem on Quest forum or just use sql*plus
Re: TOAD says : You have no oracle clients installed [message #495874 is a reply to message #474664] Tue, 22 February 2011 23:44 Go to previous messageGo to next message
itralarcon
Messages: 36
Registered: February 2011
Location: San Salvador
Member

I had this error before, I solved reinstalling toad ... It seems that toad does not recognize Oracle clients if it was installed after clients... Try to install Toad After Oracle...
Re: TOAD says : You have no oracle clients installed [message #495886 is a reply to message #495874] Wed, 23 February 2011 01:19 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, TOAD on MS Windows 7 works fine. It doesn't matter whether you install TOAD first, or Oracle Client first. What bothers TOAD is that it "hates" to be installed into a directory whose name contains brackets.

As TOAD is 32-bit application, it - as any other 32-bit application installed on 64-bit Windows - goes into "Program Files (x86)" directory. Well, TOAD complains about it. You might even get ORA-12514 or ORA-06413, although everything was installed successfully.

After hours of Googling, I found that TOAD should be installed into a directory whose name doesn't contain brackets. "(x86)" contains them so - avoid it. I thought: what the heck, I'll put it into "Program Files" ... directory as any other. Well, not really. Installer created some files in (x86) anyway, so this installation was really a garbage.

Therefore, I chose "C:\Toad" as a destination directory, installed TOAD in there and everything works OK.
Re: TOAD says : You have no oracle clients installed [message #525215 is a reply to message #272067] Fri, 30 September 2011 02:59 Go to previous messageGo to next message
sumitsethi1612
Messages: 1
Registered: March 2007
Location: Boston
Junior Member
Follow This brilliant link :- celemotan.wordpress.com/2008/10/22/instantclient/

I am succesfully using toad in wndows 7
Re: TOAD says : You have no oracle clients installed [message #525224 is a reply to message #525215] Fri, 30 September 2011 03:18 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As many of us do.

I read contents of the page you suggested. No major objections, but one: the first sentence:
Quote:
Did you ever get frustrated when you want to connect with your oracle database, but you have to install everything from oracle client software cd and waste for hundreds megs only to get connect with your database?

That's nonsense. "Install everything"? Oracle Universal Installer suggests several options, such as Instant Client, Runtime, and - oh, guess what? - Custom installation which enables you to choose individual components to install.

"Waste hundreds of megs"? No kidding! Instant Client (10.2.0.1.0) needs 498 MB. The same Instant Client ZIP file occupies 463.956 KB on disk. In order to use it (the way person who wrote that article says), you have to unzip it. How many MB would that waste? Hundreds of megs, right? So what difference does it make whether you actually install the Client software or just have it unzipped on disk? None, regarding the space. You might, however, find some difficulties trying to use certain functionalities because you didn't install the Client (because you chose to save hundreds of megs; right).

Oh well, never mind. I hope everyone enjoys his/her TOAD on Windows 7.
Re: TOAD says : You have no oracle clients installed [message #525585 is a reply to message #525224] Tue, 04 October 2011 00:03 Go to previous messageGo to next message
alexmoore
Messages: 24
Registered: October 2011
Junior Member
these should be resolve by the creating new tns and also deleting previous one . while talking about the oracle sqlplus i think you are not configure it correctly.make sure it have right settings.
Re: TOAD says : You have no oracle clients installed [message #545756 is a reply to message #272067] Fri, 02 March 2012 05:32 Go to previous messageGo to next message
sid2986
Messages: 11
Registered: February 2012
Location: india
Junior Member

Wow, i was having the same kind of problem with toad and thought of asking others here in the forum, but seeing how the senior members troll here without trying to help is really pathetic. Seriously, this isnt the case in other tech forums. I even made a mistake of asking a problem i was having with some database deadlocks over here.. and these very smart senior members keep asking irrelevant stuffs making them look ultra smart without actually helping.

Sad experience here, really.
Re: TOAD says : You have no oracle clients installed [message #545760 is a reply to message #545756] Fri, 02 March 2012 05:55 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you, please, point to messages you find offending?
Re: TOAD says : You have no oracle clients installed [message #545812 is a reply to message #272067] Fri, 02 March 2012 09:42 Go to previous messageGo to next message
sid2986
Messages: 11
Registered: February 2012
Location: india
Junior Member

Littlefoot: As you are a moderator and that too a senior member, your reading skills must be good. Take a good look at how you guys behave specially when the original poster is quite polite and tries to be as informative as possible. Not all like arrogant irrelevant answers, please don't forget that there are thousands of more competent guys who are quite down to earth and don't try to be sarcastic or aggressive. None FORCED you to help either as well as none FORCED you not to help if you want.

Anyway, its futile talking about all these things in serious online forums as its mostly each for their own.

Peace from my end.
Re: TOAD says : You have no oracle clients installed [message #545820 is a reply to message #545812] Fri, 02 March 2012 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Anyway, its futile talking about all these things in serious online forums as its mostly each for their own.


So why do you write such posts? Question

Regards
Michel
Re: TOAD says : You have no oracle clients installed [message #545831 is a reply to message #545820] Fri, 02 March 2012 11:25 Go to previous messageGo to previous message
sid2986
Messages: 11
Registered: February 2012
Location: india
Junior Member

Quote:
So why do you write such posts? Question


You don't read your own posts, do you. And isn't it obvious to see the tone that you speak ?

Previous Topic: How to suppress the output?
Next Topic: Unable to use isqlplus
Goto Forum:
  


Current Time: Mon Jul 28 14:31:26 CDT 2014

Total time taken to generate the page: 0.07065 seconds