DomainKey-Signature: a=rsa-sha1; c=nofws;        d=gmail.com; s=gamma;        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version         :content-type:references;        b=RFh3CKSdkHvzDk5PtK5b+0ShBVGNkX8wdazpkD6iLgeVQuVjYhpn5MnkAwV6P3szuz         18dWbM96KEw4XNjuaa3tJ5oegre+/h16TkJu/fWM8MdFIecL12b3roiQhLozLFXk9B5Z         RkLJ+iT3M7rP+ea8EjUa1wJcdrCGFH27CiD1s=
Message-ID: <55f303590809081304r11b8446et3c8ab49171f39b9d@mail.gmail.com>
Date: Mon, 8 Sep 2008 16:04:50 -0400
From: "Roman Podshivalov" <roman.podshivalov@gmail.com>
To: sacrophyte@gmail.com
Subject: Re: Primary gets ora-16009 when attempting a heartbeat with standby
Cc: "Finn Jorgensen" <finn.oracledba@gmail.com>, 	"David Barbour" <david.barbour1@gmail.com>, 	oracle-l <oracle-l@freelists.org>
In-Reply-To: <7b8774110809081142k344c92d1k5aa6bd528be32d8c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_66725_8734305.1220904290781"
References: <7b8774110809080625l17f5fe9dl91784001a37789f8@mail.gmail.com>	 <7b8774110809080629k17fa9638s90201802aef5c79b@mail.gmail.com>	 <55f303590809080636q46506c44g7e96b0197c569fd1@mail.gmail.com>	 <7b8774110809080639s53ed6a93hed67bb6d06a35c17@mail.gmail.com>	 <55f303590809080730y24360e22rb6f453c8b14d092b@mail.gmail.com>	 <7b8774110809080738n3487967q454ab9ddd3ed8c90@mail.gmail.com>	 <69eafc3f0809080857o26529028s6d158fb8904e3bdd@mail.gmail.com>	 <7b8774110809080900k4b3ea752yadbe9dd646a314d5@mail.gmail.com>	 <74f79c6b0809081135m39535efev443a038eea73b6fa@mail.gmail.com>	 <7b8774110809081142k344c92d1k5aa6bd528be32d8c@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: roman.podshivalov@gmail.com
------=_Part_66725_8734305.1220904290781
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What are you using to ship the logs ARCH or LGWR ? Use pfiles/lsof to find
out what IP connections are open from either one you are using for the log
shipping. Compare IP addresses in tns with one reported by pfiles/lsof.

--romas

On Mon, Sep 8, 2008 at 2:42 PM, Charles Schultz <sacrophyte@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.
>
> If it is any consolation, Oracle Support is asking the same questions that
> you guys are. Unfortutnately, I am no closer to understanding what the
> problem is. My initial email was trying to find out if anyone else had come
> across this problem so far, for it is a very strange problem to have.
>
> Keep the ideas coming.... *grin*
>
> On Mon, Sep 8, 2008 at 1:35 PM, Finn Jorgensen <finn.oracledba@gmail.com>wrote:
>
>> If you're at a Unix prompt on the Primary server and do a
>>
>> sqlplus "sys/pwd@prodstby as sysdba"
>>
>> Do you end up in the standby database?
>>
>> What is the output of :
>>
>> show parameter 2 (or whatever destination is your standby)
>> show parameter remote
>> show parameter fal
>> show parameter standby
>>
>> Finn
>>
>
>
> --
> Charles Schultz
>

------=_Part_66725_8734305.1220904290781
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr"><div>What are you using to ship the logs ARCH or LGWR ? Use pfiles/lsof to find out what IP connections are open from either one you are using for the log shipping. Compare IP addresses in tns with one reported by pfiles/lsof.</div>

<div>&nbsp;</div>
<div>--romas<br><br></div>
<div class="gmail_quote">On Mon, Sep 8, 2008 at 2:42 PM, Charles Schultz <span dir="ltr">&lt;<a href="mailto:sacrophyte@gmail.com">sacrophyte@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div dir="ltr">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 &quot;remote&quot;; we do not have a remote listener setup, but the passwordfile is.<br>
<br>If it is any consolation, Oracle Support is asking the same questions that you guys are. Unfortutnately, I am no closer to understanding what the problem is. My initial email was trying to find out if anyone else had come across this problem so far, for it is a very strange problem to have.<br>
<br>Keep the ideas coming.... *grin* 
<div class="Ih2E3d"><br><br>
<div class="gmail_quote">On Mon, Sep 8, 2008 at 1:35 PM, Finn Jorgensen <span dir="ltr">&lt;<a href="mailto:finn.oracledba@gmail.com" target="_blank">finn.oracledba@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div dir="ltr">If you&#39;re at a Unix prompt on the Primary server and do a <br><br>sqlplus &quot;sys/pwd@prodstby as sysdba&quot; <br><br>Do you end up in the standby database?<br><br>What is the output of :<br><br>show parameter 2 (or whatever destination is your standby)<br>
show parameter remote<br>show parameter fal<br>show parameter standby<br><font color="#888888"><br>Finn</font></div></blockquote></div><br clear="all"><br></div>-- <br>Charles Schultz<br></div></blockquote></div><br></div>

------=_Part_66725_8734305.1220904290781--
--
http://www.freelists.org/webpage/oracle-l