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

From: Finn Jorgensen <>
Date: Mon, 8 Sep 2008 14:35:42 -0400
Message-ID: <>

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


On Mon, Sep 8, 2008 at 12:00 PM, Charles Schultz <>wrote:

> Interesting, Oracle Support shared the same idea this morning. =) No errors
> in the alert.log on the standby. We are not using tnsnames.ora (oid ldap
> instead), but tnsping shows appropriate responses in all cases. I am not
> sure what the listener has to do with it since the tns alias points to the
> same service name. But Oracle Support is asking for more information (ie,
> listener.log, etc), so we will see if that proves to be helpful or not.

Received on Mon Sep 08 2008 - 13:35:42 CDT

Original text of this message