SQLnet - Setting up TNSNAMES and LISTENER

From: Stan Novinsky <stan_novinsky_at_jhuapl.edu>
Date: Wed, 03 Nov 1999 13:26:04 -0500
Message-ID: <38207E3C.434AEBF6@jhuapl.edu>

I want to set up SQLnet 2.0 so that TCP/IP is used. Currently, DECnet is used as the transport.

Are the changes made to the TNSNAMES and LISTENER files (defined below ) correct so that
TCP/IP is used instead of DECnet ?

The configurations for the Server and Client are as follows.

Server:

AS8400 (Nodname = HOST6)
Oracle 7.1 Database (DB name = DB1)
OpenVMS 6.2
Oracle Listener

################
# Filename......: listener.ora
# Name..........: host6.world

# Date..........:

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

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= HOST6_DB1.WORLD)


        )
        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= DB1)


        )
        (ADDRESS =


          (PROTOCOL = TCP)


          (HOST = HOST6.WORLD)


          (PORT = 1521)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = DB1)
      (PROGRAM = orasrv_net2.com)
      (TIMEOUT = 0)

    )
  )

Client:

VAX7610
Oracle 7.1
OpenVMS 6.2

################
# Filename......: tnsnames.ora
# Name..........: nodename.world

# Date..........:

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

HOST6_db1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = world)


          (PROTOCOL = TCP)


          (Host = HOST6)


          (Port = 1521)


        )

    )
    (CONNECT_DATA =
       (SID = DB1)
    )
  ) Received on Wed Nov 03 1999 - 12:26:04 CST