Re: Primary gets ora-16009 when attempting a heartbeat with standby
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 stringservice="(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