standby database and listener

From: David Cure <David.Cure.anti-swen_at_Linux.EU.Org.invalid>
Date: Fri, 11 Mar 2005 16:26:39 +0000 (UTC)
Message-ID: <slrnd33hlv.6na.David.Cure.anti-swen@bilbo.Finix.EU.Org>

                Hello,

        I have trouble with standby database and listener on same box. I use Oracle 9.2.0.6.0 on solaris 9.

	box A = primary database with db_name = sid = dbprod
	box B = standby database and a test database copied from primary
database :
		o test database with db_name = sid = dbprod (same as
primary database)
		o standby database with db_name = dbprod and sid =

dbprodstby         

        On the Box B, I create a dédicated listener for the standby :

STANDBY =
(DESCRIPTION_LIST =
   (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = boxb)(PORT = 1522))
   )
)

SID_LIST_STANDBY =
(SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = dbprodstby)
(ORACLE_HOME = /softs/oracle/9.2.0)
(SID_NAME = dbprodstby)

    )

)

        And on this Box B, I have another listener for the test database :

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = boxb)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /softs/oracle/9.2.0)
(PROGRAM = extproc)

    )
    (SID_DESC =
(ORACLE_HOME = /softs/oracle/9.2.0)
(SID_NAME = dbprod)

    )
  )

        I start the both listener, all is ok. But when I start the standby database, it integrates the listener/service of the test database.... Here's a lsnrctl status :

Service "dbprod" has 3 instance(s).
  Instance "dbprod", status UNKNOWN, has 1 handler(s) for this service...
  Instance "dbprod", status READY, has 1 handler(s) for this service...   Instance "dbprodstby", status READY, has 1 handler(s) for this service...

        and then when I want to connect to dbprod, I "connect" some time on the standby....

        Any idea ?

        David.

PS : The status of the standby listener is ok. Received on Fri Mar 11 2005 - 10:26:39 CST