Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Multiple Listeners

Re: Multiple Listeners

From: Hemant K Chitale <>
Date: Thu, 17 Oct 2002 07:39:55 -0800
Message-ID: <>

On most servers I have only one database on the node.

Where I do have multiple databases, I have seperate ORACLE_HOMEs. Where I have
seperate ORACLE_HOMEs, I have seperate Listeners.
There's really not much of an effort in managing multiple listeners -- after all
you have to issue a seperate sqlplus command for each database [and also
from a seperate ORACLE_HOME each time !] , you can also issue a seperate
"lsnrctl start <listenername>" command.

I could be running, and on the same box.  When applying
 a patchset to upgrade to or for one database, I do not want to have
to stop access to the other databases.  Therefore, each database has it's own listener.
Also, try _not_ to use 1521 as the listener port so that no database auto-registers
with a listener.


At 04:04 AM 17-10-02 -0800, you wrote:

There has been much discussion regarding single or multiple listeners and there seems to be a split between those who advocate one method over the other.

I am currently working at a site with a large number of systems/databases.


They are well organised and one of the standards that is in place is to have a listener per database with the same name as the database.

The lowest port will be 1526 to avoid any issues with auto registration on port 1521.


The whole concept works very well in my experience; the small overhead on the server is outweighed by the ability to stop a listener individually without affecting any other service.



Hemant K Chitale
My web site page is :

-- Please see the official ORACLE-L FAQ: -- Author: Hemant K Chitale INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 17 2002 - 10:39:55 CDT

Original text of this message