ORA-01591

From: krishnen <krishnenc_at_gmail.com>
Date: Wed, 14 May 2008 02:00:25 -0700 (PDT)
Message-ID: <9396919a-1860-4aaa-aa6f-e60c6e525daf@y21g2000hsf.googlegroups.com>


Hello All.

If its of interest to anyone, the problem was solved by our oracle support like this:

insert into pending_trans$ (
LOCAL_TRAN_ID,GLOBAL_TRAN_FMT,GLOBAL_ORACLE_ID, STATE,STATUS,SESSION_VECTOR,RECO_VECTOR,TYPE#,FAIL_TIME,RECO_TIME) values( '15.5.1005',

        306206, /* */
       'XXXXXXX.12345.1.2.3', /* These values can be used without any
*/
       'prepared','P', /* modification. Most of the values are */
        hextoraw( '00000001' ), /* constant. */
        hextoraw( '00000000' ), /* */
        0, sysdate, sysdate );

insert into pending_sessions$ values('15.5.1005',1,
            hextoraw('05004F003A1500000104'),'C',0,30258592,'',146);

rollback force '15.5.1005';

execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('15.5.1005');



Where '15.5.1005' is the ID of the transaction which was locked.

Cheers,
Krishnen

On May 12, 10:46 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> On May 12, 12:27 pm,krishnen<krishn..._at_gmail.com> wrote:
>
>
>
>
>
> > On May 12, 7:15 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
> > > On May 12, 11:29 am,krishnen<krishn..._at_gmail.com> wrote:
>
> > > > Hello David,
>
> > > > The following is displayed:
>
> > > > NAME                                 TYPE        VALUE
> > > > ------------------------------------ -----------
> > > > ------------------------------
> > > > distributed_transactions             integer     31
>
> > > > On May 12, 6:09 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
> > > > > On May 12, 10:56 am,krishnen<krishn..._at_gmail.com> wrote:
>
> > > > > > Hello All,
>
> > > > > > We are running an Oracel Forms system on the following platform:
> > > > > > IBM AIX UNIX 4.33
> > > > > > Database Version: 8.1.7.4
>
> > > > > > End users are getting the following error when trying to select from a
> > > > > > certain table.
> > > > > > ORA-0951 : LOCK Held by in-doubt  distributed transaction 15.5.1005
> > > > > > No pending transactions were found in DBA_2PC_PENDING.
>
> > > > > > The DBA tried a rollback force on the transaction id string specified
> > > > > > in the error message but the follwowing error was obtained:
> > > > > > ORA-02058: no prepared transaction found with ID string.
>
> > > > > > Is there any solution to this problem??
>
> > > > > > Many Thanks,
> > > > > >Krishnen
>
> > > > > What does 'show parameter dist' display?
>
> > > > > David Fitzjarrell- Hide quoted text -
>
> > > > > - Show quoted text -- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > And on the server where the remote table exists?
>
> > > David Fitzjarrell- Hide quoted text -
>
> > > - Show quoted text -
>
> > The same is displayed...
> > Will the following solve the problem??
> > execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('15.5.1005');- Hide quoted text -
>
> > - Show quoted text -
>
> I believe it should.  I wanted to see if both sides of the transaction
> were allowing distributed transactions since I have experienced a
> similar issue when one side was configured for distributed transaction
> processing and one side was not.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -
Received on Wed May 14 2008 - 04:00:25 CDT

Original text of this message