Re: Listener for dataguard config, how?

Not possible.
Clients failover, not listeners.

The only thing you can do is have (statically) both listeners listen for both servers and define the remote listener in the remote_listener init.ora parameter.
On the client side you need to set the failover section in tnsnames.ora.

Evidently this is discussed in one the many Oracle documents no one reads,
the net administrators manual.

--
Sybrand Bakker
Senior Oracle DBA



On Oct 4, 7:22 pm, Volker Hetzer <firstname.lastn..._at_ieee.org> wrote:


> Hi!

> Can somebody please give me a hint about where to start?

> Given 10g (linux), a working dataguard configuration

> and tnsnames as the addressing means for clients how

> does it normally go?

> So far we switch the tnsnames file and have clients reconnect.

> I'd like to use the same tnsnames file regardless of which

> instance is primary.

> Now, the listener control file specifies a host and a port,

> so I presume I can just run the listener on a separate machine.

> But the remote listener parameter just expects a hostname.

> But what I'd like to do is for the listener to connect

> a given service name to one or another instance, depending on

> status.

> Where do I start looking for this?

>

> Lots of Greetings!

> Volker

> --

> For email replies, please substitute the obvious.