Oracle and Toad – tnsnames.ora example

Getting Toad to work with Oracle doesn’t seem to be explained very well anywhere.

Here’s a quick list:

  1. Download and Install TOAD from
  2. Download and Install the Oracle XE Client from
  3. If you launch toad now, you should see XE as an option for connecting to Oracle
  4. Create a tnsnames.ora file in C:/Program Files/Quest Software/Toad for Oracle FREEWARE/

Here is an example of a tnsnames.ora file for Toad

(ADDRESS = (PROTOCOL = TCP) (HOST = = 1521))
(CONNECT_DATA = (SID = orcl))

Once this file is there you can re-open Toad and use “IDENTIFIER” as
the connection identifier (drop down list). Toad will then know that it
has to connect to the oracle server at on port 1521

Leave a Reply

Your email address will not be published.