Home » RDBMS Server » Server Administration » kill hanged transaction
icon9.gif  kill hanged transaction [message #294451] Thu, 17 January 2008 12:31 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

In my alert i see a lot of msgs like that
Thu Jan 17 01:35:35 2008
Errors in file /TEST/admin/bdump/testeo_reco_27658.trc:
ORA-02068: following severe error from PRODLINK
ORA-03113: end-of-file on communication channel
Thu Jan 17 01:38:29 2008
Errors in file /TEST/admin/bdump/testeo_reco_27658.trc:
ORA-02068: following severe error from PRODLINK
ORA-03113: end-of-file on communication channel
Thu Jan 17 01:42:52 2008
Errors in file /TEST/admin/bdump/testeo_reco_27658.trc:
ORA-02068: following severe error from PRODLINK
ORA-03113: end-of-file on communication channel


and when i see that trc.. i see things like that
ERROR, tran=2.39.57684, session#=1, ose=0:
ORA-02068: following severe error from PRODLINK
ORA-03113: end-of-file on communication channel
*** 2008-01-17 01:31:32.546
ERROR, tran=2.39.57684, session#=1, ose=0:
ORA-02068: following severe error from PRODLINK
ORA-03113: end-of-file on communication channel
*** 2008-01-17 01:32:23.176
ERROR, tran=2.39.57684, session#=1, ose=0:
ORA-02068: following severe error from PRODLINK
ORA-03113: end-of-file on communication channel

Is there any way to kill that tran=? it seems that is a hanged transaction, can it be?
Or i think that maybe droping the dblink and recreating it maybe works but i want to know what you think
thnx in advance
Re: kill hanged transaction [message #294453 is a reply to message #294451] Thu, 17 January 2008 12:33 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
>>end-of-file on communication channel

usualy happens when there is a broken connection between client and server.
Re: kill hanged transaction [message #294456 is a reply to message #294453] Thu, 17 January 2008 12:39 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

gkrishn wrote on Thu, 17 January 2008 12:33
>>end-of-file on communication channel

usualy happens when there is a broken connection between client and server.

yes i think the same but the users are using now that dblink, and is active.
maybe dropping and recreanding is the best way
but... i want to know if i want to kill that transaction or drop what´s the way to do that? because my system manager says that few months ago... there was a problem similar that and the solution was closing that transaction
if you see. is the same number of transaction that want to do the same every minute.
thnx in advance again
Re: kill hanged transaction [message #294458 is a reply to message #294451] Thu, 17 January 2008 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It could also be an Oracle bug as for ORA-00600 or ORA-07445.
As we don't know what you did and your Oracle version with 4 decimals, we can't say.

Regards
Michel
Re: kill hanged transaction [message #294459 is a reply to message #294451] Thu, 17 January 2008 12:45 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Recreating DBlink- How do that help ?
Make sure you have better connectivity to the destination.Use PING ,or try to connect your self through any sqlclient.

Re: kill hanged transaction [message #294465 is a reply to message #294458] Thu, 17 January 2008 12:55 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Thu, 17 January 2008 12:43
It could also be an Oracle bug as for ORA-00600 or ORA-07445.
As we don't know what you did and your Oracle version with 4 decimals, we can't say.

Regards
Michel


Sorry Michael you're right
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE    8.1.7.0.0       Production
TNS for Solaris: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

[Updated on: Thu, 17 January 2008 12:56]

Report message to a moderator

Re: kill hanged transaction [message #294473 is a reply to message #294459] Thu, 17 January 2008 13:19 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

gkrishn wrote on Thu, 17 January 2008 12:45
Recreating DBlink- How do that help ?
Make sure you have better connectivity to the destination.Use PING ,or try to connect your self through any sqlclient.




i do
select * from dba_db_links where db_link like 'PRODLINK';

OWNER       DB_LINK     USERNAME    HOST        CREATED
---------------------------------------------------------
PUBLIC      PRODLINK    APPS       tXILEP      13-JUL-07


then i do
bash-2.05$ 
bash-2.05$ tnsping tXILEP

TNS Ping Utility for Solaris: Version 8.1.7.4.0 - Production on 17-JAN-2008 17:18:49

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=13.179.1.54)(Port=1531))
OK (0 msec)


I Can do a select in the remote database without any problem
any idea?

[Updated on: Thu, 17 January 2008 13:20]

Report message to a moderator

Re: kill hanged transaction [message #294474 is a reply to message #294473] Thu, 17 January 2008 13:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Transient network error?

Regards
Michel
Re: kill hanged transaction [message #294476 is a reply to message #294465] Thu, 17 January 2008 13:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this the same version on both side?

Regards
Michel
Re: kill hanged transaction [message #294546 is a reply to message #294451] Thu, 17 January 2008 23:51 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member
It appears a case of RECO attempting to recover a 2PC transaction. Please try to avoid using DBLINKS over unreliable network links. Your traces in first post indicates RECO making an attempt to resolve transaction almost every 3 minutes or so. See your logs/traces to see further if RECO was finally able to resolve transaction after transient network failure or not. By default RECO will continue to resolve the transaction until either success or you manually rollback 2PC transaction. I do not know if transaction was worth or not for you & you know this better than any one else in this forum.

Use DBA_2PC_PENDING to view the current status & act according to your requirement. Also have a look on Distributed Transactions in docs. Given below please find a web pointer, If distributed transactions are of interest to you.

http://download.oracle.com/otndocs/products/rdb/pdf/rdbtf05_disttrans.pdf

http://www.remote-dba.net/tp_commit_processing_SQL_Net.htm


Regards

Manjit Kumar [mkbhati]

[Updated on: Thu, 17 January 2008 23:58]

Report message to a moderator

Re: kill hanged transaction [message #294663 is a reply to message #294476] Fri, 18 January 2008 06:35 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Thu, 17 January 2008 13:47
Is this the same version on both side?

Regards
Michel


yes michael 8.1.7.4.
in both sides


i think that mkbhati is right... ill be search for his side maybe there is a problem with reco
Re: kill hanged transaction [message #294668 is a reply to message #294663] Fri, 18 January 2008 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Actually reco is trying to solve a distributed transaction, that is for sure. Why it can't do it is the root problem and so my question.

Of course, you can solve it immediatly if you search for and manually force the end of these distributed transactions but you then don't know why this problem happened.

If you want to know how to end distributed transactions either refer to Metalink notes 100664.1 "How to Troubleshoot Distributed Transactions" and 1012842.102 "ORA-2019 ORA-2058 ORA-2068 ORA-2050: Failed Distributed Transactions", or go to PSOUG Daniel Morgan's library Transactions page.

Regards
Michel
Re: kill hanged transaction [message #294761 is a reply to message #294668] Sat, 19 January 2008 00:41 Go to previous message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member


Nice pointers provided by Michel.

Regards

Manjit Kumar [mkbhati]
Previous Topic: Oracle OEM console
Next Topic: ORA-1110 and ORA-1122 when trying startup upgrade
Goto Forum:
  


Current Time: Sat Dec 10 10:45:17 CST 2016

Total time taken to generate the page: 0.11912 seconds