Configuring SQL*Net for MTS

From: Lynda Sohl <lyndas_at_email.mot.com>
Date: Tue, 9 Aug 1994 19:53:57 GMT
Message-ID: <1994Aug9.195357.18485_at_lmpsbbs.comm.mot.com>

I hope someone can help me here. I am trying to configure SQL*Net V2 (the tnslsnr) to use the Multithreaded server. I want remote users to connect through TCP/IP and local users to connect through IPC. I have the SQL*Net connections going but I can not seem to get Oracle to make use of the dispatchers. This happens no matter how I try to connect through SQL*Net.

This is my listener.ora:

###########
# FILENAME: listener.ora
# TIME....: 94-08-08 04:16:03
# NETWORK.: COMPSYS
# NODE....: COMPDEV1
# SERVICE.: LSTTCP
###########

LSTTCP =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= listener)


        )
        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= v7test)


        )
        (ADDRESS = 


          (PROTOCOL = TCP)

          (HOST = compdev1)


          (PORT = 1521)


        )

  )
STARTUP_WAIT_TIME_LSTTCP = 0
CONNECT_TIMEOUT_LSTTCP = 10

LOG_DIRECTORY_LSTTCP = /oracle7/network/log
LOG_FILE_LSTTCP = compsys
SID_LIST_LSTTCP =

  (SID_LIST =
    (SID_DESC =

      (SID_NAME = v7test)
      (ORACLE_HOME=/oracle7)

    )
  )
PASSWORDS_LSTTCP = (TRIX)
TRACE_LEVEL_LSTTCP = OFF This is my tnsnames.ora:

###########
# FILENAME: tnsnames.ora
# TIME....: 94-08-08 04:05:47
# NETWORK.: COMPSYS
# NODE....: COMPDEV1
# SERVICE.: TCPCOM
###########

listener =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = LOCAL)

          (PROTOCOL = TCP)

          (HOST = compdev1)


          (PORT = 1521)


        )

    )
    (CONNECT_DATA =
      (SID = v7test)
    )
  )

###########V1 CONNECT STRINGS########### v7test = T:compdev1:v7test

These are the MTS init.ora parameters I am using:

mts_dispatchers                 = "ipc, 1"
mts_max_dispatchers             = 10
mts_service                     = v7test
mts_servers                     = 1
mts_max_servers                 = 10
mts_listener_address            = "(ADDRESS=(PROTOCOL=ipc) (KEY=v7test))"

To connect I am using a string such as:
sqlplus /_at_v7test
or
sqlplus /_at_listener

Any ideas what I may be doing wrong?
You can email me at ccof50_at_email.mot.com or post me back here THANKS! Lynda Sohl
Motorola, Inc. - Components Division
DBA
email: ccof50_at_email.mot.com Received on Tue Aug 09 1994 - 21:53:57 CEST