Configuring Oracle LogMiner

Configure Oracle LogMiner on the primary Oracle database.

  1. Go to $ORACLE_HOME/rdbms/admin.
  2. Log in as a “sys as sysdba” user.
  3. Execute the Oracle LogMiner installation script:
    @dbmslm.sql
  4. After LogMiner is installed, create a public synonym so that you do not have to log in as the owner to execute LogMiner functions:
    CREATE PUBLIC SYNONYM DBMS_LOGMNR FOR
   SYS.DBMS_LOGMNR;
    Note: This step is required if you are using Oracle 10g.
  5. Grant these privileges to pds_username:

    • EXECUTE_CATALOG_ROLE

    • SELECT ON V_$LOGMNR_CONTENTS

    • SELECT ON V_$LOGMNR_LOGS

    • SELECT ANY TRANSACTION

    Note: The ra_migrate command verifies that these privileges have been granted to pds_username. If these privileges have not been granted at the time ra_migrate is invoked, a warning message is returned and logged in the Replication Agent log file.
Parent topic: Redo and Archive Log Setup