ORA-25205 IN REPLICATION MODE !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-25205 IN REPLICATION MODE !

  1. #1
    Join Date
    Dec 2001
    Posts
    10

    Post

    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


  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.

  3. #3
    Join Date
    Dec 2001
    Posts
    10

    AN ERROR MESSAGE AND SO MUCH THANKS

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width