Re: ORA-12520 (8i MTS)

From: Achille Carette <achyl_at_infonie.be>
Date: Wed, 11 Apr 2001 17:51:55 +0200
Message-ID: <3ad47de6$0$9722$73bec57d@news.be.uu.net>

I (finally) found the solution. The mts_dispatcher seems to be wrong in the configuration i've used.
A correct value is :

(ADDRESS=(PROTOCOL=tcp)(HOST=myMachineName)(PORT=2211))

Witch permits to connect using such an entry in TNSNames.ora

ORCL_MyMachineName_SHARED =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MyMachineName)(PORT = 2211))     )
    (CONNECT_DATA =

      (SERVER = SHARED)
      (SERVICE_NAME = ORCL.MyMachineName.MyDomain)

    )
  )

"Achille Carette" <achyl_at_infonie.be> wrote in message news:3ad45b36$0$15657$73bec57d_at_news.be.uu.net...
> I'm trying to run an Oracle 8.1.6 server (on Win NT 4) in Multi-threaded
> server mode.

>

> I've added the following parameters in the initialization file

>


> mts_dispatchers="(address=(protocol=tcp)(host=myMachineName))"

> mts_max_dispatchers = 2

> mts_servers = 1
> mts_max_servers = 10

>

> When trying to connect from a client, i'm getting the following

>


>     ORA-12520: TNS:listener could not find available handler for requested

> type of server

>

> I cannot find this error in the "Oracle 8i Error Messages Guide"

>
>

> Does anybody have an idea ?

>
> Received on Wed Apr 11 2001 - 10:51:55 CDT