From oracle-l-bounce@freelists.org Mon Mar 21 14:41:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2LKfnBN029832 for ; Mon, 21 Mar 2005 14:41:49 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2LKfmem029828 for ; Mon, 21 Mar 2005 14:41:48 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9FA608834D; Mon, 21 Mar 2005 14:40:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06105-03; Mon, 21 Mar 2005 14:40:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 14C2D87B54; Mon, 21 Mar 2005 14:40:02 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Any way to run more than listener on the same port? Date: Mon, 21 Mar 2005 14:39:56 -0500 Message-ID: <9E0E38DB4ACFAA4593AD6C4A45C9D5F009CF72F4@LOUMLVEM01.e2k.ad.ge.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Any way to run more than listener on the same port? Thread-Index: AcUuTW/GAR9kz4tSRnWUcrs+OFpXPgAACD4Q From: "Adams, Matthew (GE Consumer & Industrial)" To: X-OriginalArrivalTime: 21 Mar 2005 19:39:56.0294 (UTC) FILETIME=[C2A5EA60:01C52E4D] X-archive-position: 17537 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: MATT.ADAMS@GE.COM Precedence: normal Reply-To: MATT.ADAMS@GE.COM X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: I haven't got the faintest idea. Try it and let me know. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of JayMiller@TDWaterhouse.com Sent: Monday, March 21, 2005 2:33 PM To: oracle-l@freelists.org Subject: RE: Any way to run more than listener on the same port? That was foolish of me. I'm on Solaris 2.9, Oracle 9.2 Could this be made to work in that environment? Thanks, Jay=20 -----Original Message----- From: Adams, Matthew (GE Consumer & Industrial) = [mailto:MATT.ADAMS@GE.COM]=20 Sent: Monday, March 21, 2005 2:11 PM To: Miller, Jay; oracle-l@freelists.org Subject: RE: Any way to run more than listener on the same port? This actually can work real nice if set up correctly. The following discussion is relevant to HP and may or=20 may not apply the architecture you are using. On hp, when using service guard for clustering, units of=20 work called packages are allowed to failover between servers. Each package has a distinct name and IP address. When you are running many packages on a server (each with their own set of databases), you can either have a single listener that listens all the time for DBs that on that server (dynamicall registering and de-registering as they enter or leave a particular cluster) or you can set up a listener for each package, which listens on the IP = address of the package, not the IP address of the server. All of these = listeners can listen on port 1521 for their own IP address with interfering with = each other There is one VERY important caveat to this. If you are running = idividual listeners on the IP address of the packages, you CANNOT run an additional listener that listens on the server IP address. I'm not sure how it works under the covers, = but it=20 appears that if you run a listener configured to listen on the IP = address of the=20 server, it does a 'lanscan' or something equivalent, finds out all the = IP address being served by the machine (even the package IP address) and will start listener to=20 port 1521 on EVERY ip address served by the machine. This interferes = with the package specific listeners. This behavior was observed on 8.1.7 and 9.2.0 Therefore, you limit the listeners to ONLY listening on package address = and not on the server address. This means, essentially, that all databases have to = be in a package and have their own listener (at least if they are going to be = on a machine in an HP service guard cluster) -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of JayMiller@TDWaterhouse.com Sent: Monday, March 21, 2005 1:18 PM To: oracle-l@freelists.org Subject: Any way to run more than listener on the same port? Hi, For portability reasons our Unix SAs would like us to run one listener / instance on the same port of each server. While I have no problem setting up one listener for two instances or two listeners on different ports I had been under the impression (born out = by preliminary experimentation) that you couldn't have more than one = listener on the same port. The Unix SAs say that since they've set up separate Virtual IP Addresses = for each instance we should be able to get it to work. Anyone have any experience with this? Is it possible? Thanks, Jay Miller -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l