Home » Server Options » Streams & AQ » error in database link during propagation
error in database link during propagation [message #270206] Wed, 26 September 2007 02:32 Go to next message
carthik7
Messages: 5
Registered: September 2007
Junior Member
while executing the below propagation block, its throwing the below mentioned error.

BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name => 'user1.ADDRESS',
streams_name => 'user1_propagation',
source_queue_name => 'strmadmin.user1_source_queue',
destination_queue_name => 'strmadmin.user1_target_queue@oracle@oracle',
include_dml => true,
include_ddl => false,
source_database => 'orcl',
inclusion_rule => true
);
END;
/

ERROR at line 1:

ORA-24045: invalid agent address strmadmin.user1_target_queue@oracle@oracle, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]

I have created a dblink from source to target database as

CREATE DATABASE LINK oracle@oracle
CONNECT TO strmadmin
IDENTIFIED BY strmadmin
USING oracle;
where my global name is oracle and connection string is oracle.

Any fix or solution for this.

Thanks in advance
Re: error in database link during propagation [message #270222 is a reply to message #270206] Wed, 26 September 2007 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try 'strmadmin.user1_target_queue@"ORACLE@ORACLE"'

Regards
Michel

[Updated on: Wed, 26 September 2007 03:35]

Report message to a moderator

Re: error in database link during propagation [message #270224 is a reply to message #270206] Wed, 26 September 2007 03:34 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

my global name is oracle and database link oracle@oracle..

Database link will be same as global name , i.e oracle.
Previous Topic: update errors overwrite
Next Topic: Enqueue when the db down
Goto Forum:
  


Current Time: Thu Mar 28 14:00:44 CDT 2024