Oracle Database Administration: The Essential Refe

Files Created by Network Manager

When the network is specified to Network Manager (or a change is made to an existing network definition), a set of SQL*Net configuration files is created on the Windows workstation. Individual directories are created for each client and server node defined in the network. In each of these directories, you’ll find the files shown in Table 5.2.

Table 5-2. Files Generated by Network Manager

File	Distributed to	Description
tnsnames.ora	Client (and server when using database links or distributed processing)	Contains all service names for all databases and interchanges on the network.
sqlnet.ora	Client	Contains parameters to control SQL*Net diagnostics (logging and tracing).
tnsnav.ora	Client	Contains a list of local communities in the client profile or node. This file also contains information to identify the location of interchanges for connections across communities.
listener.ora	Server	Contains information unique to each server specifying how SQL*Net should configure and operate the TNS (Transparent Network Substrate) listener on the server.
intchg.ora (Oracle7)	MultiProtocol Interchange	Contains parameters to control the operation of a particular MultiProtocol Interchange.
tnsnet.ora	MultiProtocol Interchange	Contains information to describe the relationships of all the communities and interchanges in the network.
cman.ora (Oracle8)	Connection Manager	Contains parameters to control the operation of the Oracle Connection ...