Problem with MTS

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 09 Apr 2002 13:51:41 +0200
Message-ID: <3CB2D5CD.785F8A06@mytoys.de>

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 Received on Tue Apr 09 2002 - 06:51:41 CDT