Home » Server Options » Streams & AQ » 10gR2 Streams Configuration error (Oracle database 10.2.0.4)
10gR2 Streams Configuration error [message #488858] Tue, 11 January 2011 13:59 Go to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
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.
Re: 10gR2 Streams Configuration error [message #489573 is a reply to message #488858] Mon, 17 January 2011 11:19 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
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.


Attached is the log file file generated when the schema replication script was successfully ran.
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



Re: 10gR2 Streams Configuration error [message #490041 is a reply to message #489573] Thu, 20 January 2011 12:21 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
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.

Regards,

- divroro12 -
Re: 10gR2 Streams Configuration error [message #490049 is a reply to message #490041] Thu, 20 January 2011 12:44 Go to previous message
Michel Cadot
Messages: 58927
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: OLTP to OLAP data transfer - CDC or Streams?
Next Topic: Capture process does not start
Goto Forum:
  


Current Time: Thu Aug 28 08:21:10 CDT 2014

Total time taken to generate the page: 0.10947 seconds