Oracle RAC One Node Training Course

Welcome to my first online course about Oracle RAC One Node Database.This is really a very interesting, practical, and powerful course about the Oracle RAC One Node database feature.Please note that this is not a standard oracle training course. In this course, I'm really sharing with you my project implementation experience and real tips and … Continue reading Oracle RAC One Node Training Course

Oracle Fail Safe 4.2.1 Implementation Plan on Windows 2016 and Oracle 12cR2

Following is the high level plan of Fail Safe 4.2.1 implementation on Windows 2016 and Oracle Database 12cR2 (12.2.0.1). System Administrator Activities: Database Administrator Activities: ThanksAhmed

OPatch error : “Unable to lock Central Inventory”

While applying Patch 31210848 "Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714" on database 12.2.0.1on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will attempt to re-lock. Solution: I opened another command window as Administrator, and applied the patch again. This time, it completed successfully without errors: For Windows platform, … Continue reading OPatch error : “Unable to lock Central Inventory”

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?

What is Oracle Home User in Oracle Database 12c?

In this post, I'm documenting some valuable information from different resources, about the "Oracle Home User" that is introduced in Oracle 12.1, and the difference between the "Oracle Home User" and the "Oracle Installation User"? ThanksAhmed

Oracle Database Locking Policy – Back to Basics

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

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