Re: Listener problem on 10g - db registration on non-default listeners??

BD wrote:
> Hi all.
>
> I'm on Win2K SP4, running 10Gr2.
>
> I have a new database, and a default listener. I wish to create a
> second and third listener, listening on different ports.
>
> I initially tried manually placing the entries in the listener.ora file
> and starting the listeners with lsnrctl; they started, but kept
> returning 'the listener supports no services'.
>
> So I removed those manual entries, and ensured that the default 1821
> listener still functioned as expected. No problem there. I can hit the
> db from a client machine over 1821.
>
> I tried running netca to create the new listeners - seems to be just a
> frontend for the manual process, as I'd left lsnrctl running in a
> separate window and saw it churning away as I clicked through netca.
> The listeners started, and I see them in the Services Applet, listing
> as 'started' there as well.
>
> Same net effect. 'supports no services' on the non-default listeners.
>
> I also tried an 'alter system register' from within the database. No
> luck. And, I've waited almost 30 minutes for auto-registration.
>
> Clearly I'm missing something, but the rules for db autoregistration
> seem to have changed over the versions. ;-))
>
> Can anyone see what I'm missing?
>
> Thanks!!
>
> BD

search for the init.ora parameter "local_listener". you'll need to define a connect descriptor for each listener in the tnsnames.ora file and refer to it in the init.ora (or spfile).

-bdbafh Received on Thu Mar 02 2006 - 17:09:40 CST