# How to Configure TOAD for Oracle **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [June 9, 2011, 6:56am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501 "2011-06-09T06:56:16Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![PAgarwal](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@PAgarwal](https://forums.toadworld.com/u/PAgarwal)\ **Post date:** [June 9, 2011, 6:56am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/1 "2011-06-09T06:56:16Z")
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. ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [June 9, 2011, 6:56am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/2 "2011-06-09T06:56:16Z")
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 … ---
**Author:** ![PAgarwal](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@PAgarwal](https://forums.toadworld.com/u/PAgarwal)\ **Post date:** [June 9, 2011, 7:22am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/3 "2011-06-09T07:22:09Z")
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. ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [June 9, 2011, 7:22am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/4 "2011-06-09T07:22:09Z")
Some reading to assist you: [http://www.toadworld.com/BLOGS/tabid/67/EntryId/488/TOAD-Database-Connections-Pro](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.orafaq.com/wiki/Sqlnet.ora) [http://www.dbatoolz.com/t/installing-oracle-instantclient-basic-and-instantclient](http://www.dbatoolz.com/t/installing-oracle-instantclient-basic-and-instantclient) -sqlplus-on-win32.html [http://ss64.com/ora/syntax-tnsnames.html](http://ss64.com/ora/syntax-tnsnames.html) and of course the oracle docs …. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 9, 2011, 7:22am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/5 "2011-06-09T07:22:09Z")
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](https://global.discourse-cdn.com/quest/original/1X/278be512a68050c664416c8c1dd90a338bc191af.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 9, 2011, 7:22am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/6 "2011-06-09T07:22:09Z")
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](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [June 9, 2011, 7:39am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/7 "2011-06-09T07:39:35Z")
Bert’s being modest, he has a really nice 100+ page book for beginners > **[Introduction to Oracle: Basic Skills for Any Oracle User](https://www.amazon.com/Introduction-Oracle-Basic-Skills-User/dp/1450508782)** > > Are you new to Oracle databases? Have you just been assigned your first Oracle task or project? Maybe you're already database literate - but accustomed to working with another database such as Microso ... 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 ---
**Author:** ![PAgarwal](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@PAgarwal](https://forums.toadworld.com/u/PAgarwal)\ **Post date:** [June 9, 2011, 7:51am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/8 "2011-06-09T07:51:45Z")
Thanks a ton… I will surely go thru the docs and relevant material. ---
**Author:** ![sachinbiher](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@sachinbiher](https://forums.toadworld.com/u/sachinbiher)\ **Post date:** [January 25, 2017, 11:45am UTC](https://forums.toadworld.com/t/how-to-configure-toad-for-oracle/10501/9 "2017-01-25T11:45:33Z")
HI Guys, please look the video which will help you to connect toad . [https://youtu.be/d7hDegNYzw0](https://youtu.be/d7hDegNYzw0) thanks