Monday, September 8, 2008

TNSNAMES.ORA

TNS (Transparent Network Substrate) . TNSNAMES.ORA is a configuration file that defines databases addresses for establishing connections to them. This file normally resides in the ORACLE HOME\NETWORK\ADMIN directory.
=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = )(Port = ))
)
(CONNECT_DATA =
(SERVICE_NAME = )
)
)
The TNSNAMES.ORA files is located on both client and server systems.

No comments: