The Oracle DBA’s Guide to SQL Server Integration: Implementing DG4ODBC on Oracle Linux 9

Posted on by Ahmed Abdel Fattah

In modern data warehousing, the "pure" Oracle environment is a myth. We often manage dozens of Oracle databases but still encounter that one necessary SQL Server instance holding critical data. When you need to pull data from SQL Server into Oracle, you have two primary options: the paid "Oracle Database Gateway for SQL Server" (DG4MSQL) … Continue reading The Oracle DBA’s Guide to SQL Server Integration: Implementing DG4ODBC on Oracle Linux 9

Oracle RAC 19c: Key Network Requirements Explained

Posted on by Ahmed Abdel Fattah

This document provides the network requirements for Oracle RAC 19c installation on a two-nodecluster running Red Hat Enterprise Linux (RHEL) 9 OR Oracle Linux 9Prepared for Client Review and ImplementationsNote that all IPs and Hostnames in this document are just examples.Replace it with your environment’s specific IPs. Network Overview Oracle RAC 19c cluster environment requires at … Continue reading Oracle RAC 19c: Key Network Requirements Explained

Solving the Country Dimension Chaos in a Data Warehouse: Smart Design Tips You Can Use

Posted on by Ahmed Abdel Fattah

If you’ve ever worked on a data warehouse with multiple subject areas, you’ve likely run into a seemingly small issue that turns into a huge problem: inconsistent dimension values — especially for something as basic as countries, Gender and others. Recently, I faced this exact challenge and wanted to share how I tackled it, along … Continue reading Solving the Country Dimension Chaos in a Data Warehouse: Smart Design Tips You Can Use

Patching Oracle Linux against CVE-2023-48795 Vulnerability on Air-Gapped Servers

Posted on by Ahmed Abdel Fattah

We’ve all been there. That email from the security team lands in your inbox, or a routine scan flags a new, critical vulnerability. This time, it’s CVE-2023-48795, also known as the "SSH Terrapin Prefix Truncation Weakness." It sounds intimidating, and the thought of a man-in-the-middle attack. For many, the fix is straightforward. But what if … Continue reading Patching Oracle Linux against CVE-2023-48795 Vulnerability on Air-Gapped Servers

Real-World Oracle Migration Magic: 10g to 19c, Step by Step Guide

Posted on by Ahmed Abdel Fattah

Are you facing the daunting task of migrating an Oracle database across platforms and versions? Struggling to find a reliable, step-by-step resource that actually works in the real world? Look no further. This isn’t just another generic tutorial—it’s a battle-tested, hands-on guide born from a real-life customer project, meticulously crafted by an expert who’s been … Continue reading Real-World Oracle Migration Magic: 10g to 19c, Step by Step Guide

Why my Oracle Database is not dynamically registered with the Listener?

Posted on by Ahmed Abdel Fattah

Here, we have couple of puzzles, they are mainly:1- Why the database services are dynamically registered with non-default listener while the local_listener definition doesn't exist in the tnsnames.ora file?2- If you do some changes in the tnsnames.ora file related to the local_listener, are these changes dynamically reflected to the database and listener? or do you … Continue reading Why my Oracle Database is not dynamically registered with the Listener?

O/S-Error: (OS 5) Access is denied while upgrading Oracle 12c Database to 19c

Posted on by Ahmed Abdel Fattah

Background: I was upgrading an Oracle Database version 12c(12.2.0.1) to version 19c (19.24) on Microsoft Windows.This is a manual command line line upgrade ( I didn't use DBUA).I started by doing some preparation tasks like::: Task #1: Run pre-upgrade checks:: Task #2: Run the preupgrade_fixups.sql:: Task #3: Connect to sqlplus and create pfile from pfile:: … Continue reading O/S-Error: (OS 5) Access is denied while upgrading Oracle 12c Database to 19c