Home » RDBMS Server » Server Administration » ORA-02049
ORA-02049 [message #217443] Fri, 02 February 2007 04:17 Go to next message
Messages: 58
Registered: January 2007
whenever I am trying to load data through dblink getting this error.

SQL> insert into tr_trn@hyd_dblink select * from tr_trn;
insert into tr_trn@hyd_dblink select * from tr_trn
ERROR at line 1:
ORA-02049: timeout: distributed transaction waiting for lock
ORA-02063: preceding line from HYD_DBLINK

when trying to kill the session getting this error.

ORA-00031: session marked for kill

shuting down the db only works.

What should be done to avoid this
Re: ORA-02049 [message #217590 is a reply to message #217443] Fri, 02 February 2007 22:41 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


Increase distributed_lock_timeout value.

ORA-00031: session marked for kill

Cause: The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately (because it is rolling back or blocked on a network operation), but it has been marked for kill. This means it will be killed as soon as possible after its current uninterruptable operation is done.

Action: No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner.

Previous Topic: import error
Next Topic: ora-04031
Goto Forum:

Current Time: Wed Oct 26 16:58:45 CDT 2016

Total time taken to generate the page: 0.16155 seconds