Oracle7 Administrator's Reference for UNIX

Sample Network Manager Files

A simple client/server system is shown in Figure 9 - 5.

Figure 9 - 5. Sample Client/Server Network

The configuration files created automatically by Network Manager are in three groups: one set for the server (hostname 'GREENWOOD'), and one set on each of the clients. The sample files generated are listed in the following sections.

Server-side Configuration Files

The listener.ora File

################
# Filename......: listener.ora
# Name..........: GREENWOOD.world
# Date..........: 14-FEB-96 15:47:51
################
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= GREEN.world)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= GREEN)
        )
        (ADDRESS = 
          (COMMUNITY = tcpcomm.world)
          (PROTOCOL = TCP)
          (Host = GREENWOOD)
          (Port = 1526)
        )
        (ADDRESS = 
          (COMMUNITY = deccomm.world)
          (PROTOCOL = DECNet)
          (Host = GREENWOOD)
          (Object = LSNR-1)
        )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = GREEN)
      (ORACLE_HOME = /oracle/green)
      (PRESPAWN_MAX = 10)
    )
  )

The sqlnet.ora File

################
# Filename......: sqlnet.ora
# Name..........: GREENWOOD.world
# Date..........: 14-FEB-96 15:47:51
################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
SQLNET.CRYPTO_SEED = "-864046921-864011456"
SQLNET.AUTHENTICATION_SERVICES = (ALL)

The tnsnames.ora File

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 14-FEB-96 15:47:51
################
G_TCP.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcpcomm.world)
          (PROTOCOL = TCP)
          (Host = GREENWOOD)
          (Port = 1526)
        )
    )
    (CONNECT_DATA =
       (SID = GREEN)
       (GLOBAL_NAME = G_TCP.world)
    )
  )
G_DEC.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = deccomm.world)
          (PROTOCOL = DECNet)
          (Host = GREENWOOD)
          (Object = LSNR-1)
        )
    )
    (CONNECT_DATA =
       (SID = GREEN)
       (GLOBAL_NAME = G_DEC.world)
    )
  )

The tnsnav.ora File

################
# Filename......: tnsnav.ora
# Name..........: GREENWOOD.world
# Date..........: 14-FEB-96 15:47:51
################
LOCAL_COMMUNITIES =
  (COMMUNITY_LIST =
    (COMMUNITY = tcpcomm.world)
    (COMMUNITY = deccomm.world)
  )

TCP/IP Client Configuration Files

The sqlnet.ora File

################
# Filename......: sqlnet.ora
# Name..........: tcpcomm.world
# Date..........: 14-FEB-96 15:47:51
################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
SQLNET.CRYPTO_SEED = "-864046921-864011456"
SQLNET.AUTHENTICATION_SERVICES = (ALL)

The tnsnames.ora File

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 14-FEB-96 15:47:51
################
GREEN.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcpcomm.world)
          (PROTOCOL = TCP)
          (Host = GREENWOOD)
          (Port = 1526)
        )
    )
    (CONNECT_DATA =
       (SID = GREEN)
       (GLOBAL_NAME = GREEN.world)
    )
  )

The tnsnav.ora File

################
# Filename......: tnsnav.ora
# Name..........: tcpcomm.world
# Date..........: 14-FEB-96 15:47:51
################
LOCAL_COMMUNITIES =
  (COMMUNITY_LIST =
    (COMMUNITY = tcpcomm.world)
  )

DECnet Client Configuration Files

The sqlnet.ora File

################
# Filename......: sqlnet.ora
# Name..........: deccomm.world
# Date..........: 14-FEB-96 15:47:51
################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
SQLNET.CRYPTO_SEED = "-864046921-864011456"
SQLNET.AUTHENTICATION_SERVICES = (ALL)

The tnsnames.ora File

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 14-FEB-96 15:47:51
################
G_DEC.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = deccomm.world)
          (PROTOCOL = DECNet)
          (Host = GREENWOOD)
          (Object = LSNR-1)
        )
    )
    (CONNECT_DATA =
       (SID = GREEN)
       (GLOBAL_NAME = G_DEC.world)
    )
  )

The tnsnav.ora File

################
# Filename......: tnsnav.ora
# Name..........: deccomm.world
# Date..........: 14-FEB-96 15:47:51
################
LOCAL_COMMUNITIES =
  (COMMUNITY_LIST =
    (COMMUNITY = deccomm.world)
  )