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
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
The system cannot find the batch label specified – execute_task when upgrading an Oracle Database
I created a Windows batch script to upgrade and oracle database from 12.2 to 19.23 on Windows platform. The main script line is the following line (which is the main command to upgrade the Oracle Database):%ORACLE_19C_HOME%\bin\dbupgrade1 -n 4 >> %LOG_FILE% 2>&1 But when running the script, the script is error out when executing the above … Continue reading The system cannot find the batch label specified – execute_task when upgrading an Oracle Database
Oradim not able to delete an Oracle database windows service
As an intermediate step in a database upgrade process, there is one step to delete an Oracle database Windows Service using the following command:oradim.exe -delete -sid POSDBBut, I received the following error message:O/S-Error: (OS 1072) The specified service has been marked for deletion. I tried many things, like:Closing the Task Manager.Ensuring event viewer, Microsoft Management … Continue reading Oradim not able to delete an Oracle database windows service
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
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
OCI Compute Instance Hostname keeps changing after reboot
I created an OCI compute Linux Instance with hostname = hostname_1. After a while, and based on the client request, I changed the above virtual machine hostname to be hostname_2.Client used this machine for a while, and then reboot it for some reason, but surprisingly, he found that the compute Instance hostname changed back to … Continue reading OCI Compute Instance Hostname keeps changing after reboot
error while loading shared libraries: libclntsh.so.19.1
While trying to run one of the Oracle Utilities (oratop), I received the following error:oratop: error while loading shared libraries: libclntsh.so.19.1: cannot open shared object file: No such file or directory. This error doesn't mean that the library doesn't exist, but in most cases, it is missing environment settings. Let us first check if this … Continue reading error while loading shared libraries: libclntsh.so.19.1
Ahmed AbdelFattah Blog ! 