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
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 ! 