1
RPS Consulting Pvt. Ltd. – www.rpsconsulting.in
Course Name:
Oracle Goldengate Fundamentals, Troubleshooting and Tuning
Duration:
5 Days
Course outline:
Day 1
Technology Overview
• Creating Oracle GoldenGate Topologies
• Reviewing Oracle GoldenGate Use Cases
• Assembling Building Blocks
• Listing Supported OS
• Listing Supported Databases
• Listing the Oracle GoldengGate Product Line
• Describing GUI Management Options
• Listing Non-Database Sources and Targets
Oracle GoldenGate Architecture
• Describing Oracle GoldenGate Process Groups
• Explaining Change Capture and Delivery (with and without a Data Pump)
• Explaining Initial Data Load
• Contrasting Batch and Online Operation
• Explaining Oracle GoldenGate Check pointing
• Describing Commit Sequence Numbers (CSN)
• Describing Oracle GoldenGate Files and Directories
Installing Oracle GoldenGate
• Listing System Requirements Performing Installation Configuring Environment Variables Using
GGSCI
• Running Oracle GoldenGate from the OS shell.
Configuration Overview and Preparing the Environment
• Reviewing Configuration Overview
• Configuring Manager Process
• Creating Source Definitions
• Preparing the Source Database
• Assigning Oracle Database Roles/Privileges Required
• Using DBMS_GOLDENGATE_AUTH Package
Configuring Change Capture (Extract)
• Reviewing Extract Overview
• Accessing Logs on Oracle ASM
• Accessing Logs Remotely
RPS Consulting Course Outline
2
RPS Consulting Pvt. Ltd. – www.rpsconsulting.in
• Configuring Extract Tasks (Classic & Integrated)
• Adding Extract Group
• Editing Extract Parameters
• Extracting Use of Archived Transaction Logs
• Adding Trails
Configuring Change Delivery (Replicat)
• Reviewing Replicat Overview
• Configuring Replicat Tasks (Classic & Integrated)
• Configuring a Sample Environment
• Configuring New Integrated Replicat
Day 2
Configuring Extract Trails and Files (Data Pump)
• Reviewing Extract Trails and Files Overview Describing Trail Formats
• Using Logdump for Viewing Trails Reversing the Trail Sequence Configuring and Using Data Pumps
Performing Initial Load
• Oracle GoldenGate Methods Listing Database-specific Methods Describing Resource Limitations
• Listing Advantages of Oracle GoldenGate Methods Configuring File Load Methods
• Configuring Direct Load Methods Handling Collisions with Initial Load
Editing Configuration Parameters
• Editing Parameter Files
• Contrasting GLOBALS versus Process Parameters Configuring GLOBALS Parameters
• Configuring Manager Parameters
• Configuring Extract Parameters
• Configuring Replicat Parameters
Filtering and Data Selection
• Filtering and Data Selection
• Mapping Columns Between Different Schemas Using Built-in "@" (at) Functions
• Using SQLEXEC to Interact Directly with a Database Configuring New Coordinated Replicat
Day 3
Additional Transformation Concepts
• Configuring and Using User Tokens
• Configuring and Using User Exits
Configuration Options
• Configuring and Using BATCHSQL
• Configuring and Using Compression
• Configuring and Using Encryption
RPS Consulting Course Outline
3
RPS Consulting Pvt. Ltd. – www.rpsconsulting.in
• Configuring and Using Event Actions
• Configuring New Wallet Security
Bidirectional Replication
• Reviewing Bidirectional Considerations
• Detecting Loops
• Avoiding Conflicts
• Configuring and Using Conflict Detection and Resolution
• Describing Identity Types Issues
DDL Replication
• Reviewing Data Description Language Replication Overview
• Configuring and Using Options for DDL Replication
• Configuring and Using String Substitution in DDL
Troubleshooting & Tuning
Day 4
Gathering Evidence
• GGSCI commands
• Viewing Checkpoint Details
• Evaluating a Process Report
• Evaluating a Log Sample
• Gather and evaluate systems logs
• SHOWSYNTAX overview, usage and output
• Logdump overview
• Utilizing the key commands and functionality of Logdump
Startup Problems
• GoldenGate configuration
• Operating system configuration
• Permissions
• Slow startup
Extraction Problems
• Diagnosing a slow Extract
• Solving the issue when Extract abends
• Solving the issue when the Data Pump Extract abends
Replication Problems
• Replicat is not moving or abends
• Replicat abends with Error 509
• Preventing Replicat from exiting
RPS Consulting Course Outline
4
RPS Consulting Pvt. Ltd. – www.rpsconsulting.in
Day 5
Missed Transaction Problems
• Transactions not being processed
• Including missed transactions
Mapping and Synchronization Problems
• Solve mapping problems such as missed definitions and column mappings
Synchronization issues such as out-of-sync rows, tables without keys, character sets,
• and DML on target tables
SQLEXEC Problems
• SQL does not execute
• Tracing SQLEXEC problems
File Maintenance Problems
• Discard file is not created
• Trail file too big or not being purged appropriately
Performance Tuning
• Building the object record for speeding
• Monitoring lag statistics
• Identifying bottlenecks such as lag, network issues, and disk reads
• Tuning Extract and Replicat for optimal performance
If time Permits: (Oracle GoldenGate Director & Oracle GoldenGate Veridata )
Practical:
Excise 1: Installation & Configuration GG on Linux
Excise 2: Performing an Initial Data Load Method
Excise 3: Performing an Online change Synchronization (CDC) – Without Datapump
Excise 4: Performing an Online change Synchronization through Data pump process
Excise 5: Performing Schema Replication through Datapump (DDL – Replication)
Excise 6: Performing a filtering using change capture.
Excise 7: Performing a table differ in column structure – Heterogeneous Method
Excise 8: Performing integrated Capture and Replicat setup (12c New Features)
Excise 9: Performing Online Change Synchronization with the initial data load – Handlecollisions
Excise 10: Performing - Tokens with COLMAP Clause
Excise 11: Performing converting Classic capture to an Integrated Capture (12c New Features)
Excise 12: Performing – Bidirectional Replication (resolving loop deduction)
RPS Consulting Course Outline
5
RPS Consulting Pvt. Ltd. – www.rpsconsulting.in
Excise 13: Create credential store (12c New Features)
Excise 14: Performing- Handling GoldenGate Exceptions and Errors with REPERROR
Excise 15: Performing - Increasing Performance by Splitting Replication Loads (Multiple
replicates)
Excise 16: Performing - Increasing Performance by Coordinated Applies (12c New Features)
Excise 17: Performing - GoldenGate Replication using Macros, User Tokens, Password
Encryption, Trail Encryption and SQLEXEC
Excise 18: Performing - Encryption Using Wallets (12c New Features)
Excise 19: Troubleshoot using logdump and showsyntax utility
RPS Consulting Course Outline
