On 9/27/05, Sami Seerangan <dba.orcl@(protected)> wrote:
> QUERY > > c1 refcursor; > c2 refcursor; > BEGIN BIB_OTP_PKG.get_token_details('123678456',:c1,:c2); END; > > I am executing the stored procedure which includes select over DB Link. > Most of the time it works (> 95%) and few times it hangs. > > I took 10053 event trace and it says wait event on 'SQL*Net message from > dblink' ,'SQL*Net message to dblink' and 'SQL*Net break/reset to dblink'. > Any idea what is going wrong here?
*Cause:* A session at the same site with same global transaction ID failed.
*Action:* No action necessary; the transaction is automatically recovered. associated with cursor #3 which is your package. So you either don't have to do anything (which is what the error says) or I'd look into if there are either network issues, or the query is taking an inordinate amount of time for certain values of the binds which is causing a timeout somewhere. It could be worse look at 2052.. *ORA-02052 (See ORA-02052.ora-code.com) remote transaction failure at string *
*Cause:* There was some error in a remote transaction at the named database link.
<div><span class="gmail_quote">On 9/27/05, <b class="gmail_sendername">Sami Seerangan</b> <<a href="mailto:dba.orcl@(protected)">dba.orcl@(protected)</a>> ; wrote:</span></div> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">QUERY<br><br>c1 refcursor;<br>c2 refcursor; <br>BEGIN BIB_OTP_PKG.get_token_details('123678456',:c1,:c2); END; <br><br>I am executing the stored procedure which includes select over DB Link. Most of the time it works (> 95%) and few times it hangs.<br><br>I took 10053 event trace and it says wait event on 'SQL*Net message from dblink' ,'SQL *Net message to dblink' and 'SQL*Net break/reset to dblink'. Any idea what is going wrong here? </blockquote> <div> </div> <div> </div> <div><br> </div> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">EXEC #3:c=10000,e=509899355,p=0,cr=0,cu=1,mis =0,r=0,dep=0,og=4,tim=951620662363<br>ERROR #3:err=2051 tim=97445955 </blockquote> <div> </div> <div> </div> <div>Well you are getting </div> <div> </div> <div><strong>ORA-02051 (See ORA-02051.ora-code.com) another session in same transaction failed<br></strong> <dd class="MH1"><a name="1001768"></a> <p><strong>Cause:</strong> A session at the same site with same global transaction ID failed.</p> <dd class="MH2"><a name="1001769"></a> <p><strong>Action:</strong> No action necessary; the transaction is automatically recovered.</p></dd></dd></div> <div class="MH2">associated with cursor #3 which is your package. So you either don't have to do anything (which is what the error says) or I'd look into if there are either network issues, or the query is taking an inordinate amount of time for certain values of the binds which is causing a timeout somewhere. </div> <div class="MH2"> </div> <div class="MH2">It could be worse look at 2052.. </div> <div class="MH2"><strong>ORA-02052 (See ORA-02052.ora-code.com) remote transaction failure at <em class= "Italic">string</em><br></strong> <dd class="MH1"><a name="1003680"></a> <p><strong>Cause:</strong> There was some error in a remote transaction at the named database link.</p></dd></div> <div class="MH2"> </div> <div class="MH2"> </div> <div> </div> <div> </div> <div><br> </div> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">-- <br>Niall Litchfield<br>Oracle DBA<br><a href="http://www.niall.litchfield.dial.pipex.com">http://www.niall.litchfield .dial.pipex.com </a> </blockquote>
