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

Dropping and recreating the oid ldap entry seems to have made the problem go away. This is both good and bad; good because we do not get the error with our standard setup, but bad because we have no idea why we were getting errors in the first place.

Very strange. Thanks to everyone who pitched ideas.

Still have not heard a peep out of Oracle Support.

On Mon, Sep 8, 2008 at 3:39 PM, Charles Schultz <sacrophyte_at_gmail.com>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.
>

-- 
Charles Schultz

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