Re: MTS problems with NT 8.1.7.4 Standard Edition

"Paul Drake" <drak0nian_at_yahoo.com> wrote in message
> > 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.

You make it sound like it's either/or, but it's not. Dynamic registration will work even if there is a static SID_LIST set. In point of fact, since static declarations are required for the intelligent agent to 'discover' the services, if you were hoping to administer an MTS database via OEM, and yet also have dispatcher load-balancing, then both dynamic registration AND static declarations are required.

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

And provided you are using TCP/IP, *and* provided your listener is called 'LISTENER'.
> 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)

Not necessary (see above). However, I would agree that a bare-bones Listener.ora with no SID_LIST would at least make it easier to determine whether dynamic registration is working. But once it is, the SID_LIST should be added back in if the original poster wants to use OEM.

Regards
HJR
>
> 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 Wed May 14 2003 - 07:35:36 CDT