ORA-600 [kwqbdrcp101] after Drop or Recreate of Propagation


Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later]
Information in this document applies to any platform.

Symptoms:
ORA-00600: internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], []
Current SQL statement for this session:
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN next_date := sys.dbms_aqadm.aq$_propaq(job); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

Stack trace
ksedst <- ksedmp <- ksfdmp <- kgerinv <- kgeasnmierr
<- kwqbdrcp <- kwqbdfetchbuf <- kwqbdeq <- kwqidabm <- kwqididqx
<- kwqididq <- kwqpdeq <- kwqpdest <- kwqjswucb <- rpiswu2
<- kwqjpropwin <- kwqjaq <- spefcmpa <- spefmccallstd <- pextproc
<- peftrusted <- psdexsp <- rpiswu2 <- psdextp <- pefccal
<- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun
<- plsql_run <- peicnt <- kkxexe <- opiexe <- opiodr
<- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv
<- rpiexe <- kkjex1e <- kkjsexe <- kkjrdp <- opirip
<- opidrv <- sou2o <- opimai_real <- main <- $START$

Queue_to_queue is false.
Changes
Recreate the streams environment.
Drop/recreate the propagation.
Cause

Due to message existence in Queue.

Solution
1. Stop the Propagation.
exec DBMS_PROPAGATION_ADM.STOP_PROPAGATION('');

2. Drop the Propagation.
exec DBMS_PROPAGATION_ADM.DROP_PROPAGATION('');

3. Purge the Queue table.
DECLARE
options dbms_aqadm.aq$_purge_options_t;
BEGIN
options.delivery_mode:=DBMS_AQADM.BUFFERED;
DBMS_AQADM.PURGE_QUEUE_TABLE('',NULL,options);
END;
/

4. Create the Propagation.
BEGIN
DBMS_PROPAGATION_ADM.CREATE_PROPAGATION(
propagation_name => '',
source_queue => '.',
destination_queue => '.',
destination_dblink => '' ,
rule_set_name => '', -- specify rule_set name, if you want
propagation to use a rule_set, otherwise eliminate this parameter.
);
END;
/

This post is about Specific ORA-0600 error, I would recommend to see General approach for troubleshooting  ORA-00600 and ORA-07445 Internal error which is applicable to all ORA-07445 Internal error and ORA-00600 internal errors.
Reference Note:  ORA-600 [kwqbdrcp101] after Drop or Recreate of Propagation [ID 1322207.1]

3 comments:

  1. Its like you learn my mind! You seem to know a lot
    about this, such as you wrote the e book in it or something.

    I think that you simply can do with some p.c. to pressure the message home a little bit,
    however other than that, this is excellent blog.
    A great read. I will definitely be back.

    Review my weblog - Forex Binary Options Brokers

    ReplyDelete
  2. im getting this error ora:00600 while cloning the database plz help me how to slove this

    ReplyDelete
    Replies
    1. For any ORA-600 and ORA-7445 I would suggest to go to Support.oracel.com and search there. You can find so may bugs for that and work accordingly.

      Delete