DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=SKKQfJZ6hhmG4jgyrUAszmefOxVm6Iro/T6p5OpdK2Dywx3gV+LDY4wOotf/O/KjzHV9pw1eqkhr6zMts5F031Pzwg8NOwzt49lt/A19U77TjwJeZP5moDU9ixTYLqd+AOtscLFpunuqsXLa8eJ8un6sYLIa3u8UFtgiiajuzTg=
Message-ID: <2ba656800709161440l16243abw3388eb35e3ea19f4@mail.gmail.com>
Date: Sun, 16 Sep 2007 17:40:33 -0400
From: "Rajeev Prabhakar" <rprabha01@gmail.com>
To: kevin.lidh@gmail.com
Subject: Re: Data Guard: ORA-16534: no more requests accepted
Cc: oracle-l@freelists.org
In-Reply-To: <1189958381.8500.8.camel@lidhfed.lidh.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_9828_17974905.1189978833592"
References: <1189958381.8500.8.camel@lidhfed.lidh.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: rprabha01@gmail.com
------=_Part_9828_17974905.1189978833592
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Kevin

Have you already tried the non-default listener(say - on port 1522 ) option
so
as to NOT use automatic service registration ?

Rajeev

On 9/16/07, Kevin Lidh <kevin.lidh@gmail.com> wrote:
>
> We have an environment Solaris (SPARC) 9 with Oracle 10.2.0.1.0 with a
> two-node RAC database.  We used Grid Control to create a standby on
> another node and it was successful.  We then tried to do a switchover
> using DGMGRL.  The new primary was up and successful but the standby
> opened on node 2 and logs weren't being shipped.  I shutdown the standby
> on node 2 and started the database manually on node 1 with the
>
> 'alter database recover managed standby database through all switchover
> disconnect using current logfile'
>
> All of a sudden logs were being shipped and applied.  Then CRS started
> the instance on node 2 and all was good.
>
> I then angered the DG gods by attempting to switch back from the 1-node
> primary back to the 2-node standby.  If I do a "verify configuration"
> from Grid Control, it gives me an ORA-16534 saying it won't accept
> anymore requests.  The "action" specified is to wait but nothing is
> happening.  Metalink has one example of this error but it was when a
> listener wasn't defined correctly and the switchover failed.
>
> What I'm wondering is, is there any way to clear the DG queue and
> attempt the switchover again?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

<div>Kevin</div>
<div>&nbsp;</div>
<div>Have you already tried&nbsp;the non-default listener(say&nbsp;- on port 1522 ) option so </div>
<div>as&nbsp;to NOT use automatic service registration ?</div>
<div>&nbsp;</div>
<div>Rajeev</div>
<div>&nbsp;</div>
<div><span class="gmail_quote">On 9/16/07, <b class="gmail_sendername">Kevin Lidh</b> &lt;<a href="mailto:kevin.lidh@gmail.com">kevin.lidh@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">We have an environment Solaris (SPARC) 9 with Oracle 10.2.0.1.0 with a<br>two-node RAC database.&nbsp;&nbsp;We used Grid Control to create a standby on
<br>another node and it was successful.&nbsp;&nbsp;We then tried to do a switchover<br>using DGMGRL.&nbsp;&nbsp;The new primary was up and successful but the standby<br>opened on node 2 and logs weren&#39;t being shipped.&nbsp;&nbsp;I shutdown the standby
<br>on node 2 and started the database manually on node 1 with the<br><br>&#39;alter database recover managed standby database through all switchover<br>disconnect using current logfile&#39;<br><br>All of a sudden logs were being shipped and applied.&nbsp;&nbsp;Then CRS started
<br>the instance on node 2 and all was good.<br><br>I then angered the DG gods by attempting to switch back from the 1-node<br>primary back to the 2-node standby.&nbsp;&nbsp;If I do a &quot;verify configuration&quot;<br>from Grid Control, it gives me an ORA-16534 saying it won&#39;t accept
<br>anymore requests.&nbsp;&nbsp;The &quot;action&quot; specified is to wait but nothing is<br>happening.&nbsp;&nbsp;Metalink has one example of this error but it was when a<br>listener wasn&#39;t defined correctly and the switchover failed.
<br><br>What I&#39;m wondering is, is there any way to clear the DG queue and<br>attempt the switchover again?<br><br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a>
<br><br><br></blockquote></div><br>

------=_Part_9828_17974905.1189978833592--
--
http://www.freelists.org/webpage/oracle-l