Monitoring Oracle Database using Python

Posted on by Ahmed Abdel Fattah

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

SQL Developer Warning – could not install some modules

Posted on by Ahmed Abdel Fattah

I have SQL Developer version 22.2 installed on my laptop, then I installed the latest version 23.1.1.Both of them are working fine, and I can run both of them simultaneously without any issue.I have also a separate installation for the Data Modeler version 23.1I restarted my laptop (I didn't restart it since more than one … Continue reading SQL Developer Warning – could not install some modules

Quick Tip: Get difference between two dates in Excel in a readable format

Posted on by Ahmed Abdel Fattah

It was a need for me to get the difference between two dates, in a format (Years, Months, Days).In Excel, you can get the difference by subtracting the two dates, like: But, as you see the result will be the number of days between the two dates.This is not what I need. I found another … Continue reading Quick Tip: Get difference between two dates in Excel in a readable format

[DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.

Posted on by Ahmed Abdel Fattah

Background: A customer has an Oracle Database version 12.2.0.1 on Windows server. He asked to upgrade this database to 19c (19.17) on the same server. Procedure: I installed Oracle 19c (19.3) on a new oracle home on the same server.(During the installation I selected "Windows Virtual Account" as the Oracle Home owner) I applied the … Continue reading [DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.