Re: three listeners, one for each instance ???

From: <poohland_at_hotmail.com>
Date: Tue, 14 Jul 1998 18:13:36 GMT
Message-ID: <6og74g$c2m$1@nnrp1.dejanews.com>

I set up one listener listens to 2 instances on the same box on the same port. The 2 instances have different $ORACLE_HOME.

The way I do this is:
set up the tnsnames.ora for one of the instance and add the name with the SID of both the databases (check your doc in doing that, but remember to put the same port number on each on them).

Then edit the listener.ora file in one of the instance directory, for example,

LISTENER=
   (ADDRESS_LIST=

      (ADDRESS=
         (PROTOCOL=TCP)
         (HOST=<HOSTNAME>)
         (PORT=1521)
       )

    )

SID_LIST_LISTENER=
   (SID_LIST=

     (SID_DESC=


        (SID_NAME=<SID1>)


        (ORACLE_HOME=<ORACLE_HOME FOR SID1>)


      )
    (SID_DESC=


        (SID_NAME=<SID2>)


        (ORACLE_HOME=<ORACLE_HOME FOR SID2>)


     )

    )

Then you will have one listener listen to 2 instances on the same port.

i also tried to run one more listener to listen to these 2 instances without any success. So, if anyone know how to do it, please let me know.

Winnie Liu

In article <35AB4504.8532EF47_at_bimberi.com.au>,   dominic_at_bimberi.com.au wrote:

> Hi, I'd like to know the best approach to setting up individual listener
> services
> for each of three db's on the same AIX system (all run the same version
> of Oracle, 7.3.2)
>
> I understand that I should assign each a different port number, but I
> can't seem
> to find any clear examples.
>
> The result I need is I need to be able to start and stop a listener for
> any instance
> with effecting any other listener running (i.e. the DB may be restarted
> on another
> system if some of the access routes to it are invalidated
>
> TIA
>
> Dominic
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 14 1998 - 13:13:36 CDT