Document ID:        29454.1
Subject:            SQL*NET V2 DECNET CONFIGURATION FILE EXAMPLES
Last Modified:      05 March     1996
Author:             PSHIH


SQL*Net V2 DECnet Configuration File Examples
---------------------------------------------

The major problem in getting SQL*Net V2 to work is getting the SQL*Net V2
listener process running. The major cause for not being able to start up
the SQL*Net V2 listener process is improper syntax in one of the SQL*Net V2
configuration files. If the V2 listener process dies immediately after
issuing the LSNRCTL START command, you probably have a syntax error in the
LISTENER.ORA file.

This bulletin provides samples of the three SQL*Net V2 configuration files that
are required for running SQL*Net V2 DECnet.

In the samples below, all items in CAPITAL letters must be changed to match
your specific installation.

Sample TNS_ADMIN:LISTENER.ORA:
------------------------------
listener = (address_list =
                 (address = (protocol=decnet)
                            (node=NODENAME)
                            (object=LISTEN1)))

sid_list_listener = (sid_list=
        (sid_desc=(sid_name=SIDNAME)
        (program='DISK1:[ORACLE7.DB_DBNAME]ORASRV_NETV2.COM')))

trace_level_listener = admin
trace_directory_listener = ora_root:[network.trace]

Sample TNS_ADMIN:TNSNAMES.ORA:
------------------------------
SERVICENAME = (description =
              (address =  (protocol = decnet)
                          (node     = NODENAME)
                          (object   = LISTEN1))
                          (connect_data = (sid=SIDNAME)))

Sample Server Command Procedure DISK1:[ORACLE7.DB_DBNAME]ORASRV_NETV2.COM:
--------------------------------------------------------------------------
$!
$!  Run instance-specific ORAUSER.COM file
$!
$ @DISK1:[ORACLE7.DB_DBNAME]ORAUSER_DBNAME.COM
$!
$!  Define server process image
$!
$  orasrv := $ora_system:srv.exe
$!
$! Start ORACLE SQL*Net server process
$!
$  orasrv "(local=no)"
$  exit

Additional Notes:
-----------------
1) SIDNAME, NODENAME, and LISTEN1 must match in the LISTENER.ORA and
        TNSNAMES.ORA files.
2) The name and location of the server command procedure must match the
        PROGRAM entry in the LISTENER.ORA file.
3) Even though you may not be using it, MAKE SURE THAT YOU SELECT THE
        SQL*Net V2 MAILBOX ADAPTER.
4) If you have multiple services in the TNSNAMES.ORA file, they must be
        seperated by a blank line.

-------------------------------------------------------------------------------
                       ORACLE Worldwide Customer Support