Data Replication 2
Results 1 to 3 of 3

Thread: Replication getting error and stopped

  1. #1
    bitra is offline Junior Member
    Join Date
    Oct 2017
    Posts
    1
    Rep Power
    0

    Replication getting error and stopped



    Hi Support Team,

    Can you please help on this replication issue.



    1. What are the limitations of attunity replication.
    2. How can we replicate online transaction data from source to target
    3. During the testing I am doing the DML operations and trying to replicate in target which is not going to replicate.


    In log file I seen some errors like insufficientprivilege errors. Please let me know the work around to avoid the errors.

    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]D: Start LogMiner Session in thread '1' for: StartScn '000000516C8D',MaxScn '000000518A2E', LastTransactionScn '000000000000', ScnNotFoundError'0' (oracdc_reader.c:820)
    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]D: LogMiner failed to add Redo log '/u101/oradata/Install/NEWDB/NEW12R2/redo01.log'with sequence '112' in thread '1': ORA-01031:insufficient privileges
    ORA-06512: at"SYS.DBMS_LOGMNR", line 68
    ORA-06512: at line 1 (oracdc_reader.c:653)
    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]D: Failed to add the REDO sequence '112' to LogMiner in thread '1' (oracdc_reader.c:618)
    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]D: Failed to add the REDO sequence '112' to LogMiner in thread '1' (oracdc_reader.c:618)
    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]D: Failed to add the REDO sequence '112' to LogMiner in thread '1' (oracdc_reader.c:618)
    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]D: Failed to add the REDO sequence '112' to LogMiner in thread '1' (oracdc_reader.c:618)
    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]D: Failed to set position in thread '1' (oracdc_reader.c:1957)
    00028442: 2017-10-06T11:35:22 [SOURCE_CAPTURE ]E: Oracle CDC stopped [122301] Oracle CDCmaximum retry counter exceeded. (oracdc_merger.c:901)

    Thanks
    Ramesh Bitra

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    237
    Rep Power
    4
    The error is clear:
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_LOGMNR", line 68

    ====
    In the Replicate user guide, (using Oracle as a source) under Security Requirements you can see all privileges that are required for the user that is used to run the Replicate server. Please make sure that they are granted for the Replicate server user.

  3. #3
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    237
    Rep Power
    4
    Here is another forum about it:

    http://forums.attunity.com/forums/ch...eeded-557.html (Oracle CDC Privileges Needed)

    next time try to use the search.

Posting Permissions

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