DBASolved

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

Similarity Search with Oracle’s Vector Datatype, Python, and Flask

Tue, 2024-03-05 11:46

  If you have been following the last few blog posts, this is the final one with regards to setting […]

The post Similarity Search with Oracle’s Vector Datatype, Python, and Flask appeared first on DBASolved.

Categories: DBA Blogs

Similarity Search with Oracle’s Vector Datatype

Tue, 2024-02-27 09:36

In my last two posts I showed you what the Oracle Vector Datatype is and how to update existing data […]

The post Similarity Search with Oracle’s Vector Datatype appeared first on DBASolved.

Categories: DBA Blogs

Oracle Vector Datatype – Updating table data

Mon, 2024-02-26 14:36

  In my last blog post on Oracle’s Vector data type, I simply showed you how the datatype is used […]

The post Oracle Vector Datatype – Updating table data appeared first on DBASolved.

Categories: DBA Blogs

Oracle’s Vector Datatype

Fri, 2024-02-02 12:33

At Oracle Cloud World 2023, Oracle announced they were moving toward enabling Artificial Intelligence (AI) within many of their products. […]

The post Oracle’s Vector Datatype appeared first on DBASolved.

Categories: DBA Blogs

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

Pages