Troubleshooting guide

Configuring Replication Agent
Review the procedures for configuring Replication Agent for Oracle.
Primary Oracle Database Configuration for Replication
Configure the primary Oracle database for replication and to ensure that the Oracle redo log
data is not overwritten before it is read by Replication Agent.
Verifying the Current Archive Setting of the Redo Logs
Verify that redo logging, which Oracle uses to maintain a log infrastructure, is turned on. Turn
redo logging on only in the primary database.
1.
Use SQLPLUS to connect to Oracle as a system administrator.
2.
From SQLPLUS, run:
select log_mode from v$database;
• If the archive log is on, you should see:
LOG_MODE
--------
ARCHIVELOG
3.
To turn on log archiving:
shutdown;
startup mount;
alter database archivelog;
alter database open;
See the
Replication Agent Primary Database Guide .
Verifying the Supplemental Logging of Primary Key Data
Verify that Oracle logs the values of the primary keys and unique indexes.
By default, Oracle does not log primary keys and unique indexes. For successful replication of
all table values, you must log these values.
1.
Use SQLPLUS to connect to Oracle as a system administrator:
SELECT SUPPLEMENTAL_LOG_DATA_MIN,
SUPPLEMENTAL_LOG_DATA_PK,
SUPPLEMENTAL_LOG_DATA_UI
FROM V$DATABASE;
If logging of primary key and unique index values is enabled, the return values are:
SUP SUP SUP
--- --- ---
YES YES YES
2.
If the result is different, turn on supplemental logging by executing:
CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 35