Re: QUESTION: Stop 9i db from auto-registering in listener

From: Ronald Rood <devnull_at_ronr.nl>
Date: Tue, 25 Oct 2005 22:10:52 +0200
Message-ID: <0001HW.BF845DEC00EB533AF0284550@news.individual.net>

On Tue, 25 Oct 2005 20:38:28 +0200, Matthias Hoys wrote (in article <435e7ba7$0$14070$ba620e4c_at_news.skynet.be>):

> 
> <bdbafh_at_gmail.com> wrote in message 
> news:1130196717.446880.233680_at_g44g2000cwa.googlegroups.com...

>> 2 methods:
>>
>> 1. populate the parameter local_listener with a string that does not
>> resolve correctly to a local oracle tns listener
>>
>> 2. set the parameter to disable dynamic registration. Its an underscore
>> parameter, so I won't list it here.
>>
>> Check Metalink - http://metalink.oracle.com
>> How to Disable AutoRegistration of an Instance with the Listener
>> Note:140571.1
>>
>> hth.
>>
>> -bdbafh
>>

> 
> Don't you have to add LOCAL_LISTENER = ... to the init.ora/spfile ?
> 
> Matthias 

Yes, but only when your listener is not on the default port (1521). Using a non default listener port and removing the local_listener parameter could have helped the OP.

With kind regards / met vriendelijke groeten, Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle Received on Tue Oct 25 2005 - 15:10:52 CDT