GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Info on streams error ORA-24034?

edited Apr 17, 2015 10:05AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

Got this error from a failed Streams setup on two database servers (probably Linux 11.2.0.3).  Neither had streams set up on them before:

 

ERROR at line 1:

ORA-23616: Failure in executing block 12 for script

132596015DD53AEBE05347827810B48C with

ORA-24034: application APPLY$_CMDB1_1 is already a subscriber for queue

STRMADMIN.APPLY$_CMDB1_1_Q

More than a warning (as seen in Middleware documentation), this Streams implementation fails:

 

Output Log

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 7 16:05:38 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> SQL> SQL> Executing ..

SQL> connect STRMADMIN/******

SQL> Connected.

SQL> SQL> Executing ..

SQL> DROP DATABASE LINK CMDB2

SQL> DROP DATABASE LINK CMDB2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center