One of the biggest issues with Oracle GoldenGate over the years has been the database permissions needed for the GoldenGate Admin to use the product. Over the years, many users, admins, and consultants have tried to write scripts that would alleviate this concern. Ultimately, some
In the dynamic landscape of modern technology, few fields hold as much promise and potential as Artificial Intelligence (AI) and Machine Learning (ML). These innovative technologies have revolutionized industries across the globe, from healthcare to finance, manufacturing to entertainment. The demand for AI and ML
Due to financial struggles, MariaDB lost over 87% of its Initial Public Offering (IPO) after going public in December 2022. During the first day of trading in 2022, MariaDB’s stock declined 40%. On the second day, the stock dropped an additional 20%. Leaving the company’s
Businesses are constantly finding themselves increasingly reliant on data ingestion, big data, analytics, and following traditional ETL (Extract, Transform, Load) processes; which at times can be a bottleneck to timely business functions. At AWS re:Invent 2023, Amazon recognized this and announced the concept of Zero-ETL.
The error OGG-02028: Failed to attach to logmining server OGG$<extract_name> error #,### – ORA-01292 LogMiner for upstream capture cannot find log file – is an indication that the Oracle archive log file that is needed for the extract to start is missing. There are a
Machine Learning (ML) and Artificial Intelligence (AI) is all the new, hot, shiny thing in the industry today. Everyone is looking for ways to make a business decision quickly and accurately. With this goal in mind, software manufactures are attempting to give access to machine
As a GoldenGate administrators start to explore how to perform replication tasks within a cloud environment, they will start to ask how can I get to the underlying trail files if I need to review them? After all having access to the underlying data is
Datapump is used for Instantiating Oracle GoldenGate with an Initial Load. Client is facing performance issues with datapump for Index Organized Table (IOT) with approximately 1.9B rows. The root cause of the issue is source (DW) and target (OLTP) have different partition design for IOT.
After installing Oracle GoldenGate with a manual ServiceManager, you realize that the ServiceManager will not come back up on a reboot. Although this can be annoying, Oracle GoldenGate is doing what it was asked to. Additionally, after the ServiceManager has been configured, there is no
Recently we have been talking with customers about their Oracle GoldenGate implementations and how these implementations can benefit their enterprise architecture. During these discussions, one thing that sticks out is the need for performance, performance tuning, and how that actually correlates to what is