################
# 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
###################################
