RE: Server IP Address and Listener Port
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-lReceived on Wed Sep 10 2008 - 15:54:25 CDT