Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 19461 invoked from network); 2 Apr 2008 04:38:30 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 2 Apr 2008 04:38:29 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EAE74839007; Wed, 2 Apr 2008 05:38:27 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13307-04; Wed, 2 Apr 2008 05:38:27 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D53B838FFA; Wed, 2 Apr 2008 05:38:27 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 02 Apr 2008 05:36:16 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 96D33837F5A for ; Wed, 2 Apr 2008 05:36:16 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12914-06 for ; Wed, 2 Apr 2008 05:36:16 -0400 (EDT) Received: from tachyon.sequestor.lan (82-71-2-186.dsl.in-addr.zen.co.uk [82.71.2.186]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3DF58837D36 for ; Wed, 2 Apr 2008 05:36:13 -0400 (EDT) Received: from localhost (localhost.localdomain [127.0.0.1]) by tachyon.sequestor.lan (Postfix) with ESMTP id A39791F3 for ; Wed, 2 Apr 2008 10:36:12 +0100 (BST) Received: from tachyon.sequestor.lan ([127.0.0.1]) by localhost (tachyon.sequestor.lan [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tUM9EagZ8JTq for ; Wed, 2 Apr 2008 10:36:05 +0100 (BST) Received: from comet.sequestor.lan (comet.sequestor.lan [192.168.0.9]) by tachyon.sequestor.lan (Postfix) with ESMTP id C94D31B3 for ; Wed, 2 Apr 2008 10:36:05 +0100 (BST) Received: by comet.sequestor.lan (Postfix, from userid 1000) id 9D59FC78; Wed, 2 Apr 2008 10:36:05 +0100 (BST) Subject: Multiple listeners (9i/10g) on Windows From: Tony Sequeira To: Oracle List Content-Type: text/plain Organization: Great Holm, Milton Keynes Date: Wed, 02 Apr 2008 09:36:05 +0000 Message-Id: <1207128965.4714.17.camel@comet.sequestor.lan> Mime-Version: 1.0 X-archive-position: 6784 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: tony@sequeira.org.uk Precedence: normal Reply-to: tony@sequeira.org.uk List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Hi, I have a requirement to create a couple of 10g instances on a Win 2003 server. There is already an existing 9i installation and instance, which is supposed to be available while I'm doing my stuff. I have installed 10g. My issue is the listener for 10g. I believe it would be best to use the 10g listener for all the instances on this machine, however, to cause as little disruption as possible, the decision has been made to use the 9i listener for the 9i home, likewise (10g listener) for the 10g home, different ports of course. I have searched Metalink and come up with notes: 151812.1 and 232010.1, which refer to version 9i, 8i and 7. My question is, do I need to create the new listener prior to creating the databases? I believe I do. I'm aware of the local_listener init.ora entry. Do I need it? Any gotchas? I don't think the users would be amused if there was disruption to their access to the 9i instance. -- S. Anthony Sequeira ++ "In matters of principle, stand like a rock; in matters of taste, swim with the current." -- Thomas Jefferson ++ -- http://www.freelists.org/webpage/oracle-l