Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g init.ora

Re: 10g init.ora

From: Paul Drake <bdbafh_at_gmail.com>
Date: Tue, 23 May 2006 18:35:40 -0400
Message-ID: <910046b40605231535p12a7a0b4kf1e5981a5468d5be@mail.gmail.com>


On 5/23/06, Joe Smith <joe_dba_at_hotmail.com> wrote:
>
> In J Lewis's new book "Cost Based Oracle..." in his example initd10g.ora
> he has this line:
>
> *.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1
> )(PORT=1521)))'
>
>
> what is the advantage of putting this Listener.ora line in the init.ora?
>
> thanks.

Joe,

It used to be that if your laptop acquired different ip addresses in the scope of a single boot, that the listener might have some issues :). Using 127.0.0.1 for a laptop is a good way to go for laptops. Its not a bad way to go for servers, either, but its far from required.

hth.

Paul

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 23 2006 - 17:35:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US