DBASolved

  Earlier today, I have been working on a few GoldenGate Obey files that will setup a customer’s environment; that […]

The post AdminClient – ADD CREDENTIAL doesn’t do what you expect! appeared first on DBASolved.

When building MySQL Heatwave Systems (use to be called MySQL Database Service or MDS), the need to add a Hostname […]

The post Adding Hostname to MySQL Heatwave/MySQL Database Service appeared first on DBASolved.

Building a MySQL Database in Oracle Cloud Infrastructure (OCI) is easy.  Within a few steps, you can build a MySQL […]

The post Building MySQL Database Service (MDS) appeared first on DBASolved.

  Creating Connections In Oracle GoldenGate (on-premises) we always have to setup a connection to the database.  This is done […]

The post GoldenGate Service (GGS) – Connection Setup appeared first on DBASolved.

  Deployments Deployments are a GoldenGate concept that has been around since 2017.  In many cases, it is one of […]

The post GoldenGate Service (GGS) – Deployment Configuration appeared first on DBASolved.

The error OGG-02028: Failed to attach to logmining server OGG$<extract_name> error #,### – ORA-01292 LogMiner for upstream capture cannot find […]

The post Resolving OGG-02028 Errors appeared first on DBASolved.

Machine Learning (ML) and Artificial Intelligence (AI) is all the new, hot, shiny thing in the industry today.  Everyone is […]

The post MySQL Heatwave: ML Basic appeared first on DBASolved.

  If you are running MySQL 5.7 or earlier and not sure if you should upgrade to MySQL 8.0, we […]

The post MySQL 8.0 – Top 4 Features appeared first on DBASolved.

As a GoldenGate administrators start to explore how to perform replication tasks within a cloud environment, they will start to […]

The post Collecting trail files from OCI GoldenGate Service (#GGS) appeared first on DBASolved.

Oracle GoldenGate Service is Oracle’s cloud offering  to quickly use GoldenGate to move data within OCI as well as other […]

The post Manually purging trail files from OCI GoldenGate Service appeared first on DBASolved.

Sometimes, you just want to run NGINX in unsecure mode (over port 80) for internal environments.  The steps here are […]

The post Using NGINX in unsecure mode for Oracle GoldenGate appeared first on DBASolved.

As I have done multiple engagements with Oracle GoldenGate and helped clients get the most out of their investment; I […]

The post GoldenGate Parameter Files – Format and Logic appeared first on DBASolved.

A quick post as a reminder for myself some time down the road.  After all, we all need reminders every […]

The post Identifying Predefined Administrative Accounts in Autonomous Database or any other Oracle database appeared first on DBASolved.

What is a Bastion? There a three primary definition for the word Bastion.  They are: A projecting part of a […]

The post Access Oracle DBCS Pluggable Database via Bastion Connection appeared first on DBASolved.

When setting up a new environment or getting access to a client’s OCI environment, the first thing that should be […]

The post Setting up OCI API Keys appeared first on DBASolved.

    On one of our projects, we have been using an Oracle GoldenGate (Microservices) hub architecture to run the […]

The post OGG-12031 error … What happened? appeared first on DBASolved.

Recently I have been doing some installs for Oracle GoldenGate via the silent install process; mostly using Ansible.  Every once […]

The post CreateOUIProcess(): 13 … Permission issue or Library issue? appeared first on DBASolved.

  After installing Oracle GoldenGate with a manual ServiceManager, you realize that the ServiceManager will not come back up on […]

The post Configure Oracle GoldenGate’s ServiceManager as a Linux Service appeared first on DBASolved.

  Recently I have been talking with customers about their Oracle GoldenGate implementations and how these implementations can benefit their […]

The post Performance with Oracle GoldenGate appeared first on DBASolved.

Since the release of Oracle GoldenGate 12.2 (Classic) and Oracle GoldenGate 12.3 (Microservices), users have been able to interact with […]

The post Mimic GGSCI with Python appeared first on DBASolved.