Re: listener

From: Niall Litchfield <>
Date: Wed, 13 May 2015 18:47:46 +0100
Message-ID: <>

No such thing as stupid questions. Just those you don't know the answer to yet. Listener configuration is controlled by the listener.ora file. If no name is given to the parameters then they apply to the default listener (imaginatively named LISTENER). Listener operation (controlled eventually) by lsnrctl also operates on this listener by default. Passing a listener name, or using set current _ listener will change the listener you are working with.

If you are working with clusterware then the tools change but the same principle applies.

You can also use netmgr/netca to manage this.

The listener parameters in init.ora point to a local and or remote listener that the database should register its services with.

I'm unclear why these days you would have a listener entry in tnsnames at all. Likely for use with the parameter file parameters.

This is documented in the fine manuals but I'm on a train so can't give chapter and verse.
On 13 May 2015 18:29, "Zelli, Brian" <> wrote:

> Ok, really stupid question. How do I know the exact name of my
> listener? In my init.ora? in my tnsnames.ora? When I grep for it in unix?
> They all seem to be showing me something different……..
> Brian
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

Received on Wed May 13 2015 - 19:47:46 CEST

Original text of this message