Introduction to the Oracle Exadata Database Machine (Arabic version). https://youtu.be/7mA_uuLAyQ8
Oracle RAC 19c: Key Network Requirements Explained
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
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
Real-World Oracle Migration Magic: 10g to 19c, Step by Step Guide
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?
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
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
Oracle Database Hang, no one was able to connect
What is the problem? I received an email from the client that no one was able to connect to the database this morning (after 8:20 am).This case is a good example to show you how it is important to collect information about the issue from the concerned people before diving into the log files and … Continue reading Oracle Database Hang, no one was able to connect
Oracle Cluster Node is Down, bad news
This is one of the difficult situations for any Oracle DBA, where you may receive wrong/conflicting messages from the end users, you may need to run many commands, examine many lengthy trace files, cooperate with other team members, contact vendor support teams. Yesterday, I got a complaint that the database/application is running very slow. I … Continue reading Oracle Cluster Node is Down, bad news
How to change the hostname for an OCI Compute Instance
Following are the steps that I followed to change the hostname of one OCI Compute Instance for one of my clients. Note that the operating system for this instance is Oracle Linux: 1. Use the hostnamectl utility to change the hostname hostnamectl set-hostname new_hostname 2. Update the /etc/hosts file with the new name [root@infodqmdm001 ~]# … Continue reading How to change the hostname for an OCI Compute Instance
OHUC-1026 : unable to authenticate the new password
One of my clients faced the following error, while starting an 12.2 database service on Windows:OHUC-1026 : unable to authenticate the new password Background: The client was trying to change the Oracle Home User password using the orahomeuserctl, after that he was not able to start the Database Windows Service. What is Oracle Home User? … Continue reading OHUC-1026 : unable to authenticate the new password
Ahmed AbdelFattah Blog ! 