Re: Listener Question

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 2 May 2002 12:33:20 +1000
Message-ID: <aaq8iq$eul$1@lust.ihug.co.nz>

Not true, actually. Either SMON or PMON (and I forget which) regularly checks that the Instance is registered with the Instance. Hence an Instance which starts before the Listener can still register with that Listener.

The only reason for specifying the SID_LIST is, as someone else suggested, the presence of non-8i instances which don't know about automatic registration.

Regards
HJR "Cameron Hutchison" <camh_at_zip.com.au> wrote in message news:pan.2002.05.02.01.39.30.244679.4300_at_zip.com.au...
> On Wed, 01 May 2002 22:19:04 +1000, Igor Laletin wrote:
>
> > "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> > news:<G_Jz8.40$su6.66_at_news.oracle.com>...
> >
> > <snip>
> >
> >> First, there's absolutely no reason to have a SID_LIST in any 8.1
> >> listener.ora file.
> >
> > Maybe two. First, you still need SID_LIST for pre-8i instances in 8.1
> > listener.ora if the listener serves them. Second, if you use OEM -
> > intelligent agent needs this info to discover instances.
>
> A third reason is that if you restart the listener, then it does not
> know about the already running instances. Only if you start an instance
> after the listener does the listener automatically find out about it.
>
> This is only in my experience. I'd love to be told I'm wrong and given
> a method to work around this.
>
> CHeers
Received on Wed May 01 2002 - 21:33:20 CDT