Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-0191

0 views
Skip to first unread message

krishnen

unread,
May 12, 2008, 11:56:53 AM5/12/08
to
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

ora...@msn.com

unread,
May 12, 2008, 12:09:30 PM5/12/08
to

What does 'show parameter dist' display?


David Fitzjarrell

krishnen

unread,
May 12, 2008, 12:29:41 PM5/12/08
to
Hello David,

The following is displayed:

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
distributed_transactions integer 31

> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

ora...@msn.com

unread,
May 12, 2008, 1:15:22 PM5/12/08
to
> > - Show quoted text -- Hide quoted text -

>
> - Show quoted text -

And on the server where the remote table exists?


David Fitzjarrell

krishnen

unread,
May 12, 2008, 1:27:58 PM5/12/08
to

The same is displayed...
Will the following solve the problem??
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('15.5.1005');

ora...@msn.com

unread,
May 12, 2008, 4:46:54 PM5/12/08
to
> 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

krishnen

unread,
May 14, 2008, 5:00:25 AM5/14/08
to
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...@cox.net" <orat...@msn.com> wrote:


> On May 12, 12:27 pm,krishnen<krishn...@gmail.com> wrote:
>
>
>
>
>
> > On May 12, 7:15 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>

> > > On May 12, 11:29 am,krishnen<krishn...@gmail.com> wrote:
>
> > > > Hello David,
>
> > > > The following is displayed:
>
> > > > NAME                                 TYPE        VALUE
> > > > ------------------------------------ -----------
> > > > ------------------------------
> > > > distributed_transactions             integer     31
>
> > > > On May 12, 6:09 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>

0 new messages