Re: what is use the parameter "adress_list" int the listener.ora

Giganews Newsgroups
Subject: Re: what is use the parameter "adress_list" int the listener.ora
Posted by:  Daniel (ema…@test.com)
Date: Wed, 30 Aug 2006

"FreeDBA" <p.hir…@gmail.com> wrote in message
news:1156427051.620241.938…@m79g2000cwm.googlegroups.com...
> Hi,
> I would like understand the contains of listener.ora, partularly the
> Address-List parameter.
> I have multiple database and so multiple listener.ora.
> In some listener there is the adress_list parameter and son other there
> is nothing abour adress_list !!!!!
>
> Why ?
>
> (DESCRIPTION_LIST =
>    (DESCRIPTION =
>      (ADDRESS_LIST =
>        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
>      )
>      (ADDRESS_LIST =
>        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.1.154)(PORT = 1521))
>      )
>    )
>    (DESCRIPTION =
>      (PROTOCOL_STACK =
>        (PRESENTATION = GIOP)
>        (SESSION = RAW)
>      )
>      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.1.154)(PORT = 2481))
>    )
>  )
>
> SID_LIST_LISTENER =
>  (SID_LIST =
>    (SID_DESC =
>      (SID_NAME = PLSExtProc)
>      (ORACLE_HOME = d:\oracle8iserveur)
>      (PROGRAM = extproc)
>    )
>    (SID_DESC =
>      (GLOBAL_DBNAME = DGD)
>      (ORACLE_HOME = d:\oracle8iserveur)
>      (SID_NAME = DGD)
>    )
>  )

ADDRESS_LIST is exactly that, a list af addresses. In the case of the
LISTENER.ORA the ADDRESS_LIST allows the listener to "listen" on multiple
ports, multiple protocols etc etc.

In your example above your listener is "listening" on the following;

IPC
&
172.22.1.154:1521 (Normal TCP Listener)

Suppose you wanted to also "listen" on 1526, you'd just add it into the
address list.

Replies

None

In response to

what is use the parameter "adress_list" int the listener.ora posted by FreeDBA on 24 Aug 2006