Oracle GoldenGate Trail Encryption: Using a Local Wallet and Master Key

Learn how Oracle GoldenGate encrypts trail files using a Local Wallet and master key, with hands-on tests using Extract, Replicat and Logdump.

database-verse.com

Oracle GoldenGate DAA: How to Download and Manage Dependencies

Downloading Oracle GoldenGate DAA dependencies is easy. Managing them correctly in production is where things get interesting. In this article, we’ll walk through downloading Kafka Confluent …

database-verse.com

Am I Still a DBA?

For many years, my job titles included words like “DBA”, “Senior DBA”, or “Database Architect”.

database-verse.com

Oracle GoldenGate for Distributed Applications and Analytics: From Replication to Real-Time Data Streaming

In this post, we explore how Oracle GoldenGate for Distributed Applications and Analytics moves beyond traditional replication and turns database changes into real-time events. From Extract to Repl…

database-verse.com

Oracle GoldenGate Containers and One-Off Patches: The Missing Piece

Last time I wrote about how to build your own Oracle GoldenGate images. If you missed it, you can check it here: Oracle GoldenGate in Containers: Building and Running Your Own Images, but there wer…

database-verse.com

Oracle GoldenGate in Containers: Building and Running Your Own Images

This blog discusses how to build Oracle GoldenGate container images when specific required versions are unavailable in the Oracle Container Registry. It details steps for cloning the official GitHu…

database-verse.com

Configure Oracle GoldenGate 23ai Microservices Behind an NGINX Reverse Proxy

Oracle GoldenGate Microservices have changed the way we deploy and operate replication. Everything is exposed through HTTP APIs, from administration to runtime services. That is powerful, but it al…

database-verse.com

How to Push Docker Images to Oracle Container Registry (OCIR)

I have been digging into deploying Oracle GoldenGate on OCI Kubernetes Engine (OKE), and during this work one thing became very clear. If you plan to use OCI as an end-to-end architecture, sooner o…

database-verse.com

Oracle GoldenGate Target-Initiated Distribution Paths Explained: Secure Replication Across DMZ and Cloud Networks

When setting up Oracle GoldenGate replication, the most common pattern is simple: a Distribution Path on the source side pushes trail files into a Receiver on the target side. I covered that config…

database-verse.com

How to Securely Connect Oracle GoldenGate 23/26ai Microservices Deployments Using Distribution and Receiver Services

I have been working a lot with GoldenGate recently, and this is not my first time with the product. Over the years I have completed many migrations, both partial and full, and I have even suffered …

database-verse.com

How to Install and Secure Oracle GoldenGate 23ai Using Silent Mode (Step-by-Step Guide)

Oracle GoldenGate (OGG) continues to evolve as the gold standard for real-time data replication and streaming. With its refreshed architecture, modern security, and automation features, it’s now ea…

database-verse.com

ExaDB-D vs ExaDB-XS in OCI: Architecture, Pricing, and When to Choose Each

When people hear Exadata in OCI, the first reaction is usually “so it’s all the same thing, right?” Not quite. Oracle actually offers several flavors of Exadata in the cloud. There’s ExaDB-D, the d…

database-verse.com

Thin Cloning with Oracle Exascale: What You Need to Know

Last week I wrote about Exascale. If you missed it, you can check it out here: Exploring Oracle Exascale: Architecture, Storage Changes, and Why It Matters Exascale is impressive in many ways, but …

database-verse.com

Exploring Oracle Exascale: Architecture, Storage Changes, and Why It Matters

I’m quite familiar with Exadata platforms, having been lucky enough to work on several projects over the past five years helping customers migrate their on-premises database workloads to the cloud. Most of these have been to Exadata Cloud at Customer (ExaDB-C@C) and Exadata on Dedicated Infrastructure (previously ExaCS, now ExaDB-D). When I first heard about Exascale (Oracle Exadata Database Service on Exascale Infrastructure…

database-verse.com

Running Hugging Face models inside Oracle 23ai with ONNX and OML4Py

About a year ago, I published a blog post on vector search in Oracle 23ai. At that time, I wasn’t aware of the ONNX format or how it could be used to bring machine learning models into the database. That realization came later, and ever since, I’ve been thinking: "I need to write a follow-up post to cover this!" Well... the time has finally come.

database-verse.com

ODCC: The missing piece in your Oracle CPU scaling strategy

Over the past few months, I’ve been working with Oracle Dynamic Scaling (ODyS) and Oracle Dynamic CPU Count (ODCC) in a customer environment on EXADB-D X9M and X11. These two tools are game changers if you want to allocate only the resources you really need and, more importantly, save some money. ODyS takes care of scaling OCPUs/ECPUs up or down based on actual demand, so your…

database-verse.com

No more manual KILL: Oracle 23ai handles blocking with Priority Transactions

If you are a DBA you’ve probably received an urgent call time to time from someone saying my applications is blocked, the query is not ending or you are seeing in the monitoring that blocking session counts is increasing overtime and you are looking for what is going on in the database Good news in 23ai! this is probably going to change (hopefully!)

database-verse.com

DGPDB Switchover Failed! Lessons from a Live Demo Disaster (and Recovery)

It’s been a while since my last blog post life and work kept me busy. But recently, I gave a webinar on Oracle 23ai Per-PDB Data Guard (DGPDB), and let’s just say... the live demo didn’t go as planned 😅 My goal was to showcase a simple PDB switchover in real-time. I had validated everything. All signs pointed to…

database-verse.com

Hot Online Patching in Oracle: Benefits and Pitfalls

If you need to patch your database, you want to do it easily, right? why complicate it? As a DBA, I have a choice to avoid interrupting the availability of the database instance. So, why bother stopping the database if you can do something online? In this blog, I want to talk about hot online patching. It is not about RAC rolling patches.

database-verse.com

Oracle Online Index Rebuild Failure: How SMON & DBMS_REPAIR Can Save You

Imagine running an online index rebuild on an Oracle 19c database, only to have it unexpectedly fail. No rollback in progress, no active session, just an error leaving your index in limbo. That’s e…

database-verse.com

Mastering Metadata with Oracle’s DBMS_DEVELOPER in 23.7

Oracle has introduced numerous features in 23ai, with a significant focus on developers—don’t you agree? I certainly think so! Let’s take a look at some of the things Oracle has done to enhance the developer experience in this release: AI Vector Search: This feature enables fast similarity searches on both structured and unstructured data by utilizing vectors. It allows developers to integrate AI capabilities into applications without requiring specialized AI expertise.

database-verse.com

Step-by-Step Guide to Oracle Key Vault Deployment in OCI: Benefits and Features

In today's world, data security is paramount as organizations face increasing threats to their sensitive information. Oracle Key Vault (OKV) is a secure and standards-compliant key and secrets management appliance that allows you to store, manage, and share your security objects. Oracle Key Vault centralizes key and secrets management across your organization quickly and efficiently. Security objects that you can manage with…

database-verse.com