ORA-01623 & ORA-00312 while dropping one red log file

Posted on by Ahmed Abdel Fattah

I got the following errors while dropping one redo log group: Please note that our database is an RAC One Node database that I'm trying to convert to Single-Instance database based on the client requirements.So, thread 2 (instance 2), is not there actually.If we query about the redo log files of instance 2: So, what … Continue reading ORA-01623 & ORA-00312 while dropping one red log file

VBoxClient: Could not find symbol address

Posted on by Ahmed Abdel Fattah

Problem Description: While one of my VirtualBox machines was running, a power crash happened and I had to restart my laptop.After restarting the laptop, I started that virtual machine again, it started, but I got the following errors, and I was not able to access the machine from VirtualBox (seems to be hang), but I … Continue reading VBoxClient: Could not find symbol address

Oracle Database Locking Policy – Back to Basics

Posted on by Ahmed Abdel Fattah

Understanding how oracle internally manages the transactions is very crucial for your applications. Dealing with the database as a black box (sending queries and receiving results), will end up with bad performance to your application or/and non-scalable application. Oracle uses locks to internally manages the concurrent access to data.Only one transaction can modify any piece … Continue reading Oracle Database Locking Policy – Back to Basics

Virtual Machine with Oracle Database 12c R2 12.2 and Oracle Restart

Posted on by Ahmed Abdel Fattah

https://youtu.be/qsepeUPQ-JU For more information on how to get this VM and other similar machines, please refer to:https://ahmedfattah.com/2020/06/13/oracle-virtual-machines-for-sale/ ThanksAhmed

Oracle Virtual Machines for Sale !

Posted on by Ahmed Abdel Fattah

Are you looking for a virtual machine to do some hands-on labs or practice something (i.e. for Educational purposes}? Do you have the time to build these virtual machines yourself? Below are some really nice Virtual Machines, that I invested allot of time to build on Oracle Virtual Box, and that I used them personally … Continue reading Oracle Virtual Machines for Sale !

Oracle Single-Instance Database Creation in a Clustered Environment

Posted on by Ahmed Abdel Fattah

https://www.youtube.com/watch?v=LTXFohjMwqY

Python Script to Track Coronavirus in Your Country

Posted on by Ahmed Abdel Fattah

covid is python package to track the Coronavirus spread in your country.It requires Python 3.6 or later.To install this package: pip install covid Following is a sample script to use this package to track coronavirus numbers for specific country ( here I use Egypt with id=71 as an example): Following is a sample output for … Continue reading Python Script to Track Coronavirus in Your Country