Toad World® Forums

How to Configure TOAD for Oracle

Hi,

I am new to Oracle. I am trying to access oracle via toad. I have installed TOAD 10.6 and Oracle client 11g on my system. Database Server name is XYZ and a given IP Address. Currently TOAD in my system shows nothing. How can I access databases on server through TOAD.

I tried connecting to server using following details:
User/Schema: ABC
Password: ABC
Database: XYZ

Connect Using: OraClient11g_home1

This gives me error: No Listener

Need help!!!

Thanks in advance.

Did you create a tnsnames.ora file on your PC? That’s the file that tells
oracle client side software where your database is and how to get to it?

PS – this has nothing to do with toad – all products on your PC that
want to get to oracle (e.g. excel, odbc, etc) all need this file – this is
oracle 101 type connectivity stuff …

No I haven’t created TNSnames.ora file. Can you please guide me on how to create it and where to create it?

Thanks again.

Some reading to assist you:

http://www.toadworld.com/BLOGS/tabid/67/EntryId/488/TOAD-Database-Connections-Pro
blems.aspx

Also recommend looking at:

http://www.orafaq.com/wiki/Sqlnet.ora

http://www.dbatoolz.com/t/installing-oracle-instantclient-basic-and-instantclient
-sqlplus-on-win32.html

http://ss64.com/ora/syntax-tnsnames.html

and of course the oracle docs ….

WHERE TO:

Your Oracle Client instalation folder \network\ADMIN\TNSnames.ora

HOW TO:

In this localization also should be SAMPLE folder with example of TNSnames.ora

Regards,

Adam
image001.jpeg

WHERE TO:

Your Oracle Client instalation folder \network\ADMIN\TNSnames.ora

HOW TO:

In this localization also should be SAMPLE folder with example of TNSnames.ora

Regards,

Adam
image001.jpeg

Bert’s being modest, he has a really nice 100+ page book for beginners

You should have a good understanding of relational databases and SQL before you
start using Toad. That’s not always possible, so we’ll be here to
help.

Jeff

Thanks a ton… I will surely go thru the docs and relevant material.

HI Guys,

please look the video which will help you to connect toad .

https://youtu.be/d7hDegNYzw0

thanks