Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g init.ora
BWT: If you are using the default listener port and your listener
running on the local then this entry in a init.ora file is redundant
(you don't need it). Oracle Instance will try to register ton default
port anyway.
Only case it make since to put it in the ini.ora file is then you are
using non default port or a listener you would like to register with
located on different host the your Instance located (despite of the
fact that parameter name is local_listener you can do it ;)
Yury
On 5/23/06, GovindanK <gkatteri_at_fastmail.fm> wrote:
> If you are using a port other than 1521 then this would help in registering the database with the listener.
>
> HTH
> GovindanK
>
> On Tue, 23 May 2006 13:43:51 -0500, "Joe Smith" <joe_dba_at_hotmail.com> said:
> > 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.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Yury +44 7738 013090 (GMT) ============================================ http://otn.oracle.com/ocm/jvelikanovs.html -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 24 2006 - 04:38:01 CDT
![]() |
![]() |