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

Which User should I use for an Oracle Fail Safe Installation?

In Summary: when you are installing Oracle Fail Safe environment with Oracle 12c database, you need to operating system users: 1- Domain User with Administrative privileges on all the cluster nodes. This user will be used to configure Microsoft Failover cluster, Oracle Database Installation and Oracle Fail Safe Installation. 2- Domain User without Administrative privileges. … Continue reading Which User should I use for an Oracle Fail Safe Installation?

[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

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 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 !