Setting Up Replication Agent and Oracle to use ra_dumptran and ra_helpop

Troubleshoot using ra_dumptran and ra_helpop.

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.
6. Use ra_dumptran and ra_helpop according to instructions provided in the Replication Agent Reference Manual.