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

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

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 !

ORA-38760 While starting an Oracle Database

This is a quick post about an issue that I faced while trying to start one database yesterday. When I was trying to open one 12cR1 database, I got the following error: SYS SQL>alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback database The database status was "mounted": … Continue reading ORA-38760 While starting an Oracle Database

Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.

As, I already have access to one Oracle Cloud Free Compute Instance (Oracle Linux), then I decided to install Oracle database 19c there and create a test database. This time, I'll use a different technique by installing Oracle Database rpm.Oracle delivered the oracle database software as rpm for Linux since Oracle 18c. Installation procedure is … Continue reading Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.

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