RE: Multiple Listener

From: Sam Chakkanat <cvsam_at_cox.net>
Date: Wed, 29 Nov 2006 08:31:17 -0800
Message-ID: <002701c713d3$cb75f140$6d01a8c0@IBM839YQP>

You will come across having single listener with multiple Oracle Home when business needs "Four" or "Five"
nine SLA's. In those case you're a&& will be on fire if you took down a listener and 1000's of transactions clogged on your other system.

Evaluated case by case, we cannot completely rule out an Oracle Home maintenance and that's
the general "Best Practice" from Oracle. With RAC of course, you could have a rolling upgrade, patch maintenance schedule. I don't know about the business case here. And absolutely, you could always have a single listener for all Oracle Homes, based on business. My comment was based on larger clients and general best practices.

About processing and memory - What do you give weigh? Your customers or 10 MB of memory?

Sam

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F (LABOR) Sent: Wednesday, November 29, 2006 8:17 AM To: breitliw_at_centrexcc.com; smishra_97_at_yahoo.com Cc: oracle-l_at_freelists.org
Subject: RE: Multiple Listener

I agree with Wolfgang. One listener for the server. The comment about Oracle Home maintenance is weak. We do maintenance on an Oracle home so infrequently, that this is not an issue. And you can always start up another listener from the other home temporarily if you need to. Running three listeners is a waste of processing and memory (unless you have a specific business need to do so).

I run the most recent Oracle Home listener on the server that I can. So in your case, use the 10.2 listener.

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling Sent: Wednesday, November 29, 2006 10:54 AM To: smishra_97_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: Multiple Listener

You can use the 10.2 listener to service all databases. Listeners are backward compatible. You only need to run 1 listener of the same version as your "highest" Oracle version database.

At 08:23 AM 11/29/2006, Sanjay Mishra wrote:
>I have three Oracle software in one server 8.06, 817 and 10.2.0.2 and
>each one is having one instance running on the server. Do I need to run
>three listener for all three Database separately on 3 different Port or
>there is any way that I can use one Listener to take care of all Client
>request.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 29 2006 - 10:31:17 CST