Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBMS_SCHEDULER.ENABLE and already a subscriber

741357Jul 6 2012 — edited Jul 18 2012
I have migrated a database from 10.2.0.4 on Solaris to 11.2.0.3 on Windows and have a problem with enabling one job que. Enable fails, and returns that "nothing" is already subscribed to it:
BEGIN
  SYS.DBMS_SCHEDULER.ENABLE
    (name => 'CIPS.DDREQ_QUEUE_JOB',
   commit_semantics  => 'STOP_ON_FIRST_ERROR');

END;
Error at line 55
ORA-24034: application  is already a subscriber for queue 
ORA-06512: at "SYS.DBMS_ISCHED", line 4395
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2803
ORA-06512: at line 2
ALL_QUEUE_SUBSCRIBERS contains (relevent):
SELECT *
  FROM ALL_QUEUE_SUBSCRIBERS
 WHERE owner = 'CIPS';

CIPS,DDREQ_QUEUE,DDREQ_QUEUE_TABLE,SCHEDULER$_EVENT_AGENT,null,0,null,PERSISTENT,NO,FALSE
The same job code works fine in the old db, and will do everything in the new one execpt enable. Very frustrating.

Q: What do I querry to find this blank subscriber?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 15 2012
Added on Jul 6 2012
#advanced-queueing, #database-key-features
2 comments
1,214 views