Re: Problem with MTS

> >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

That was not the problem. With a little testing I found the it: In my init.ora I had a service_names and a db_domain, in my tnsnames.ora I used only the service_name not the db_domain. To illustrate it:

init.ora:

service_names = BLAH
db_domain = foo.gov

tnsnames.ora:

...

   (SERVICE_NAME = BLAH)
...

I changed SERVICE_NAMES to BLAH.foo.gov in init.ora and tnsnames.ora and now I get my shared server connection.

Thank you anyway,

Knut Received on Wed Apr 10 2002 - 04:07:17 CDT