Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

974427Feb 25 2013 — edited Feb 26 2013
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2013
Added on Feb 25 2013
5 comments
4,571 views