|
|
|
|
|
|
|
|
|
|
| Re: TOAD says : You have no oracle clients installed [message #272108 is a reply to message #272099] |
Thu, 04 October 2007 01:22   |
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 #272150 is a reply to message #272130] |
Thu, 04 October 2007 02:20 |
 |
Littlefoot
Messages: 21823
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 #474663 is a reply to message #272067] |
Tue, 07 September 2010 23:54 |
pointers
Messages: 451
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 #495886 is a reply to message #495874] |
Wed, 23 February 2011 01:19 |
|
Littlefoot
Messages: 21823
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 #525224 is a reply to message #525215] |
Fri, 30 September 2011 03:18 |
|
Littlefoot
Messages: 21823
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
ohh.. im so sory
