Re: 2 databases 2 listeners 1 oracle_home

madhul_at_my-deja.com wrote:

> In article <388DEC06.3A5C19FA_at_us.ibm.com>,
> Doug Cowles <dcowles_at_us.ibm.com> wrote:
> > If I have 2 different sids on one oracle home, how can I configure 2
> > different listeners,
> > one for each, each listening on a different port?
> >
> > Thanks,
> > - Dc.
> >
> >
> Add more entries in listener.ora substituting listener with a new name,
> say listener2. For eg:
>
> if current file has:
>
> LISTENER=( ADDRESS_LIST=
> (ADDRESS= (PROTOCOL=tcp) (HOST=host1) (PORT=1521)))
> sid_list_listener=( SID_LIST=
> (SID_DESC=
> (SID_NAME=ABC)
> (ORACLE_HOME=/u01/home/oracle/product/8.0.5)
> ))
>
> add the following to it: (note the change in port number)
>
> listener2=(address_list=
> (address=(protocol=tcp) (host=host1) (port=1525)))
> sid_list_listener2=(sid_list=
> (sid_desc
> (sid_name=XYZ)
> (ORACLE_HOME=/u01/home/oracle/product/8.0.5)
> ))
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Why would you have two listeners on two ports? They can both listen on the same port. After a connection request is made, the actual communication will
be on another port alltogether anyway.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle Received on Wed Jan 26 2000 - 17:20:43 CST