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

From: Ian Cary <ian.cary_at_ons.gsi.gov.uk>
Date: Tue, 9 Sep 2008 09:39:08 +0100
Message-ID: <OF7529D43A.88A04F55-ON802574BF.002E8469-802574BF.002F881F@ons.gsi.gov.uk>

It is possible to use service="<full tns string>" in log_dest2. This is from a fast-start failover system where the data guard broker configuration overwrote my initial values that used a tns alias.

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
log_archive_dest_2                   string

service="(DESCRIPTION=(ADDRESS

_LIST=(ADDRESS=(PROTOCOL=tcp)(

HOST=TLINUX1)(PORT=1521)))(CON NECT_DATA=(SERVICE_NAME=dgtest

1_XPT)(INSTANCE_NAME=dgtest)(S

                                                 ERVER=dedicated)))",
LGWR S
                                                 YNC AFFIRM delay=0
OPTIONAL ma
                                                 x_failure=0
max_connections=1
                                                   reopen=300
db_unique_name="d
                                                 gtest1" register
net_timeout=1
                                                 80
valid_for=(online_logfile,
                                                 primary_role)

Additionally the fal_client and fal_server are also overwriiten by explicit strings rather than the tns alias

dgtest> show parameter fal

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
fal_client                           string

(DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=tcp)(HOST=TLIN

UX3)(PORT=1521)))(CONNECT_DATA =(SERVICE_NAME=dgtest3_XPT)(IN

STANCE_NAME=dgtest)(SERVER=ded

                                                 icated)))
fal_server                           string

(DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=tcp)(HOST=TLIN

UX1)(PORT=1521)))(CONNECT_DATA =(SERVICE_NAME=dgtest1_XPT)(SE

                                                 RVER=dedicated)))

I'm not usually one for using tools where a manual configiuration is possible but I must admit that the dgmrgl tool does seem to do the job pretty well.

Whether any of this is of use to the OP of course.....

Cheers,

Ian

|---------+----------------------------->


|         |           finn.oracledba_at_gma|

|         |           il.com            |

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           08/09/2008 21:22  |

|         |           Please respond to |

|         |           finn.oracledba    |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       sacrophyte_at_gmail.com                                                                         |
  |       cc:       david.barbour1_at_gmail.com, oracle-l_at_freelists.org                                             |
  |       Subject:  Re: Primary gets ora-16009 when attempting a heartbeat with standby                          |
  >--------------------------------------------------------------------------------------------------------------|

It makes it hard to help when you don't provide the requested information (unless it's proprietary for some reason).

Anyways, for a long, long time Oracle database links had a problem where if the "using" string was a tns alias it would work fine one day and then suddenly it would stop working and then never work again until you dropped the db link and recreated it. I'm wondering if you're up against something similar.
The workaround for the db link was to put the whole tns string (i.e anything after "ALIAS = ") into the using string. I wonder if it's possible to do something similar in the "SERVICE=" part of the log_archive_dest_2 parameter. It's worth a shot.

Finn

On Mon, Sep 8, 2008 at 2:42 PM, Charles Schultz <sacrophyte_at_gmail.com> wrote:
Yes, I can sqlplus to the fal_server, fal_client, and all permutations of our arch_log_dest_2 parameter. And yes, I end up in the standby database when I sqlplus to the standby database. =) Not knowing what parameter you are looking for with "remote"; we do not have a remote listener setup, but the passwordfile is.

This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.

For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk

---

Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications

---

Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics

---

The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Sep 09 2008 - 03:39:08 CDT