This discussion is archived
5 Replies Latest reply: Feb 26, 2013 4:36 AM by 974427 RSS

Streams "apply rules" giving ORA-24010: QUEUE "STRMADMIN"."STREAMS_QUEUE"

974427 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points