Re: Listener Question

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

> 8i instances register themselves with the Listener. All
> that's needed is the 'ADDRESS' bit. This seems to be a message which is
> taking a very long time to filter through the general Oracle community.

Yep. I'm still to see a site where it's done after moving to 8i. Looks like many DBAs just don't know about this feature. Actually it's should be expected given the size of 8i.

O7 was rather compact, it was possible to know the product and tools in details. It got a bit worse with O8. And to learn/try everything in 8i someone must invest a very significant amount of time. I think with 9i a specialisation within core DBA functions will become apparent.

Regards,
Igor

> Regards
> HJR
Received on Wed May 01 2002 - 07:19:04 CDT