################ 
# Filename......: tnsnames.ora 
# This file is used by SQL*NET V2 to determine the location of remote databases 
# 
# Comments are preceded by ### 
# 
# Each database definition must consist of the following info 
# 
# 1. Connect String 
# 2. IP/Hostname of Database Server 
# 3. Port that Oracle Listener is listening on (defined in listener.ora) 
# 4. SID of database (defined at database creation) 
# 
# Note that the SID, hostname, and port MUST match those specified in the listener.ora file. 
# 
# The Following entry associates the connect string MY_DATABASE 
# with a database having SID DEVEL that is running on 
# a machine with hostname database.server.com attached to a 
# listener running on port 1526 (oracle default) 
# 
# All Subsequent connections to this database can be done referencing the MY_DATABASE 
# Connect String 
# 
MY_DATABASE = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (PROTOCOL = TCP) 
          (Host = the_database.server.com) 
          (Port = 1526) 
        ) 
    ) 
    (CONNECT_DATA = (SID = DEVEL) 
    ) 
  ) 

################################### 
# END Definition for MY_DATABASE Connect String 
# The file can have any number of connect strings, provided 
# that each connect string is UNIQUE 
###################################