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

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 Received on Thu Mar 02 2006 - 16:41:24 CST