Re: Server IP Address and Listener Port

From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 10 Sep 2008 10:28:26 -0700 (PDT)
Message-ID: <379186.26485.qm@web80604.mail.mud.yahoo.com>

> 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

Received on Wed Sep 10 2008 - 12:28:26 CDT

This message: [ Message body ]
Next message: dba1 mcc: "Crystal report server connect to ORACLE DB setup?"
Previous message: Kevin Lidh: "Re: Finding the checkpoint frequency"
Maybe in reply to: Bala: "Server IP Address and Listener Port"
Next in thread: freek D'Hooge: "RE: Server IP Address and Listener Port"
Reply: freek D'Hooge: "RE: Server IP Address and Listener Port"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message