MTS

From: Alan <athiery_at_ais-nantes.fr>
Date: Tue, 16 Jul 2002 08:14:54 +0200
Message-ID: <3d33b9a0$0$10538$626a54ce@news.free.fr>

On an Oracle 8.1.7 Windows NT 4, I dont succed to access on an instance via MTS

I have

• in the init.ora :

mts_dispatchers = "(protocol=TCP)(tick=15)(pool=true)(DISPATCHERS=2)" LOCAL_LISTENER = "(ADDRESS = (PROTOCOL=TCP)(HOST=pcat)(PORT=1521))"

• in the view v$dispacher i obtain

NAME NETWORK PADDR STATUS ACCEPT MESSAGES BYTES BREAKS OWNED CREATED IDLE BUSY LISTENER CONF_INDX
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=pcat)(PORT=1515)) 2B7D9DC4 WAIT YES 0 0 0 0 0 202867 0 0 0
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=pcat)(PORT=1517)) 2B7DA0EC WAIT YES 0 0 0 0 0 202838 0 0 0

• i force connection via MTS in the tnsnames.ora

ALAIN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = pcat)(PORT = 1521))     )
    (CONNECT_DATA =

      (SID = alain)
      (SRVR = SHARED)

    )
  )

But when i try to access via sqlplus i obtain an ORA-12519 error

Why ???

ALAN Received on Tue Jul 16 2002 - 01:14:54 CDT