Re: 10g init.ora
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: gkatteri@xxxxxxxxxxx
- Date: Wed, 24 May 2006 10:38:01 +0100
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@xxxxxxxxxxx> 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@xxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
--
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
