How to Modify an Oracle Database Windows Service?

This is a quick post about how we can change some parameters for one database winodws service. Background:I have a database called PROD with version 19.3, running on Windows. Its service looks like: This Windows service was configured with the parameter file:D:\app\db193\WINDOWS.X64_193000_db_home\database\initPROD.oraFor some reason, I want to change the parameter file to be:M:\app\oracle\database\initPROD.ora{Actually, I'm preparing … Continue reading How to Modify an Oracle Database Windows Service?

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

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

Oracle Virtual Machines for Sale !

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 Read Only Tables

Starting from Oracle 11gR1, oracle allows us to change a table to be a read-only table. Let us have a quick demo: I'm connecting as user HR ( to a 19c pluggable database). I have a small table "DEPT": So, now I'm going to change the table to be read only table: Now let us … Continue reading Oracle Read Only Tables

Oracle RMAN Database Full Cold Backup Demo

https://www.youtube.com/watch?v=bJjm1U5x61M For similar script for the full database hot backup: https://ahmedfattah.com/2019/11/14/oracle-rman-full-hot-backup-script/ ThanksAhmed

Oracle RMAN Database Full Hot Backup Demo

https://www.youtube.com/watch?v=EItbFz09Thc For similar script for the database full cold backup, please refer to: https://ahmedfattah.com/2019/11/14/oracle-rman-database-full-cold-backup-demo/ ThanksAhmed

What is the difference between Oracle RAC One Node and Oracle RAC?

https://www.youtube.com/watch?v=ZM6ckWFlyeM ThanksAhmed

Oracle Database Password file presentation

https://youtu.be/sHUMO-uVYqU ThanksAhmed

Oracle Enterprise Manager Database Control & Time Zone

Background: Egypt time zone is GMT+2. Starting from year 1988, Egypt started to use the summer time zone (GMT +3) starting from the last Thursday of Apr till the last Thursday of September (5 months), then it reset back to GMT +2 for the remaining of the year. Summer time zone was cancelled at 20-Apr-2011, … Continue reading Oracle Enterprise Manager Database Control & Time Zone