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@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yong Huang Sent: woensdag 10 september 2008 19:28 To: oracle-l@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l