Re: standby database and listener

On Fri, 11 Mar 2005 16:26:39 +0000 (UTC), David Cure <David.Cure.anti-swen_at_Linux.EU.Org.invalid> wrote:

> 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 ?

As your situation is non-standard you'll need to set the local_listener parameter in init.ora at least for the standby database, but better for both of them.

--
Sybrand Bakker, Senior Oracle DBA