Load Ingest Data
Results 1 to 2 of 2

Thread: Exact DB changes and grants to be provided to enable CDC in oracle source

  1. #1
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0

    Exact DB changes and grants to be provided to enable CDC in oracle source

    Hi Experts,

    I have performed the below steps but still getting an error while performing the CDC for oracle source. Attached is the log for the same.
    Could you help me with the exact grants to be provided.

    STEPS TO ENABLE DATA LOGGING FOR CDC:
    1)

    1. SELECT on V_$LOGMNR_LOGS TO <USER_NAME> ;
    2. SELECT on V_$LOGMNR_CONTENTS TO <USER_NAME> ;



    2) Enable supplemental logging by executing the following query:

    Query:
    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

    3) Turn On the Archivelog mode
    Query:

    ALTER DATABASE ARCHIVELOG;
    Attached Files Attached Files

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    this error means the Oracle user you are using does not have proper permissions to access the Log Minor.


    To demonstrate this you can login to Oracle using sqplus with the as same account as your connection string and try to add a log:


    --- CUT ---
    SQL> select * from v$log;


    SQL> begin
    dbms_logmnr.add_logfile ( logfilename => '/z8qs/fra/Z8QS/archivelog/2016_12_15/o1_mf_1_36699_d54tj0ml_.arc', options => dbms_logmnr.new);
    end;
    /
    --- CUT ---


    Please, check the Oracle users and make sure they are able to access the Log Minor. You can get the needed privileges list from AR user guide.

Posting Permissions

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