Oracle 12c GoldenGate Online Training
Cheyat Technologies is cutting-edge online training institute offering ORACLE12C GoldenGate Online Training to candidates. We have experienced pool of ORACLE 12C GoldenGate experts to offer world class online training to our candidates using their expertise. They have put lots of effort to design the course structure for ORACLE Goldengate Online Training. Along with Online Training , We undertake On Job Supports also.
Oracle 12c GoldenGate Online Training Demo Video
Oracle 12c GoldenGate Online Training Course content
SETTING UP SERVERS & USE CASES
- Install Oracle Enterprise Linux servers
- Install Oracle 12c database software
- Setup Golden Gate OS dependencies
- Clone Linux servers
- Configure Oracle databases
- Golden Gate use cases
INSTALL GOLDEN GATE 12C
- Supported DB’s OS combinations
- Software and OS requirements
- Installation – OUI
- Directories
- Kick start
- New in 12c GG
GOLDEN GATE 12C ARCHITECTURE
- GG workflow
- Related products
- GG Components
- Architecture basics
- Processes
- Parameters
- Topologies
GOLDENGATE WIRE FRAME
- CDC and Delivery
- Role of Data pump in GG
- Integrated extract
- Data load
- CKPT in GG
ORACLE TO ORACLE CONFIGURATION BASICS
- Steps to configure
- Preparing environment – Character set
- Configure user – Oracle Database
- Network diagnostics
- Preparing environment – Supplemental logging
- Configuring Manager
- Defgen
EXTRACT DATA
- Change capture
- Data pump options
- Process groups
- Configure Wallet
- Integrated Capture
- Extract traill
- Start Extract
- ASM in CDC
REPLICATE DATA
- Change delivery basics
- CDD activities Treat Collisions
- Integrated Apply
- Monitoring
- Reports & Diagnostics
TRAILING
- Extract Trails and Files
- Formats
- Substitutes
- Log Dump
- Logging trails
- Reverse utility
BEGIN YOUR REPLICATION
- Initial load
- Kick start load
- Pre-checks
- Methods
- File based loading
- Direct load
DATA AND CONFIGURATIONS
- GLOBAL & Manager Parameters
- Extract & Replicat Parameters
- Data selection: WHERE, FILTER
- Data Mapping: Columns
- RANGE
- SQLEXEC functionalities
- Functions specific to Golden Gate
OTHER CONSIDERATIONS
- Macros & Tokens
- User exits & Sequences
- BatchSQL in GG
- Data compression in GG
- Data encryption & Events
- GOLDENGATE – BIDIRECTIONAL
- Pictorial view
- Configurations
- Data looping’s
- Resolving conflicts
- Effect of Oracle Sequences
