10gR2 Stremaas Config errors
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: 10gR2 Stremaas Config errors

  1. #1
    Join Date
    Nov 2006
    Posts
    158

    10gR2 Stremaas Config errors

    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.
    Attached Files Attached Files
    Regards,

    divroro12

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    source_database => 'TESTDB1.DOMAIN.ORG,

    Missing the ending single quote

  3. #3
    Join Date
    Nov 2006
    Posts
    158
    Hi Stecal,

    That was a typo. The script I ran had the quote
    Regards,

    divroro12

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Well, please post what you tried, not what you typed elsewhere.

  5. #5
    Join Date
    Nov 2006
    Posts
    158
    It's what I tried, but I had to modify certain names for security reasons
    Regards,

    divroro12

  6. #6
    Join Date
    Nov 2006
    Posts
    158
    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 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
    Regards,

    divroro12

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    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

  8. #8
    Join Date
    Nov 2006
    Posts
    158
    That's checked & verified for the STREAMS_ADMIN user which in this case has the same username/password on both SOURCE & target.
    Regards,

    divroro12

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    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.

  10. #10
    Join Date
    Nov 2006
    Posts
    158
    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.
    Regards,

    divroro12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width