DBASolved

Subscribe to  DBASolved feed  DBASolved
Data Migration, Data Replication, Cloud and DevOps
Updated: 7 hours 37 min ago

Writing Python documentation with Cohere’s Generative AI

Fri, 2023-11-03 07:12

Occasionally, I will write a script that customers can use. When I do this, they often ask for documentation to […]

The post Writing Python documentation with Cohere’s Generative AI appeared first on DBASolved.

Categories: DBA Blogs

Interesting change in ALTER EXTRACT command

Mon, 2023-10-09 13:12

Today, while helping a customer, we had to rebuild an extract.  The integrated extract that we rebuilt was stuck in […]

The post Interesting change in ALTER EXTRACT command appeared first on DBASolved.

Categories: DBA Blogs

Basic error handling with Exception Table

Thu, 2023-10-05 04:54

Introduction Exception handling is one of the basic yet advance features that Oracle GoldenGate can do. This allows the Oracle […]

The post Basic error handling with Exception Table appeared first on DBASolved.

Categories: DBA Blogs

Zero-ETL: What is it and what Oracle products support it

Sun, 2023-10-01 16:32

Businesses are constantly finding themselves increasingly reliant on data ingestion, big data, analytics, and following traditional ETL (Extract, Transform, Load) […]

The post Zero-ETL: What is it and what Oracle products support it appeared first on DBASolved.

Categories: DBA Blogs

Oracle GoldenGate 23c “Free” – What you need to know!

Mon, 2023-09-25 08:54

Last week at Oracle Cloud World, the Oracle GoldenGate Product team announced the latest version of Oracle GoldenGate “Free”!  This […]

The post Oracle GoldenGate 23c “Free” – What you need to know! appeared first on DBASolved.

Categories: DBA Blogs

AdminClient – ADD CREDENTIAL doesn’t do what you expect!

Wed, 2023-09-13 16:00

  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.

Categories: DBA Blogs

Adding Hostname to MySQL Heatwave/MySQL Database Service

Mon, 2023-09-04 16:30

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.

Categories: DBA Blogs

Building MySQL Database Service (MDS)

Mon, 2023-09-04 16:30

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.

Categories: DBA Blogs

GoldenGate Service (GGS) – Connection Setup

Thu, 2023-08-17 18:05

  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.

Categories: DBA Blogs

GoldenGate Service (GGS) – Deployment Configuration

Thu, 2023-08-17 17:37

  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.

Categories: DBA Blogs

Resolving OGG-02028 Errors

Thu, 2023-07-06 10:12

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.

Categories: DBA Blogs

MySQL Heatwave: ML Basic

Thu, 2023-06-29 16:58

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.

Categories: DBA Blogs

MySQL 8.0 – Top 4 Features

Tue, 2023-06-27 22:05

  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.

Categories: DBA Blogs

Collecting trail files from OCI GoldenGate Service (#GGS)

Fri, 2023-06-16 15:39

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.

Categories: DBA Blogs

Manually purging trail files from OCI GoldenGate Service

Fri, 2023-05-19 21:09

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.

Categories: DBA Blogs

Using NGINX in unsecure mode for Oracle GoldenGate

Tue, 2023-04-18 11:43

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.

Categories: DBA Blogs

GoldenGate Parameter Files – Format and Logic

Sat, 2023-03-18 22:37

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.

Categories: DBA Blogs

Identifying Predefined Administrative Accounts in Autonomous Database or any other Oracle database

Wed, 2023-03-15 13:12

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.

Categories: DBA Blogs

Access Oracle DBCS Pluggable Database via Bastion Connection

Sun, 2023-03-05 21:22

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.

Categories: DBA Blogs

Setting up OCI API Keys

Tue, 2023-02-28 13:48

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.

Categories: DBA Blogs

Pages