Printable View
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).
Your input will be highly appreciated.
source_database => 'TESTDB1.DOMAIN.ORG,
Missing the ending single quote
Hi Stecal,
That was a typo. The script I ran had the quote
Well, please post what you tried, not what you typed elsewhere.
It's what I tried, but I had to modify certain names for security reasons
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
Based on what you posted, wouldn't you want to check the username/password you used in the database link? Isn't that what Oracle is telling you?
invalid username/password; logon denied
That's checked & verified for the STREAMS_ADMIN user which in this case has the same username/password on both SOURCE & target.
Then I guess you should figure out a way to inform Oracle that is the case and tell it to somehow ignore the logon error.
And that's why I'm in this forum to seek help on that. If I knew I guess, I wouldn't be here in the 1st place.
I finally resolved my issue by changing the probagation mode from queue-to-queue (which was the default) to queue-to-dblink as specified in Metalink Note IDs 233099.1 and 827473.1.
All's STREAMING fine so far what no alert log errors.
Thanks for sharing the solution.
Thanks,