Document ID: 16885.1
Subject: Example TNSNAMES.ORA (Unix)
Last Modified: 31 Jul 96
Author: RPOWELL
# -----------------------------------------------------------------------
# Sample tnsnames.ora file - Clients use this to decide where to call
# NB: *1 You *MUST* use YOUR servers 'hostname' where shown below
# *2 Do *NOT* enter the comments in the script below or you may get
# ORA 6401 errors.
# Ie: Do *NOT* enter the '#' or the text after it. These are
# explanatory comments only.
# -----------------------------------------------------------------------
#
# Local IPC Aliases
#
v713 = #<-- Use for Local Socket DEDICATED connections
(DESCRIPTION =
(ADDRESS= (PROTOCOL=IPC) (KEY=700))
(CONNECT_DATA= (SID=V713) (SERVER=DEDICATED)) #<-- Use YOUR $ORACLE_SID
)
mv713 = #<-- Use this alias for socket MTS connections
(DESCRIPTION =
(ADDRESS= (PROTOCOL=IPC) (KEY=700))
(CONNECT_DATA= (SID=MV713)) #<-- Use YOUR MTS_SERVICE name
) # as defined in init.ora
# Sample TCP/IP Aliases
#
tcp_v713 =
(DESCRIPTION =
(ADDRESS= (PROTOCOL=TCP) (HOST=hostname) (PORT=1521)) #<-- *1
(CONNECT_DATA= (SID=V713) (SERVER=DEDICATED)) #<-- Use YOUR $ORACLE_SID
)
tcp_mv713 =
(DESCRIPTION =
(ADDRESS= (PROTOCOL=TCP) (HOST=hostname) (PORT=1521)) #<-- *1
(CONNECT_DATA= (SID=MV713)) #<-- Use YOUR MTS_SERVICE
)
# -----------------------------------------------------------------------