Re: Primary gets ora-16009 when attempting a heartbeat with standby

From: Roman Podshivalov <roman.podshivalov_at_gmail.com>
Date: Mon, 8 Sep 2008 10:30:20 -0400
Message-ID: <55f303590809080730y24360e22rb6f453c8b14d092b@mail.gmail.com>


Hmmm,

In this case to research such situation more information is required about configuration like: init.ora files, tnsnames.ora/sqlnet.ora files and current dns resolutions from both sides, outputs from v$dataguard_* views would be handy as well.

PS: are you using custom TNS_ADMIN location ?

--romas

On Mon, Sep 8, 2008 at 9:39 AM, Charles Schultz <sacrophyte_at_gmail.com>wrote:

> Romas, great question.
>
> Looking back at the sequence of events, it does appear that the DNS
> configuration was such that the primary was trying to ship logs to itself
> for about 5 minutes after the last switchover. However, after that was
> corrected, the configuration ran without a hitch until the standby was
> restarted a few weeks later.
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 08 2008 - 09:30:20 CDT

Original text of this message