Re: setting up oracle Data Guard

On Tue, 17 May 2005 19:36:56 GMT, Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net> wrote:

>
>The listener on the primary (sapsnd/SND) and the failover server
>(sapude/SND) don't respond to tnsping anymore....

You don't have two listeners. You have your listener set up to two different nodes on one single port. That's not going to work. And you need a listener on both machines, not on one. Listeners can't be started remotely.
You edited the listener.ora manually, and you evidently didn't read up on the structure of the listener.ora or you simplu don't understand it.
On the client side you need to modify the tnsnames.ora for transparent application failover as documented in your manual. For transparent application failover, you can't use the SID= clause in tnsnames.ora, you MUST use the service_name= syntax.

--
Sybrand Bakker, Senior Oracle DBA