Solved

where can i find oracle client required for Toad

Posted on 2007-12-05
9
4,346 Views
Last Modified: 2011-09-20
I am installing toad
where can i find oracle client required for Toad ; so I can copy the tnsname.ora file the client has provided to connect to the db

do i have to download the whole db or can i just download and set up the oracle client?

0
Comment
Question by:royalcyber
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 20416194
You will need minimum Oracle client to use Toad on your workstation.

you can download toad from http://www.oracle.com/technology/software/products/database/index.html site

0
 

Author Comment

by:royalcyber
ID: 20416266
I need to connect to oracle database 10g so which software shall I download for windows xp?
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 20416655
Sorry about the error in my last reply.

you can download Oracle client from this url:

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html

0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:royalcyber
ID: 20425669
hello

I have downloade dthe oracle client

i have under Start Menu --> Pracle - OraClient10g_home1  --> Application Development
                                                                                                    Configuration and Migration tools --> Microsoft Odbc administrator


I have also installed toad

now how can I connect to the oracle db server from toad

thanks
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 20425688
Just start Toad and from the drop down list (Toad GUI) select your database server name, enter username and password and click on Connect.

0
 

Author Comment

by:royalcyber
ID: 20425701
it is showing blank

also whicj folder do i copy my tns file
0
 
LVL 11

Accepted Solution

by:
mohammadzahid earned 500 total points
ID: 20425721
yes
0
 

Author Comment

by:royalcyber
ID: 20425759
In toad ; it is showing blank

also which folder do i copy my tns file?
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 20425775
tnsnames file is always located in $ORACLE_HOME\network\admin folder.

Please make sure your connect string is pointing to the correct host and database.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question