ORA-25205 IN REPLICATION MODE !

HELLO

I HAVE DESIGNED A MULTI-MASTER REPLICATION WITH 3 DATABASES.AS YOU KNOW BEFORE UPDATING THE TABLES
IN MASTER DEFINITION SITE I MUST CHANGE THE MODE OF
REPLICATION TO "NORMAL".I CHANGE IT AND THEN I TRY TO UPDATE ONE OF MY TABLES IN MASTER GROUP BUT WHEN I WANT TO INSERT A ROW ,I RECIEVE THIS ERROR :
ORA-25205 : THE QUEUE SYSTEM.DEF$_AQCALL DOES NOT EXIST.

WOULD YOU PLEASE TELL ME WHAT HAPPEND?
I DONT EXACTLY KNOW WHAT IS IT? JUST I KNOW IT IS A QUEUE TABLE!!!

THANK YOU SO MUCH.
PARVIN

You need to create the queue first before specifying it for enqueue. The queue is created by the script catdefrt.sql.

The queue table needs to be dropped before running catdefrt.sql.

First alter session set events '10851 trace name context forever, level 2';

drop table system.def$_aqcall;
drop table system.def$_aqerror;

Rerun catdefrt.sql to recreate the queues and the queue tables.

DEAR JULIAN,
I DID WHAT YOU SAID,BUT I RECIEVED THIS ERROR:
ORA-24005 : MUST USE DBMS_AQADM.DROP_QUEUE_TABLE
TO DROP QUEUE TABLE;

I DROPED QUEUE TABLES VIA DBMS_AQADM.DROP_QUEUE_TABLE AND THEN EXECUTED CATDEFRT.SQL ,MY PROBLEM IS SOLVED AND NOW I AM
VERY GRATEFUL .


WITH BEST REGARDS
PARVIN