Troubleshooting guide

22 SQM Awaiting Message 103:0 pds.pdb

62 REP AGENT Awaiting Command pds.pdb

Testing Replication

When you finish setting up the replication system, test that replication works as intended.

Connect to the primary Oracle instance as a regular user, rather than as the maintenance

user.

At the primary Oracle database, create a table named ptab1 to replicate:

CREATE TABLE ptab1

(idno NUMBER PRIMARY KEY,

name VARCHAR2(20));

Grant permissions to any new or existing object to be replicated in the primary database:

grant all on ptab1 to public;

Connect to Replication Agent through isql, and mark the ptab1 table for replication:

pdb_setreptable ptab1, mark

In Replication Agent, create a replication definition against the primary Oracle database:

1> rs_create_repdef ptab1

2> go

Table/Procedure Name RepDef Name Status

------------------------ -------------- --------

<OracleTableOwner>.PTAB1 "<repdefname>" Created

(1 row affected)

Record the name of the replication definition for use later.

At the replicate SAP HANA database instance, create a table named PTAB1:

CREATE TABLE <tableowner>.PTAB1

(IDNO INT PRIMARY KEY,

NAME VARCHAR(20));

Note: SAP HANA database is not case-sensitive and uses uppercase characters if

lowercase characters are provided.

If an owner is not specified with the tablename, the owner of the table—

—is

the user that is signed on at the time the table is created.

Grant permissions to any new or existing object to be replicated in the replicate database so

that the Replication Server maintenance user can update this table:

grant all privileges on <tableowner>.PTAB1 to public

isql –Usa –Psa_pass –SSAMPLE_RS

CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup

Quick Start Guide for SAP HANA Database 47