 kill hanged transaction [message #294451] |
Thu, 17 January 2008 12:31  |
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 #294456 is a reply to message #294453] |
Thu, 17 January 2008 12:39  |
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 #294459 is a reply to message #294451] |
Thu, 17 January 2008 12:45 |
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 |
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 |
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 #294546 is a reply to message #294451] |
Thu, 17 January 2008 23:51 |
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 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
