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 ( 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" on database 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

[INS-32101] While installing Oracle Database on Windows in a Fail Safe Environment

Background: I'm installing Oracle Database 12c R2 ( software on Windows, as part of installing and configuring an Oracle Failsafe 4.2.1 environment. What is the problem? While installing Oracle Database software on Windows, and at step number 5 "Oracle Home User", I specified a domain user in the form:company.local\abc-oinstallerBut, when I clicked "Next", I … Continue reading [INS-32101] While installing Oracle Database on Windows in a Fail Safe Environment

Virtual Machine with Oracle Database 12c R2 12.2 and Oracle Restart For more information on how to get this VM and other similar machines, please refer to: ThanksAhmed

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 Single-Instance Database Creation in a Clustered Environment

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