Re: Simple listener parameter question
- From: "Dan Norris" <dannorris@xxxxxxxxxxxxx>
- To: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- Date: Sat, 6 Dec 2008 08:09:40 -0600
Personally, I don't like that configuration as it sometimes confuses people
that aren't used to it and they sometimes modify/delete the TNS entry
because they don't know what it is for.
Also, it doesn't give any additional flexibility--anything you can put in
the TNS entry can be jammed on one line and put directly into this parameter
(as long as you don't exceed the length limitations which I think may be 255
characters).
Dan
On Sat, Dec 6, 2008 at 4:19 AM, Vishal Gupta <vishal@xxxxxxxxxxxxxxx> wrote:
> You can also specify something like. Which gives you more flexibility in
> the ability to specify multiple listening address depending on your listener
> configuration.
>
>
>
> LOCAL_LISTENER=<tnsnamesesalias>
>
>
>
> Regards,
>
> Vishal Gupta
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Dan Norris
> *Sent:* 06 December 2008 03:41
> *To:* Mark.Bobak@xxxxxxxxxxxx
> *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 127.0.0.1 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
> 0.0.0.0, which is synonymous with all IP addresses on the node).
>
> Dan
>
> On Fri, Dec 5, 2008 at 8:40 PM, Bobak, Mark <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,
>
> -Mark
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Maureen English [sxmte@xxxxxxxxxxxxxxxx]
> Sent: Saturday, December 06, 2008 1:16 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Simple listener parameter question
>
>
> Hi,
>
> 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
>
> local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1234))'
>
>
>
Other related posts:
