Re: 10g init.ora

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Tue, 23 May 2006 23:18:18 +0100
Message-ID: <d6f0def50605231518pb065504wfa0560301ee9effa@mail.gmail.com>

It inst a listener ora line.
It is an address of Oracle listener there an instance have to register itself during a startup procedure.
As an alternative you can define a TNS alias in thsnames.ora file and put alias name in the init.ora file.

Yury

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.
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> 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-l

Received on Tue May 23 2006 - 17:18:18 CDT