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.
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 |