Re: Primary gets ora-16009 when attempting a heartbeat with standby
Date: Mon, 8 Sep 2008 13:42:40 -0500
Message-ID: <7b8774110809081142k344c92d1k5aa6bd528be32d8c@mail.gmail.com>
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.
If it is any consolation, Oracle Support is asking the same questions that you guys are. Unfortutnately, I am no closer to understanding what the problem is. My initial email was trying to find out if anyone else had come across this problem so far, for it is a very strange problem to have.
Keep the ideas coming.... *grin*
On Mon, Sep 8, 2008 at 1:35 PM, Finn Jorgensen <finn.oracledba_at_gmail.com>wrote:
> If you're at a Unix prompt on the Primary server and do a
>
> sqlplus "sys/pwd_at_prodstby as sysdba"
>
> Do you end up in the standby database?
>
> What is the output of :
>
> show parameter 2 (or whatever destination is your standby)
> show parameter remote
> show parameter fal
> show parameter standby
>
> Finn
>
-- Charles Schultz -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 08 2008 - 13:42:40 CDT