+1 (778) 681-0711

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2

Duration : 4 Days (32 Hours)

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 Course Overview:

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 is a course designed to equip IT professionals, developers, and architects with the necessary skills to use Oracle GoldenGate 12c, focusing on installation, configuration, management, monitoring, and troubleshooting of Exadata Cloud Service. It covers replication transactions, Conflict Detection and Resolution (CDR), Oracle Active Data Guard, heterogeneous database configuration, real-time data transformation, and performance optimization, providing preparation for Oracle GoldenGate 12c Administration I and II exams.

Intended Audience:

  1. Database Administrators: Those responsible for managing and maintaining Oracle Databases, with a focus on data activity and integrity.
  2. System Administrators: IT professionals involved in administering and managing system-level configurations.
  3. IT Professionals: Individuals with roles related to data management and integrity in Oracle Databases.
  4. Business Analysts: Professionals analyzing business processes and data requirements.
  5. Business Intelligence Professionals: Those involved in data analysis and reporting to support business decision-making.
  6. Application Developers: Developers working with Oracle Databases and seeking an understanding of GoldenGate replication technology.
  7. Oracle Database Users: Individuals who use Oracle Databases and want an extensive overview of GoldenGate replication technology.
  8. Users Interested in Replication: Individuals seeking knowledge on designing, deploying, and maintaining a heterogeneous data replication system.
  9. Data Replication Managers: Professionals responsible for managing data replication processes in their organization.

Learning Objectives of Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2:

1. Understand the Oracle GoldenGate 12c architecture, components, and supported replication types.
2. Learn how to use the Oracle GoldenGate Director GUI and Command-line Interface as a client interface to the Oracle GoldenGate Manager.
3. Know how to design, debug, test and troubleshoot Oracle GoldenGate data replication processes.
4. Learn to implement Oracle GoldenGate replication to and from Oracle databases, Oracle TimesTen In-Memory Databases, and non-Oracle targets.
5. Be able to configure complex replication scenarios and modify existing Oracle GoldenGate configurations for high availability and scalability.
6. Acquire the knowledge necessary to monitor and maintain daily replication tasks and be able to integrate with existing Business processes.
7. Set up Data security mechanisms and deploy best practices to secure data environments.

 Module 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
  • 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 Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories
  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package
  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat
  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
  • 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 Parameter Files
  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters
  • 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
  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences
  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security
  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues
  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 Course Prerequisites:

  1. Basic Understanding of Oracle Database and SQL: Participants should have a foundational understanding of Oracle Database concepts and SQL queries.
  2. Prior Experience with Oracle GoldenGate: It is recommended that students have prior hands-on experience with Oracle GoldenGate, as the course builds upon existing knowledge of the software.
  3. Understanding of IT Parameters: Students should have a general understanding of IT parameters, including hardware, software, topology, distributed systems, and security concepts. This knowledge is essential for comprehending the complexities of Oracle GoldenGate and its integration into IT environments.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability

Classroom

  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention

Onsite

  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.
×