Re: Primary gets ora-16009 when attempting a heartbeat with standby
- From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
- To: david.barbour1@xxxxxxxxx
- Date: Mon, 8 Sep 2008 15:39:35 -0500
*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:
