Earlier today, I have been working on a few GoldenGate Obey files that will setup a customer’s environment; that is until I ran into an issue with AdminClient. I’m hoping this issue is more of a design overlook than a bug, but let’s see after
When building MySQL Heatwave Systems (use to be called MySQL Database Service or MDS), the need to add a Hostname to the system is critical. The system having a hostname will allow for other applications like Oracle Analytics Cloud (OAC) to connect to MySQL Heatwave.
Building a MySQL Database in Oracle Cloud Infrastructure (OCI) is easy. Within a few steps, you can build a MySQL instance for your development or production needs. To begin building, you first have to login into your OCI tenancy. After you have logged in, use
With the introduction of Oracle GoldenGate (Microservices), Oracle opened a lot of doors for people and organizations to create tools based off of the REST APIs. Initially, the REST APIs within Oracle GoldenGate were developed to ease administration and configuration of the product. This has
Creating Connections In Oracle GoldenGate (on-premises) we always have to setup a connection to the database. This is done by using the credential store to house the connection and then testing it. What happens when we move this concept to OCI and the GoldenGate Service
Deployments Deployments are a GoldenGate concept that has been around since 2017. In many cases, it is one of the more difficult things to explain, but when it clicks the concept is great and leads to many complex architectures. For the cloud, Oracle GoldenGate (Microservices)
Data ingestion is always the beginning stages of getting data into a data warehouse and/or cloud. Recently, we had the opportunity to design, build, and implement a data ingestion solution using Oracle GoldenGate Service (GGS) within Oracle Cloud Infrastructure (OCI). Within the a cloud-to-cloud environment,
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
Oracle GoldenGate has been around for nearly thirty years and each year that ticks by more and more innovation is done to improve the product. This means as Oracle GoldenGate matures, the older release of Oracle GoldenGate have to be deprecated and then desupported, over
MySQL has long been the number two database in the world! Initially MySQL started as one of the first open source databases that the world used as an alternative to Oracle and Microsoft’s SQL Server, so much so that sometime in 2009 Oracle purchased the
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
Oracle GoldenGate Service is Oracle’s cloud offering to quickly use GoldenGate to move data within OCI as well as other clouds. Now network connection and bandwidth has a bit to do with the speed of data being processed, but it a quick service over all.
Sometimes, you just want to run NGINX in unsecure mode (over port 80) for internal environments. The steps here are similar to what I posted some time ago in this post -> here. I’ll put these steps here as well and highlight (bold) which steps
A quick post as a reminder for myself some time down the road. After all, we all need reminders every once in a while! Prior to Oracle Database 12c finding a list of default users within the database was always a pain. In Oracle Database
What is a Bastion? There a three primary definition for the word Bastion. They are: A projecting part of a fortification A fortified area or position A place of security or survival In all three of these definitions, a bastion is a secure place. Within cloud
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
Since the release of Oracle GoldenGate 12.2 (Classic) and Oracle GoldenGate 12.3 (Microservices), users have been able to interact with Oracle GoldenGate using RESTful APIs. I’ve written about this interaction in previous posts. With the option to use RESTful APIs, the flexibility that is introduced
To say that Oracle GoldenGate has undergone a transformation over the last seven year is an understatement. Back in 2017, when I was first working with Oracle GoldenGate (Microservices) – pre-release, I noted the install process could be done silently (binary install). Which is just
After a two year hiatus, Oracle is coming back to the conference scene with Oracle Cloud World (OCW). This year the conference will be hosted in Las Vegas, NV from Oct 17-20, 2022 and will cover a lot of topics for Oracle