> 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