1 Reply Latest reply: Apr 25, 2013 12:56 AM by Rc-Oracle RSS

    STREAMS APPLY GIVES ORA-24010: QUEUE "STRMADMIN"."STREAMS_QUEUE"

    974427
      Hi all,
      I am trying to configure streams on 11.1.0.6.0, windows 64 bit. i am getting "ORA-24010: QUEUE "STRMADMIN"."STREAMS_QUEUE" does not exist" .
      I am following https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=192958686993608&_afrWindowMode=0&_adf.ctrl-state=14jv3ep8j4_4

      1st i created users (strmadmin) in "oracle" and "prod" databases along with "aq_administrator_role,dba" to the same users and "execute dbms_streams_auth.grant_admin_privilege('STRMADMIN'); on both databases.
      "test" schema is to be replicated from "oracle" to "prod"

      @oracle
      i ran "dbms_streams_adm.set_up_queue", next created database link to "prod"

      @prod
      SQL> BEGIN
      2 DBMS_STREAMS_ADM.SET_UP_QUEUE(
      3 QUEUE_TABLE => 'STREAMS_QUEUE_TABLE',
      4 QUEUE_NAME => 'STREAMS_QUEUE',
      5 QUEUE_USER => 'STRMADMIN');
      6 END;
      7 /
      PL/SQL procedure successfully completed.

      SQL> BEGIN
      2 DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
      3 SCHEMA_NAME => 'TEST',
      4 STREAMS_TYPE => 'APPLY',
      5 STREAMS_NAME => 'STREAM_APPLY',
      6 QUEUE_NAME => 'STRMADMIN.STREAMS_QUEUE',
      7 INCLUDE_DML => TRUE,
      8 INCLUDE_DDL => TRUE,
      9 SOURCE_DATABASE => 'ORACLE');
      10 END;
      11 /
      BEGIN
      *
      ERROR at line 1:
      ORA-24010: QUEUE "STRMADMIN"."STREAMS_QUEUE" does not exist
      ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 346
      ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 439
      ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 397
      ORA-06512: at line 2

      not sure where what is wrong... kindly help me.