TNS-04012: Unable to start Oracle Connection Manager instance.

Background: One advantage of the "Connection Manager" is that it can act as if a proxy server between the database client and the database server, especially when there is a firewall between the client and the server.I installed Oracle Client 19c (only the "Connection Manager" and the "Oracle Net Listener" components): https://www.youtube.com/watch?v=R-tSVkRckfs Then I configured … Continue reading TNS-04012: Unable to start Oracle Connection Manager instance.

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