| ORA-02049 [message #217443] |
Fri, 02 February 2007 04:17  |
karismapanda
Messages: 58
Registered: January 2007
|
Member |
|
|
Hi,
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
thanks
|
|
|
|
| Re: ORA-02049 [message #217590 is a reply to message #217443] |
Fri, 02 February 2007 22:41  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
HI,
Increase distributed_lock_timeout value.
http://www.mail-archive.com/oracle-l@fatcity.com/msg83128.html
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.
regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
