Home » SQL & PL/SQL » Client Tools » toad connect using (Toad 10.6.1.3)
toad connect using [message #522377] Fri, 09 September 2011 02:11 Go to next message
mape
Messages: 229
Registered: July 2006
Location: Slovakia
Senior Member

Hello

After starting TOAD you can choose which Oracle Home will be used.

I just manually made a copy oracle instant client 11.2 into the some directory of my local PC.
I setup system %PATH% and %TNS_ADMIN% variables into the User variables (Environment variables on "My Computer").

Now when I run TOAD (10.6.1.3) I dont see any Oracle Home (connect using).
But when I run older version of TOAD (9.7.2.5) I see that Oracle Home.

Could you please anybody tell me what can I do to see it ?

Thanks

Re: toad connect using [message #522379 is a reply to message #522377] Fri, 09 September 2011 02:26 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I suspect that manually copying Oracle Client installation into a directory is much different from actually installing that Oracle product. Installation doesn't just "put files into a directory", but does certain settings into (for example) Windows Registry. TOAD might, on the other hand, rely on what it finds in that Registry and - being unable to find anything - displays nothing. Setting two environment variables appears to be insufficient to fool TOAD.

However, I might be very wrong. These are just my thoughts.

By the way, does your Client 11.2 work (the way you put it onto your PC)? Can you actually use it?
Re: toad connect using [message #522380 is a reply to message #522379] Fri, 09 September 2011 02:31 Go to previous messageGo to next message
mape
Messages: 229
Registered: July 2006
Location: Slovakia
Senior Member

Older version of TOAD actually use this instant client without a problem.
Re: toad connect using [message #522385 is a reply to message #522380] Fri, 09 September 2011 03:22 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How exactly did you do that?

Did you first copy Oracle client, then installed TOAD?
Or did you first install TOAD, then copied Oracle client?
Re: toad connect using [message #522386 is a reply to message #522385] Fri, 09 September 2011 03:25 Go to previous messageGo to next message
mape
Messages: 229
Registered: July 2006
Location: Slovakia
Senior Member

I did install TOAD and after that copied Oracle instant client.
Re: toad connect using [message #522387 is a reply to message #522386] Fri, 09 September 2011 03:31 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If possible, uninstall TOAD. As Oracle client is already here, install TOAD again and see whether it will find the Client home.
Re: toad connect using [message #522430 is a reply to message #522377] Fri, 09 September 2011 07:17 Go to previous message
wvu1999
Messages: 38
Registered: April 2007
Member

Uninstalling Toad won't do anything to help.

If you click on the ellipsis button next to the oracle home selector it will do diagnostics and possibly show why your Home is not 'valid'

Have you connected via SQL*Plus to ensure the client software is available and working?
Previous Topic: Toad explain plan on current statement
Next Topic: connect from oracle 9i to sql developer
Goto Forum:
  


Current Time: Mon Sep 01 21:52:39 CDT 2014

Total time taken to generate the page: 0.10249 seconds