From oracle-l-bounce@freelists.org Wed Mar 3 04:57:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23AveG23095 for ; Wed, 3 Mar 2004 04:57:40 -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 i23Aveo23089 for ; Wed, 3 Mar 2004 04:57:40 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8AB24394D60; Wed, 3 Mar 2004 05:58:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 05:57:03 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.magma.co.in (unknown [202.144.98.235]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 54824394C6F for ; Wed, 3 Mar 2004 05:56:59 -0500 (EST) Received: from magma.co.in (localhost.localdomain [127.0.0.1]) by mail.magma.co.in (8.12.5/8.12.5) with SMTP id i23BCA9C029776 for ; Wed, 3 Mar 2004 16:42:12 +0530 From: Database Admin Received: from 172.16.7.252 (proxying for 172.16.7.251) (SquirrelMail authenticated user dba) by www.magma.co.in with HTTP; Wed, 3 Mar 2004 16:42:19 +0530 (IST) Message-ID: <32425.172.16.7.252.1078312339.squirrel@www.magma.co.in> Date: Wed, 3 Mar 2004 16:42:19 +0530 (IST) Subject: RE: listener ports To: In-Reply-To: References: X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 143 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dba@magma.co.in Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l add local_listener="ADDRESS=(protocol=tcp)(host=)(port=1522))" then bounce the db including lsnrctl.I dont quite remember if the bounce is mandatory.Are you trying to load Oracle 9iAS. Deep > have you reloaded/restarted the listener after the changes in ur server. > :-) > > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Syed Jaffar Hussain > Sent: Wednesday, March 03, 2004 3:59 PM > To: oracle-l@freelists.org > 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 ---------------------------------------------------------------- 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 -----------------------------------------------------------------