Re: How to set up 2 instance listener?

From: Marek Wiechula and Sheila Plant <sparemgw_at_batelco.com.bh>
Date: 1996/09/03
Message-ID: <322B837F.6C77_at_batelco.com.bh>#1/1

Dave Mausner wrote:
>
> In article <50cjei$2eik_at_news.doit.wisc.edu>,
> mqader_at_facstaff.wisc.edu (Mirwais Qader) wrote:
> >
> >I am in the process of running 2 instances on our HP9000 UNIX 9.04 ...
>
> add more SID_DESC to the SID_LIST:
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = db1 )
> (ORACLE_HOME = /users/oracle/oraclebase/product/7.2.2.4)
> )
> = (sid_desc =
> = (sid_name = db2 )
> = (oracle_home = /u01/oracle/product/7.8.9.10)
> = )
> )
>

This solution is OK for having one listener that listens for two data bases, but I think the original requirement was for two different listeners. There are many good reasons you might want this. In my organization we use the SPX protocol a lot and we use separate listeners so that each database can have its own SPX Service name based on the database name.

Besides, the TNSNAMES entries given will not mesh with the changes suggested.

I suggest you add the following to the file:

LISTENER2 =
  (ADDRESS_LIST =
    (ADDRESS =

      (PROTOCOL = TCP)
      (HOST = labux )
      (PORT = 1522)

    )
  )
STOP_LISTENER2 = YES
STARTUP_WAIT_TIME_LISTENER2 = 0
CONNECT_TIMEOUT_LISTENER2 = 0 SID_LIST_LISTENER2 =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = test )
      (ORACLE_HOME = /users/oracle/oraclebase/product/7.2.2.4)

    )
  )  

TRACE_LEVEL_LISTENER2=ADMIN
TRACE_DIRECTORY_LISTENER2 = /users/oracle/oraclebase/product/7.2.2.4/network/trace
TRACE_FILE_LISTENER2 = LISTENER2

LOG_LEVEL_LISTENER2 = ADMIN

LOG_DIRECTORY_LISTENER2 = /users/oracle/oraclebase/product/7.2.2.4/network/log LOG_FILE_LISTENER2 = LISTENER2 (Basically you completely duplicate the file except where ever you putin LISTENER you now put in LISTENER2. Except of course if you were running two different levels of Oracle your home directory might be different on the second listener. When you want to start the second listener you have to specify the name:

lsnrctl start listener2

Good Luck.

Marek Wiechula :-) Received on Tue Sep 03 1996 - 00:00:00 CEST