Re: Problem with MTS

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 09 Apr 2002 18:12:32 +0200
Message-ID: <9m46buscq8lvb10765ncac7ukr7gk6dsi3@4ax.com>

On Tue, 09 Apr 2002 13:51:41 +0200, Knut Talman <knut.talman_at_mytoys.de> wrote:

>Hi,
>
>I just created a database to test MTS (Linux, Oracle 8.1.7.2.0). I added
>mts_dispatchers="(protocol=TCP)(dispatchers=4)"
>to init.ora. After bouncing the database and starting the listener (no errors) I
>run lsnrctl service and see that my instance has 1 service handler (which is
>dedicated server) and 5 service handlers (4 dispatchers and PLSExtProc).
>When I try to connect using my tnsnames.ora entry (no specification of dedicated
>or shared server) I get a dedicated server for my session. When I add a
>SERVER=SHARED to my tnsnames.ora I receive a ORA-12520: TNS:listener could not
>find available handler for requested type of server. Additionally the sqlnet.log
>file shows a ns main err code of 12564 (TNS:connection refused).
>Does anyone have any idea what happens here?
>
>Thank you in advance,
>
>Knut

The dispatchers are using a random port number which is not identical to the port number defined in tnsnames.ora

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 09 2002 - 11:12:32 CDT