Troubleshooting guide

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY
KEY, UNIQUE INDEX) COLUMNS;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
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.
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;
Creating Oracle User and Grant Permissions
Create an Oracle database user for use by Replication Agent when connected to the primary
database.
Note: Permission to grant access to objects owned by “SYS” may require the command to be
executed by an Oracle user with
sysdba
privileges.
1.
Use SQLPLUS to connect to the primary database as a system administrator and run these
commands to create an Oracle user named “RA_USER,” specified by pds_username,
with the password “sybase,” and grant permissions to the user:
CREATE USER RA_USER PROFILE "DEFAULT" IDENTIFIED
BY "sybase" DEFAULT TABLESPACE "USERS" ACCOUNT
UNLOCK;
GRANT ALTER ANY PROCEDURE TO RA_USER;
GRANT ALTER ANY TABLE TO RA_USER;
GRANT ALTER DATABASE TO RA_USER;
GRANT ALTER SESSION TO RA_USER;
GRANT ALTER SYSTEM TO RA_USER;
GRANT CONNECT TO RA_USER;
GRANT CREATE PROCEDURE TO RA_USER;
GRANT CREATE PUBLIC SYNONYM TO RA_USER;
GRANT CREATE SESSION TO RA_USER;
GRANT CREATE TABLE TO RA_USER;
GRANT DROP ANY PROCEDURE TO RA_USER;
GRANT DROP ANY TABLE TO RA_USER;
GRANT DROP PUBLIC SYNONYM TO RA_USER;
GRANT EXECUTE_CATALOG_ROLE TO RA_USER;
GRANT EXECUTE ON SYS.DBMS_FLASHBACK TO RA_USER;
GRANT EXECUTE ON SYS.DBMS_LOCK TO RA_USER;
GRANT RESOURCE TO RA_USER;
GRANT SELECT ANY TRANSACTION TO RA_USER;
GRANT SELECT_CATALOG_ROLE TO RA_USER;
GRANT SELECT ON SYS.ARGUMENT$ TO RA_USER;
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
36 Replication Server