RE: Server IP Address and Listener Port

From: freek D'Hooge <freek.dhooge_at_uptime.be>
Date: Wed, 10 Sep 2008 22:54:25 +0200
Message-ID: <000a01c91387$6aca10f0$0b02a8c0@iconos.be>

Yong,

That is not correct.
If the local_listener parameter is not used, you could still have used static registration in you listener configuration to be able to use a non default port.

Regards,  

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yong Huang
Sent: woensdag 10 september 2008 19:28
To: oracle-l_at_freelists.org
Subject: Re: Server IP Address and Listener Port

> I don't know about listener port... I think there could be a way to do
that without parsing...

If local_listener (from v$parameter) is null, the port is 1521. Otherwise, parse the string.

Yong Huang

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 10 2008 - 15:54:25 CDT

Original text of this message