Please enable JavaScript to view this site.

Navigation: Change Data Capture > Oracle > Oracle LogMiner Capture

Implementation Checklist

Scroll

This checklist covers the tasks required to prepare the operating environment and configure the Oracle LogMiner API Data Capture Agent. Before beginning these tasks however, the base product must be installed. Refer to the Connect CDC SQData Installation Guide for an overview of the entire product and the installation instructions and prerequisites.

Note, some organizations do not permit third party software to be installed on the Oracle database server platform. Connect CDC SQData supports remote capture of Oracle from another platform using essentially the same configuration described below. The configuration tasks that must be performed on the Oracle server and Capture platforms are identified below..

#

Task


Prepare Environment

1

Identify Source and Target System and Datastores (DB Server)

2

Prepare Client Platform

3

Identify/Authorize Operating User(s)

4

Create Variables Directories

5

Prepare Oracle for Capture

6

Ensure Availability of Oracle Dictionary

7

Reserve TCP/IP Ports

8

Generate Public / Private Keys and Authorized Key File


Environment Preparation Complete

 


Setup CDCStore Storage Agent  

1

Size the Storage Pool

2

Create the CDCStore CAB file


Storage Agent Setup Complete

 


Setup Oracle LogMiner Capture Agent

1

Configure Oracle Tables for Capture (DB Server)

2

Create Oracle Capture CAB File

3

Prepare LogMiner API Capture Shell Script


Capture Agent Setup Complete

 


Setup Controller Daemon

1

Create Access Control List

2

Create Agent Configuration File

3

Prepare Controller Daemon Shell Script


Controller Daemon Setup Complete

 


Configure Engine

1

Generate Public / Private Keys

2

Specify Source Datastore in Engine Script

3

Prepare Engine Shell Script


Engine Configuration Complete

 


Component Verification

1

Start the Controller Daemon

2

Start the Capture Agent

3

Start the Engine

4

Execute Test Transactions


Verification Complete