DBMS_AQADM.SCHEDULE_PROPAGATION from Dbconsole fails with ORA-2019 (Doc ID 1317073.1)

Last updated on SEPTEMBER 05, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Creating the propagation schedule from DBConsole fails.
The alert log file show the error ORA-2019: connection description for remote database not found.

We found that the DBConsole writes the link name in double quotes ("database link name").

begin DBMS_AQADM.SCHEDULE_PROPAGATION
(queue_name => '"test"."test_queue"',
destination => '"another_db.world"', <=======
start_time => to_date('8/23/2009 1.0.0 ','MM/DD/YYYY HH24.MI.SS'),
duration => 120,
next_time => 'SYSDATE + (1*60)/86400 - 120/86400',
latency => 60);
end;
/

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms