Re: Docs for tnsnames.ora

Hi,

Oracle Docs:

Oracle Network Products Getting Started for Windows Platforms  Understanding SQL*Net
 Oracle Network Manager Administrator's Guide  Oracle Network Products Troubleshooting Guide  Oracle Names Administrator's Guide
 Oracle Advanced Networking Option Administrator's Guide

Basic info:
Understanding the TNSNAMES.ORA File

The TNSNAMES.ORA file is used by clients and distributed database servers to identify potential server destinations.

A sample file is shown in Figure E-1:

################

# Filename......: tnsnames.ora

# Name..........: LOCAL_REGION.world

# Date..........: 04-DEC-96 13:50:40

################

<service_name>.world = <---world is the domain name

  (DESCRIPTION =     (ADDRESS_LIST =         (ADDRESS = <---listener address

(COMMUNITY = TCP.world)

(PROTOCOL = TCP)

(HOST = <server _name>) <---or, use IP address of NT server

(PORT = 1521) <---must match port in LISTENER.ORA file

        )

    )

    (CONNECT_DATA =       (SID = <SID>)) <---database name, default is ORCL

      (SOURCE_ROUTE=yes)

    )

  )

Detailed info:

Oracle Network Products Getting Started for Windows Platforms, App E: Understanding TNSNAMES.ORA

(Version 7.3.X)

Regards

Hakan

DET wrote:

> Are there any docs for the internal format of tnsnames.ora? The oracle > manuals don't seem to tell you much beyond "hands off". Received on Mon Aug 10 1998 - 16:47:17 CDT