RE: Simple listener parameter question

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • Date: Sat, 6 Dec 2008 08:30:15 -0500


I think you may be confusing local_listener with the listener definition in the 
listener.ora.  The original poster's question was about the value of the 
local_listener parameter.  local_listener should be set to match the currently 
defined listener on the local host.  If you want to alter what address the 
listener listens on, you need to edit listener.ora and bounce the listener, and 
then update the local_listener parameter to the corresponding value.

From: Dan Norris [dannorris@xxxxxxxxxxxxx]
Sent: Saturday, December 06, 2008 3:41 AM
To: Bobak, Mark
Cc: sxmte@xxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Simple listener parameter question

I agree on the RAC point--it should be the VIP name/address in a RAC cluster. I 
also agree that in most cases for single-instance database servers you can 
safely leave it unset. However, I think setting it to HOST=localhost may only 
allow connections from the database server itself since it would cause the 
listener to listen on and *not* on other IP addresses (like the 
"real" IP address of the host). I can't easily test this right now, but I'm 
pretty sure it's correct for current versions. It will also and almost always 
be affected by whether or not you specify (IP=FIRST) in the ADDRESS section as 
well. Have a look at ML 421305.1 for some really good and relevant information 
related to your question.

It is also valid syntax to use (HOST=) and that will also cause the listener to 
invoke default behavior and listen on the IP address that corresponds to the 
hostname of the server it is running on (or possibly on<>, which is synonymous with all IP addresses on the node).


On Fri, Dec 5, 2008 at 8:40 PM, Bobak, Mark 
<Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> wrote:
Hi Maureen,

One reason I can think of to not use the definition you've specified, is RAC.  
In the RAC environment, you'll want to specify a VIP address for the local 
listener.  Other than that, if you're not on RAC, leave local_listener unset, 
and it will default to port 1521 on the localhost.

Hope that helps,

From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On Behalf 
Of Maureen English [sxmte@xxxxxxxxxxxxxxxx<mailto:sxmte@xxxxxxxxxxxxxxxx>]
Sent: Saturday, December 06, 2008 1:16 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Simple listener parameter question


For those of you who have a LISTENER running on the same machine
as your database(s), do you configure the local_listener parameter
to have the actual host name, or localhost?  Does anyone know of
any reason not to use something like



Other related posts: