After following ALL necessary pre-reqs for configuring A unidirectional streams replication between 2 test databases, I ran the MAINTAIN_SCHEMAS procedure for 2 schemas, but I'm getting the following errors (please see attachment).
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.
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 STREAMS_ADMIN.DBMS_AQADM@TESTDB2.DOMAIN.ORG
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