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
Oracle Database Hangs – FRA Space Issue
Although I feel (or claim) that I know how the FRA is working and I know much about the FRA mechanics, encountering FRA space issues consistently leads me to discover new insights and learn something new (very new). What was the issue? The Archiving process stopped working due to space shortage in the +FRA Disk … Continue reading Oracle Database Hangs – FRA Space Issue
Monitoring Oracle Database using Python
In this video I'll navigate around an application that I built using Python to monitor the oracle database performance. The main packages that I used to build this application are: Streamlit, Pandas and plotly. In the future, I may share how I built this application in detail, but here I just need to highlight that … Continue reading Monitoring Oracle Database using Python
Oracle Database Cloud Service Provisioning is very slow
While creating an oracle Database cloud service (or the new name “Oracle Base Database”): and after passing all the required information, and then clicking “Create DB System”, it started to provision the database system: The problem here is that it takes very long time to provision, I waited for 1 hours, 2,3,4 hours without luck. I … Continue reading Oracle Database Cloud Service Provisioning is very slow
Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”
While creating an oracle Database cloud service (or the new name "Oracle Base Database"), and after passing all the required information, and then clicking "Create DB System", I received the following error:Cannot access Object Storage using the subnet with the following OCID: ocid1.subnet.ocx.zz-yyy-xxxxxx-1.aaaaaaaaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx. Review your VCN configuration. If you need further assistance, contact Oracle Support. … Continue reading Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”
Auditing Individual Functions/Procedures inside a PL/SQL Package
I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package
Oracle Database Performance Issue: High waits for “PX Deq: Slave Session Stats”
I had a customer who complains about performance issues on one of the oracle production database. Environment Oracle Database 12c R1 (12.1.0.2) on Linux with Oracle RAC (two nodes). To start with, I collected some AWR reports around the complain time, and I found the top wait events (most of the time) as follows: So, … Continue reading Oracle Database Performance Issue: High waits for “PX Deq: Slave Session Stats”
Ahmed AbdelFattah Blog ! 