Re: Primary gets ora-16009 when attempting a heartbeat with standby
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: sacrophyte@xxxxxxxxx
- Date: Mon, 8 Sep 2008 16:04:50 -0400
What are you using to ship the logs ARCH or LGWR ? Use pfiles/lsof to find
out what IP connections are open from either one you are using for the log
shipping. Compare IP addresses in tns with one reported by pfiles/lsof.
--romas
On Mon, Sep 8, 2008 at 2:42 PM, Charles Schultz <sacrophyte@xxxxxxxxx>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.
>
> 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@xxxxxxxxx>wrote:
>
>> If you're at a Unix prompt on the Primary server and do a
>>
>> sqlplus "sys/pwd@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
>
Other related posts:
