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:56:55 -0400
Charles,
Something doesn't match. According to your last post you are using LGWR as
redo shipping mechanism, but in original post you showed errors from an
archiver and names aren't matching (MSGSTBY vs. PRODSTBY)...
Mon Sep 8 08:04:35 2008
Errors in file /u01/app/oracle/admin/PRODDB/bdump/proddb_arc1_7783.trc:
ORA-16009: remote archive log destination must be a STANDBY database
Mon Sep 8 08:04:35 2008
PING[ARC1]: Heartbeat failed to connect to standby 'PRODSTBY'. Error is
16009.
Did you check and verified that IP addresses are correct by running the
following commands on the primary:
to get the primary IP
ifconfig -a
to verify standbys IP
ping -sn standbyhost
ping -sn standbyhost.my.com
--romas
On Mon, Sep 8, 2008 at 4:39 PM, Charles Schultz <sacrophyte@xxxxxxxxx>wrote:
> *David* - Since you are the 2nd person to ask, I'll respond to the list:
> Works: 'SERVICE="MSGSTND", LGWR ASYNC NOAFFIRM delay=0 max_failure=0
> OPTIONAL REOPEN=60 register'
> Does not work: 'SERVICE="MSGSTBY", LGWR ASYNC NOAFFIRM delay=0
> max_failure=0 OPTIONAL REOPEN=60 register'
>
>
> *Romas* - I am working on your idea. Are you suggesting that I use
> pfiles/lsof on LGWR?
>
>
> *Finn* - my apologies about not providing enough information; I never know
> how much is too much, especially since the audience in this case is quite
> large. Here are my tns resolutions:
> <primary> /u01/app/oracle: *tnsping msgstnd*
>
> TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on
> 08-SEP-2008 15:33:30
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> /u01/app/oracle/product/10.2.0.2.home2/network/admin/sqlnet.ora
>
> Used LDAP adapter to resolve the alias
> Attempting to contact
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=standbyhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MSGPROD2)(SERVER=DEDICATED)))
> OK (10 msec)
> <primary> /u01/app/oracle: *tnsping msgstby*
>
> TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on
> 08-SEP-2008 15:33:36
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> /u01/app/oracle/product/10.2.0.2.home2/network/admin/sqlnet.ora
>
> Used LDAP adapter to resolve the alias
> Attempting to contact
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=standbyhost.my.com
> )(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MSGPROD2)(SERVER=DEDICATED)))
> OK (10 msec)
>
> The SERVICE I have listed in the dest parameter exactly matches the entry
> in oid ldap. However, taking your thought one step further, perhaps there is
> an issue because one tns name has the full host, whereas the other does not.
> I will experiment with that to see if that makes a difference or not.
>
>
> *DBA Dave* wrote:
> "So, I got the same message last week (Oracle 10.2.0.3, AIX 5.3)
> After trying different options I ended up setting up the db_unique_name in
> both instances and that made the trick."
>
> Thanks, did you set the db_unique_name the same or different? Ours is left
> default and matches, but I'll think about that.
>
> On Mon, Sep 8, 2008 at 3:01 PM, David Barbour <david.barbour1@xxxxxxxxx>wrote:
>
>> Okay - what are the two strings you're using for log_archive_dest_2?
>>
>
> --
> Charles Schultz
>
Other related posts:
