Re: MTS problems with NT 8.1.7.4 Standard Edition

form999v_at_hotmail.com (Dom) wrote in message news:<52400398.0305130302.31dda160_at_posting.google.com>...
> After installing Oracle on a new machine I can't seem to get MTS
> working - I've added the relevant lines to init.ora and although
> querying several v$views would suggest it's working, I can't connect
> when server=shared is specified in tnsnames.ora (I get ORA-12510:
> TNS:listener could not find available handler for requested type of
> server), no problems if its commented out. Any suggestions would be
> appreciated (more details below, sorry if the output of the sql is
> hard to read) and I know its unusual to use the ip address but this is
> a cluster environment with fail over (a second machine picks up the
> same ip address in the event of failure).
>
> Thanks in advance
>
> Dom

Dom,

You were using static registration - by using a verbose list in the listener.ora. If you were to use dynamic registration, each instance registers with the listener at startup, in which case the dispatchers would be registered with the listener.

I'd recommend the following - but this is only off of a hunch:

1. use the parameter local_listener to describe where the listener(s) can be contacted. If you are only using 1 listener on port 1521, this parameter does not have to be explicitly set.
2. remove all of the SID_LIST entries from the listener.ora - which will enable dynamic registration (keep around your EXTPROC entires if they are in use)
3. stop and restart the listener service via:

C:\> net stop oracleorahome81tnslistener C:\> net start oracleorahome81tnslistener

use lsnrctl , SET DISPLAYMODE VERBOSE and examine the listener logs to verify that each instance registers with the listener(s) at startup.

If this doesn't get it - email me backchannel.

hth,

Paul Received on Tue May 13 2003 - 18:27:20 CDT