Hi ALL,

I removed the streams configuration on both databases, then used the following PL/SQL procedure tro generate the schema replication script,
which I then manually ran. It ran smoothly & successfully completed in the SOURCE DB, ALL schemas were replicated in the target, BUT the propagation
stopped after awhile (16 attempts) with the errors shown below.

Script generation
==================

SQL> BEGIN
2 DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
3 schema_names => 'CFVARIABLES,FURLADMIN',
4 source_directory_object => 'STREAMS_DIR',
5 destination_directory_object => 'STREAMS_DIR',
6 source_database => 'TESTDB1.DOMAIN.ORG',
7 destination_database => 'TESTDB2.DOMAIN.ORG',
8 capture_name => 'CAPTURE_TESTDB1',
9 capture_queue_table => 'CAPTURE_TESTDB1_QT',
10 capture_queue_name => 'CAPTURE_TESTDB1_QN',
11 capture_queue_user => 'STREAMS_ADMIN',
12 propagation_name => 'PROPAGATION_TESTDB2',
13 apply_name => 'APPLY_TESTDB2',
14 apply_queue_table => 'APPLY_TESTDB2_Qt',
15 apply_queue_name => 'APPLY_TESTDB2_QN',
16 apply_queue_user => 'STREAMS_ADMIN',
17 bi_directional => FALSE,
18 include_ddl => TRUE,
19 instantiation => DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA,
20 perform_actions => FALSE,
21 script_name => 'schema_replication.sql',
22 script_directory_object => 'STREAMS_DIR'
23 );
24 END;
25 /

PL/SQL procedure successfully completed.
Below are the errors encountered:


Wed Jan 12 11:23:22 2011
Propagation Schedule for (STREAMS_ADMIN.CAPTURE_TESTDB1_QN, "STREAMS_ADMIN"."APPLY_TESTDB2_QN"@TESTDB2.DOMAIN.ORG) encountered following error:
ORA-04052: error occurred when looking up remote object [email protected]
ORA-00604: error occurred at recursive SQL level 4
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from TESTDB2
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1087
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7636
ORA-06512: at "SYS.DBMS_AQADM", line 631
ORA-06512: at line 1

When I look inside the alert.log file in the target DB, I see this:

Wed Jan 12 11:03:22 2011
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=57, OS id=20755
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_SCHEMA_01', 'STREAMS_ADMIN', 'KUPC$C_1_20110112110323', 'KUPC$S_1_20110112110323', 0);
kupprdp: worker process DW01 started with worker id=1, pid=58, OS id=20762
to execute - SYS.KUPW$WORKER.MAIN('SYS_IMPORT_SCHEMA_01', 'STREAMS_ADMIN');

=================================
Wed Jan 12 11:05:08 2011
Thread 1 advanced to log sequence 43124
Current log# 1 seq# 43124 mem# 0: /localfs/oradata/TESTDB2/redo/redo01.log
Wed Jan 12 11:05:24 2011
Streams APPLY A001 started with pid=57, OS id=21444
Streams Apply Reader started P000 with pid=20 OS id=21449
Streams Apply Server started P001 with pid=58 OS id=21451