Configuring Oracle LogMiner

Configure Oracle LogMiner on the primary Oracle database.

1. If you have not already installed Oracle LogMiner, go to $ORACLE_HOME/rdbms/admin, log in as a “sys as sysdba” user, and execute the Oracle LogMiner installation script:

   @dbmslm.sql

2. If the public synonym DBMS_LOGMNR does not exist, 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;