Oracle Golden Gate
Oracle Golden Gate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments.
Oracle GoldenGate course is designed to make you an expert in gathering and examining the evidence to solve problems, diagnose their cause and find methods of solution to troubleshoot the issue using GoldenGate software. From this course, you get a clear picture of
Oracle GoldenGate course is designed to make you an expert in gathering and examining the evidence to solve problems, diagnose their cause and find methods of solution to troubleshoot the issue using GoldenGate software. From this course, you get a clear picture of
- Understanding Oracle GoldenGate Replication Solutions
- Configuring & Preparing the Environment
- Data Definitions File
- Configuring Change Capture Delivery – With and Without Data Pump
- Golden Gate Commands & Security Features,
- Advanced Configuration: Mapping and manipulating data
Pre Requisite : Oracle DBA Knowledge
1) Introduction to Oracle Golden Gate
1) Introduction to Oracle Golden Gate
- Oracle Golden Gate Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby Database, and High Availability.
- Supported databases and platforms
- Advantages of Oracle Golden Gate
2) Installing Oracle Golden Gate
- Downloading the software from Oracle website.
- Installing Oracle Golden Gate
- Explaining Subdirectories
- Preparing Oracle 11g database for data replication
3) Oracle Golden Gate Technology and Architecture
- Understanding Golden Gate Components: Processes and Files
- Process Data Flow
- GoldenGate Architecture
- Design Considerations
4) Configuring & Preparing the Environment
- Configuring the Manager process
- Describing the Manager Parameters
- Starting the Manager process
- Configuring GLOBALS file
5) Data Definitions File
- Overview of Data Definitions File
- When to use Data Definitions Files
- Types of Data Definitions File
- Configuring Data Definitions File
6) Configuring Change Capture Delivery – With and Without Data Pump
- Preparing a source database for transaction capture
- Describing the high-level configuration steps
- Explaining change capture and delivery with a data pump
- Explaining change capture and delivery without a data pump
- Comparing batch and online operation
- Explaining Oracle Golden Gate Checkpoints
- Describing the Extract process
- Configuring and starting an Extract process
- Adding local and remote trails
- Configuring and starting a data pump
- Explaining the Replicate process
- Configuring a Replicate process
- Starting a Replicate process
- Describing GGSCI commands
- Describing Extract trails and files
7) Configuring Change Capture Delivery – DDL Replication and Initial Data Load
- Overview of DDL synchronization
- Preparing a source database for transaction capture
- Describing the high-level configuration steps
- Configuring Extract and Replicate for DDL replication
- Configuring Initial Data Load using Oracle GoldenGate Extract and Replicate
8) Oracle Golden Gate Commands
- Running Golden Gate commands from the GGSCI prompt
- Running Golden Gate commands from the obey files
- Running Golden Gate commands from the OS shell
- Identifying the types of GGSCI commands available
9) Managing Oracle Golden Gate
- Managing trail files
- Automating process startup
- Using reporting and statistics
10) GoldenGate Security Features
- Using message, trail and password encryption
- Controlling command permissions – CMDSEC file
11) Advanced Configuration: Mapping and manipulating data
- Overview of data mapping and manipulation
- Deciding where data mapping and conversion will take place
- Data Selection and Filtering
- Data Transformation
- Using built-in functions
- Using SQLEXEC to interact directly with a database
12) Troubleshooting Oracle Golden Gate
- Troubleshooting process startup failures
- Troubleshooting slow startup
- Troubleshooting Extract problems
- Troubleshooting missed transactions
- Using the discard file
- Using SHOWSYNTAX to view Replicate SQL statements
- Using the Logdump utility
13) GoldenGate Performance Tuning
- Using BATCHSQL to speed delivery
- Using RANGE Function
- Using parallel Replicate groups on a target system
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
Oracle Golden Gate, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements.