Migrating databases from Oracle to SQL Server can be challenging, particularly when character sets between the two systems differ. Mismatched character sets can lead to data loss, corruption, or issues with character encoding. In this blog, we'll explore…
Database migration from Oracle to PostgreSQL has become increasingly common as organizations seek to reduce licensing costs, embrace open-source solutions, and modernize their database infrastructure. However, such migrations present significant…
Are you an Oracle DBA? Have you been asked to manage PostgreSQL or SQL Server databases?
Or maybe you’re a SQL Server DBA now assigned to manage “that one Oracle database that supports a mission-critical application…
We are seeing more and more interest in our Stat customers moving their EBS and/or PeopleSoft applications to the cloud. It seems most of the moves currently are to Oracle Cloud Infrastructure (OCI). In some cases, customers are also moving Stat as well…
Data to AWS Three Ways
A SharePlex Cookbook Part Two
In the first blog, I discussed data and a bit on SharePlex. Now for the recipes!
Here are the recipes - three different ways to get data from your Oracle database to either an Amazon File or…
In my earlier blog, we discussed various business uses for turning Oracle database transactions into “business events”, and how SharePlex can be used to capture Oracle Change Data and write that data to a Kafka message queue.
Confluent has…
As more and more Oracle users upgrade their databases to Oracle 19c and beyond, posts on the Oracle community mailing lists about changes in query performance are increasing. In most cases, users are seeing improved performance; but, as Scotty said in…
Oracle and other relational databases are perfect for storing “transactions”, the results of interactions between people or systems. For example, when a customer purchases a widget from our store, we may need to perform the following steps…
Streams is Gone
If you're a current Oracle Streams user looking to upgrade to Oracle 19c, you already know that as of this release, Oracle has removed Streams. So, there are choices to be made. You can
Patching, Upgrading or Migrating your Oracle Database can leave you feeling that you're in the midst of the same tornado that swept Dorothy into the Land of Oz; and you might run into some of the same characters as well. Here's how SharePlex, Quest's…
"I felt a great disturbance in the Force, as if millions of voices suddenly cried out in terror and were suddenly silenced=" - Obi Wan - Star Wars
if the lack of support for RAC in Oracle 19c is disturbing the Force in your environments, here…
If you’re one of the busiest travel sites on the internet and want to perform an AWS cloud migration of your bookings database while simultaneously upgrading your Oracle version, you know that any interruption in service could be costly. It’s simply not…
What if you woke up one morning and found that you had a doppelganger who was enthusiastically running around pretending to be you, spending your hard-earned money and doing who knows what with your identity. It sounds like a nightmare, right? But this…
We all remember Abbott and Costello’s skit “Who’s On First?”. If you haven’t seen it, I highly recommend you pop over to YouTube and give it a watch. It has become one of the legendary classic comedies of all times, with Costello not knowing baseball…
I’ve been interested in weather, meteorology and clouds in the sky for as long as I can remember; which may explain why one of my favorite songs is Joni Mitchell’s “Both Sides Now”. I’ve learned that some clouds are pretty, and…
Does the process of replicating data from one source to another fill your body with an inner joy like it does mine? The thrill of changing data in one location and watching those changes appear in another, in my eyes is better than well you know….. Ice…
I’m sure Oracle DBAs everywhere are keeping their collective ears close to the ground waiting for the official announcement on 12cR2. We still, rightly or wrongly, have a habit of waiting for the 2nd release of Oracle versions, but that’s for another…
During October 2015, Oracle announced that the Extended Support Fee for Oracle Database 11g R2 will be waived until May 31, 2017. After this period, Extended Support for Oracle Database 11g R2 will be offered until December 2020.
A primary concern for…
