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.
Pre-requisites (Free)
No Pre-requisites needed
System Requirements
CPU:Minimum of Dual Core processor
Memory: 6 GB
OS: Windows/MacOS
Space: 150 GB of disk spac
Training Details
26 Sessions.
Trainer: Pawan Kumar Yaddanapudi.
Includes supporting documents, software’s and Log files.
Anytime assistance.
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.
- Install Oracle Enterprise Linux servers
- Install Oracle 12c database software
- Setup GoldenGate OS dependencies
- Clone Linux servers
- Configure Oracle databases
- GoldenGate use cases
- Supported DB’s
- OS combinations
- Software and OS requirements
- Installation – OUI
- Directories
- Kick start
- New in 12c GG
- GG workflow
- Related products
- GG Components
- Architecture basics
- Processes
- Parameters
- Topologies
- CDC and Delivery
- Role of Datapump in GG
- Integrated extract
- Data load
- CKPT in GG
- Steps to configure
- Preparing environment – Character set
- Configure user – Oracle Database
- Network diagnostics
- Preparing environment – Supplemental logging
- Configuring Manager
- Defgen
- Change capture
- Datapump options
- Process groups
- Configure Wallet
- Integrated Capture
- Extract trails
- Start Extract
- ASM in CDC
- Change delivery basics
- CDD activities
- Treat Collisions
- Integrated Apply
- Monitoring
- Reports & Diagnostics
- Extract Trails and Files
- Formats
- Substitutes
- Logdump
- Logging trails
- Reverse utility
- Initial load
- kick start load
- Pre-checks
- Methods
- File based loading
- Direct load
- GLOBAL & Manager Parameters
- Extract & Replicat Parameters
- Data selection: WHERE, FILTER
- Data Mapping: Columns
- RANGE
- SQLEXEC functionalities
- Functions specific to GoldenGate
- Macros & Tokens
- User exits & Sequences
- BatchSQL in GG
- Data compression in GG
- Data encryption & Events
- Pictorial view
- Configurations
- Data loopings
- Resolving conflicts
- Effect of Oracle Sequences
- Components of Oracle GG MP
- Architecture of Oracle GG monitor
- Get to know Enterprise Manager Cloud Control(EMCC)
- EMCC vs Oracle GG monitor
- Installation overview
- Web logic server setup
- Infra setup
- GG monitor server setup
- Create Repository
- Configure Domain & Monitor server
- Properties
- Configure Agents
- Object management
- Managing Views
- Alert management
- Configure mail alerts
- Monitor Activities
Frequently Asked Questions (FAQs)
Wondering what ORSKL can do for you?
Related Posts
There are many variations of passages of Lorem Ipsum available but majority have suffered alteration in some.There are many variations.
Build Simple Machine Learning Web Application using Python
Pre-processing data and developing efficient model on a given data set is one of the daily tasks of machine learning engineer with commonly used languages like Python or R. Not every machine learning engineer would get a chance or requirement to integrate the model into real time applications like web or mobile for end users […]
Ways to identify if data is Normally Distributed
Normal distribution also known as Gaussian distribution is one of the core probabilistic models to data scientists. Naturally occurring high volume data is approximated to follow normal distribution. According to Central limit theorem, large volume of data with multiple independent variables also assumed to follow normal distribution irrespective of their individual distributions. In reality we […]
Will highly correlated variables impact Linear Regression?
Linear regression is one of the basic and widely used machine learning algorithms in the area of data science and analytics for predictions. Data scientists will deal with huge dimensions of data and it will be quite challenging to build simplest linear model possible. In this process of building the model there are possibilities of […]
Will Oracle 18c impact DBA roles in the market?
There has been a serious concern in the market with announcement of Oracle Autonomous database 18c release. Should this be considered as a threat to Oracle DBA’s roles in the market? Let us gather facts available on the Oracle web to understand what exactly this is going to be and focus on skill improvements accordingly. […]
How Oracle database does instance recovery after failures?
INSTANCE RECOVERY – Oracle database have inherit feature of recovering from instance failures automatically. SMON is the background process which plays a key role in making this possible. Though this is an automatic process that runs after the instance faces a failure, it is very important for every DBA to understand how is it made […]
Why should we configure limits.conf for Oracle database?
Installing Oracle Database is a very common activity to every DBA. In this process, DBA would try to configure all the pre-requisites that Oracle installation document will guide, respective to the version and OS architecture. In which the very common configuration on UNIX platforms is setting up LIMITS.CONF file from /etc/security directory. But why should […]
Why RMAN needs REDO for Database Backups?
RMAN is one of the key important utility that every Oracle DBA is dependent on for regular day to day backup and restoration activities. It is proven to be the best utility for hot backups, in-consistent backups while database is running and processing user sessions. With all that known, as an Oracle DBA it will […]
Will huge Consistent Reads floods BUFFER CACHE?
Oracle Database BUFFER CACHE is one of the core important architectural memory component which holds the copies of data blocks read from datafiles. In my journey of Oracle DBA this memory component played major role in handling Performance Tuning issues. In this Blog, I will demonstrate a case study and analyze the behavior of BUFFER […]
Can a data BLOCK accommodate rows of distinct tables?
In Oracle database, data BLOCK is defined as the smallest storage unit in the data files. But, there are many more concepts run around the BLOCK architecture. One of them is to understand if a BLOCK can accommodate rows from distinct tables. In this article, we are going to arrive at the justifiable answer with […]
Can you really flush Oracle SHARED_POOL?
One of the major player in the SGA is SHARED_POOL, without which we can say that there are no query executions. During some performance tuning trials, you would have used ALTER SYSTEM command to flush out the contents in SHARED_POOL. Do you really know what exactly this command cleans out? As we know that internally […]
