MTS on 8.1.5!

From: Man Yeung <yngm_at_hotmail.com>
Date: Tue, 21 Sep 1999 01:49:18 +0800
Message-ID: <37E6739E.A95639D0@hotmail.com>

Hi,

I have followed the instruction to configurate the MTS on winnt 4.0 . However when I connect the server using sql+, it only can connect as dedicated server even dispatcher exists.

When I issue lsnrctl service, following message appear,

SNRCTL for 32-bit Windows: Version 8.1.5.0.0 - Production on 21-SEP-99 01:45:26

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))) Services Summary...
  HOME has 2 service handler(s)
    DEDICATED SERVER established:6 refused:0       LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready

      D000 <machine: MY_COMPUTER, pid: 175>


      (ADDRESS=(PROTOCOL=tcp)(HOST=my_computer)(PORT=1030))


      Presentation: oracle.aurora.server.SGiopServer

PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0 LOCAL SERVER
The command completed successfully

However, when I connect to the database, only dedicated server can be used. i.e.

SQL>      select username, program, server from v$session
  2                     where audsid=userenv('sessionid');

USERNAME                       PROGRAM
------------------------------
--------------------------------------------------------

SERVER

SCOTT                          SQLPLUSW.EXE

DEDICATED Following is my tnsname.ora

# D:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

HOME =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = my_computer)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = HOME)

    )
  )

Please help.

Man Received on Mon Sep 20 1999 - 12:49:18 CDT