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

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

Background: I'm installing Oracle Database 12c R2 (12.2.0.1) software on Windows, as part of installing and configuring an Oracle Failsafe 4.2.1 environment. What is the problem? While installing Oracle Database 12.2.0.1 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

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 !

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

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

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

After Oracle Database Upgrade to 12.2, Database Express Did not work

I upgraded one database from 11.2.0.4 to 12.2.0.1 on one Solaris Sparc server. After that I configured the Enterprise Manager Database Express, but when I tried to access it, I got the following error: For more information about Oracle Enterprise Manager Database Express, please refer to my post:https://ahmedfattah.com/2018/10/14/oracle-enterprise-manager-database-express-12c-overview/ Environment: Oracle Solaris 11Oracle Restart 12.2.0.1Oracle Database … Continue reading After Oracle Database Upgrade to 12.2, Database Express Did not work