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
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
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 .
thanks