From oracle-l-bounce@freelists.org Wed Mar 3 05:04:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23B4t925387 for ; Wed, 3 Mar 2004 05:04:55 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23B4so25382 for ; Wed, 3 Mar 2004 05:04:55 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D5B6394E14; Wed, 3 Mar 2004 06:05:22 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 06:04:13 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from bristol24.audit-commission.gov.uk (mailhost.audit-commission.gov.uk [193.128.236.210]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 20E87394D49 for ; Wed, 3 Mar 2004 06:04:10 -0500 (EST) Received: from bristol21.bristol.ac (unverified) by bristol24.audit-commission.gov.uk (Content Technologies SMTPRS 4.3.6) with SMTP id for ; Wed, 3 Mar 2004 11:07:59 +0000 Received: from AC-Message_Server by bristol21.bristol.ac with Novell_GroupWise; Wed, 03 Mar 2004 10:57:06 +0000 Message-Id: X-Mailer: Novell GroupWise Internet Agent 5.5.5.1 Date: Wed, 03 Mar 2004 10:56:48 +0000 From: "Niall Litchfield" To: Subject: RE: listener ports Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline X-archive-position: 145 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: n-litchfield@audit-commission.gov.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Hi Is it possible to post the listener.ora (with hostnames blanked out of course). Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805 > -----Original Message----- > From: sjaffarhussain@hotmail.com > Sent: 03 March 2004 10:28 > To: oracle-l@freelists.org; sjaffarhussain@hotmail.com > Subject: listener ports > > > Hi List, > > I have two databases on my server. I want one of the database > to listen on > port 1522 instead of 1521. I have changed the parameter value > in listener.ora > file, but, when I try to connect from the client machine, I > get the following > error. I check the tnsname sid and hostname they are fine. > TNS:listener could not resolve SID given in connect descriptor > > Rgds > Jaffar > > ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------