| Deadlock detected [message #75644] |
Mon, 24 November 2003 08:30  |
Mahesh
Messages: 90
Registered: January 2001
|
Member |
|
|
While creating apply process,i am getting following error message. Could you please help me?
SQL> BEGIN
2 DBMS_APPLY_ADM.CREATE_APPLY(
3 queue_name => 'strmadmin.streams_queue',
4 apply_name => 'apply_oe',
5 rule_set_name => 'strmadmin.apply_oe_rs',
6 message_handler => 'oe.mes_handler',
7 apply_user => 'oe',
8 apply_captured => false);
9 END;
10 /
BEGIN
*
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object
STRMADMIN.STREAMS_QUEUE
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 0
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3801
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 87
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 553
ORA-06512: at line 2
Could you please help me?
Regards
Mahesh R
|
|
|
|
| Re: Deadlock detected [message #75645 is a reply to message #75644] |
Mon, 24 November 2003 11:53  |
Frank Naude
Messages: 4595
Registered: April 1998
|
Senior Member |
|
|
Hi,
Try to stop and drop, your previously defined
queue/ queue table before defining a new one. Look at
this example:
begin
DBMS_AQADM.STOP_QUEUE(
queue_name => 'strmadmin.streams_queue');
DBMS_AQADM.DROP_QUEUE(
queue_name => 'strmadmin.streams_queue');
DBMS_AQADM.DROP_QUEUE_TABLE(
queue_table => 'strmadmin.streams_qtable',
force => TRUE);
end;
/
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
