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

*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_at_gmail.com>wrote:

> Okay - what are the two strings you're using for log_archive_dest_2?
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l