Re: 2 databases 2 listeners 1 oracle

From: <madhul_at_my-deja.com>
Date: Tue, 25 Jan 2000 22:27:10 GMT
Message-ID: <86l7vi$3ak$1@nnrp1.deja.com>

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. Received on Tue Jan 25 2000 - 16:27:10 CST

Re: 2 databases 2 listeners 1 oracle_home