Re: one port for 2 database in listener

"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 Received on Tue May 25 2004 - 08:15:51 CDT