"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<40b346fc$0$1587$afc38c87_at_news.optusnet.com.au>...
> "yls177" <yls177_at_hotmail.com> wrote in message
> news:c06e4d68.0405250459.7f576cff_at_posting.google.com...
> > hi, is it possible for 2 sids in a single box sharing a single port
> > number in listener.ora?
>
> I'm not even sure what that question means, so I'll have to speculate and
> interpret.
>
> You have a single PC ("box") hosting two separate instances ("sids") and
> hence two separate databases. You want to know (I think) whether both
> instances can be accessed via a single listener, listening on a single port.
>
> To which the answer is 'yes', and it's designed to be done that way. The
> listener is just a process, and in the listener.ora you configure which port
> it listens on for client connections. The number of instances for which the
> listener is to handle connection requests is irrelevant to how you configure
> the port the listener will listen on.
>
> In the listener.ora, you may specify a SID_LIST section, where you
> statically declare the instances to which the listener will pass on client
> connection requests received. There can be any number of instances listed
> there.
>
> In 8i and above, you don't even need the SID_LIST section, since each
> instance is designed to register itself with a listener using tcp/ip running
> on port 1521 automatically. If you therefore start your two instances, you
> will discover that the listener is automatically aware of both of them.
>
> If the listener is configured for non-1521 operation, then the instances
> need to know where to find the non-standard listener, and that is the job of
> the local_listener initialisation parameter.
>
> At which point, you are better off heading over to http://tahiti.oracle.com
> and doing some research on Oracle Net Services.
>
> But if your question was what I thought it was, and all you are after is the
> short answer, then 'yes, a listener can do duty for any number of instances,
> and all whilst listening on the one port'.
>
> Regards
> HJR
thanks once again..
cheers
Received on Tue May 25 2004 - 22:59:56 CDT
