add local_listener="ADDRESS=(protocol=tcp)(host=<u r hostname>)(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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Syed Jaffar Hussain
> Sent: Wednesday, March 03, 2004 3:59 PM
> To: oracle-l_at_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_at_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
-----------------------------------------------------------------
Received on Wed Mar 03 2004 - 04:57:41 CST
