Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: setting up oracle Data Guard
On Wed, 18 May 2005 00:08:12 +0200, Sybrand Bakker
<postbus_at_sybrandb.demon.nl> wrote:
>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.
It was a typo...I forgot a closing ")". Another set of eyes caught it for me.
>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.
Ah, I was going to say,
"In the book 'Oracle Data Guard' the notes on tnsnames.ora state:"
and then quote a bunch of stuff BUT in later chapters, where they talk about transparent failovers they do use the service_name instead of the SID.
I just didn't get that far.
Thanks for the heads-up!
Vince