Oracle GoldenGate 12c Essentials course will cover key architectural concepts of GoldenGate with some real hands-on exercises. This course will help you build your Oracle DBA profile by adding a new skill to your technical competencies. GoldenGate is one of the widely-used replication technologies in the market. The capability of GoldenGate to replicate heterogenous databases is the key differentiator in the market. This Oracle 12c GoldenGate Essentials training will cover Oracle to Oracle configurations. It includes hands-on practices of Oracle GoldenGate Management Pack as well. By the end of this course, you will be good at concepts of GoldenGate, Installing GoldenGate, Configuring replications, Configuring Bi-Directional replication, Installing GoldenGate Management Pack, Hands-on with Oracle GoldenGate Monitor and Agent.

Get hands-on experience on Oracle 12c GoldenGate and Mangement Pack.

  • Install and Implement yourself.
  • Simple and easy to understand.
  • Meet industry standards.

System requirements:

  • Laptop/Desktop with at least 6GB RAM.
  • Minimum of Dual Core processor.
  • 150 GB of disk space.

Training details:

  • 26 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

Demo Video:

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

1. SETTING UP SERVERS & USE CASES
1.1 Install Oracle Enterprise Linux servers
1.2 Install Oracle 12c database software
1.3 Setup GoldenGate OS dependencies
1.4 Clone Linux servers
1.5 Configure Oracle databases
1.6 GoldenGate use cases
2. INSTALL GOLDEN GATE 12C
2.1 Supported DB’s
2.2 OS combinations
2.3 Software and OS requirements
2.4 Installation – OUI
2.5 Directories
2.6 Kick start
2.7 New in 12c GG
3. GOLDENGATE 12C ARCHITECTURE
3.1 GG workflow
3.2 Related products
3.3 GG Components
3.4 Architecture basics
3.5 Processes
3.6 Parameters
3.7 Topologies
4. GOLDENGATE WIRE FRAME
4.1. CDC and Delivery
4.2. Role of Datapump in GG
4.3. Integrated extract
4.4. Data load
4.5. CKPT in GG
5. ORACLE TO ORACLE CONFIGURATION BASICS
5.1. Steps to configure
5.2. Preparing environment – Character set
5.3. Configure user – Oracle Database
5.4. Network diagnostics
5.5. Preparing environment – Supplemental logging
5.6. Configuring Manager
5.7. Defgen
6. EXTRACT DATA
6.1. Change capture
6.2. Datapump options
6.3. Process groups
6.4. Configure Wallet
6.5. Integrated Capture
6.6. Extract trails
6.7. Start Extract
6.8. ASM in CDC
7. REPLICATE DATA
7.1. Change delivery basics
7.2. CDD activities
7.3. Treat Collisions
7.4. Integrated Apply
7.5. Monitoring
7.6. Reports & Diagnostics
8. TRAILING
8.1. Extract Trails and Files
8.2. Formats
8.3. Substitutes
8.4. Logdump
8.5. Logging trails
8.6. Reverse utility
9. BEGIN YOUR REPLICATION
9.1. Initial load
9.2. kick start load
9.3. Pre-checks
9.4. Methods
9.5. File based loading
9.6. Direct load
10. DATA AND CONFIGURATIONS
10.1. GLOBAL & Manager Parameters
10.2. Extract & Replicat Parameters
10.3. Data selection: WHERE, FILTER
10.4. Data Mapping: Columns
10.5. RANGE
10.6. SQLEXEC functionalities
10.7. Functions specific to GoldenGate
11. OTHER CONSIDERATIONS
11.1. Macros & Tokens
11.2. User exits & Sequences
11.3. BatchSQL in GG
11.4. Data compression in GG
11.5. Data encryption & Events
12. GOLDENGATE – BIDIRECTIONAL>
12.1. Pictorial view
12.2. Configurations
12.3. Data loopings
12.4. Resolving conflicts
12.5. Effect of Oracle Sequences
13. INTRODUCTION TO MANAGEMENT PACK
13.1. Components of Oracle GG MP
13.2. Architecture of Oracle GG monitor
13.3. Get to know Enterprise Manager Cloud Control(EMCC)
13.4. EMCC vs Oracle GG monitor
14. INSTALL MANAGEMENT PACK(MP)
14.1. Installation overview
14.2. Web logic server setup
14.3. Infra setup
14.4. GG monitor server setup
14.5. Create Repository
14.6. Configure Domain & Monitor server
14.7. Properties
14.8. Configure Agents
15. ADMINISTER MP
15.1. Object management
15.2. Managing Views
15.3. Alert management
15.4. Configure mail alerts
15.5. Monitor Activities