Re: Primary gets ora-16009 when attempting a heartbeat with standby
Date: Mon, 8 Sep 2008 16:22:50 -0400
Message-ID: <74f79c6b0809081322x1916f257r8996c866e0ca1901@mail.gmail.com>
It makes it hard to help when you don't provide the requested information
(unless it's proprietary for some reason).
Anyways, for a long, long time Oracle database links had a problem where if
the "using" string was a tns alias it would work fine one day and then
suddenly it would stop working and then never work again until you dropped
the db link and recreated it. I'm wondering if you're up against something
similar.
The workaround for the db link was to put the whole tns string (i.e anything
after "ALIAS = ") into the using string. I wonder if it's possible to do
something similar in the "SERVICE=" part of the log_archive_dest_2
parameter. It's worth a shot.
Finn
On Mon, Sep 8, 2008 at 2:42 PM, Charles Schultz <sacrophyte_at_gmail.com>wrote:
> Yes, I can sqlplus to the fal_server, fal_client, and all permutations of
> our arch_log_dest_2 parameter. And yes, I end up in the standby database
> when I sqlplus to the standby database. =) Not knowing what parameter you
> are looking for with "remote"; we do not have a remote listener setup, but
> the passwordfile is.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 08 2008 - 15:22:50 CDT