Installation/Configurations19c

Introduction – Oracle Database Blocking Sessions In Oracle Database, blocking occurs when one session holds a lock on a resource (typically a row or table) and another session attempts to …

Oracle Flashback Database : A Practical Recovery Demonstration Introduction Oracle Flashback Database is a database recovery feature that allows a database to be rewound to an earlier point in time. …

Part I — Understanding Containerized Oracle Database 1.1  Why Run a Database in a Container A container turns “install Oracle Database” into “run this image,” which is most valuable exactly where …

Part I — Understanding Data Guard & High Availability 1.1  What Is High Availability, and Where Data Guard Fits High availability is the discipline of keeping a database reachable through failures …

Part I — Understanding the Upgrade 1.1  Why Upgrade from 11g to 19c Oracle Database 11g exited extended support years ago, which means no new security patches, no new bug fixes, …

Part I — Understanding Database Links 1.1  What Is a Database Link? A database link is a schema object that stores the connection details needed to reach another database, so that …

Part I — Understanding Database Health Checks 1.1  What Is a Database Health Check? A database health check is a structured review of an Oracle Database instance and its supporting infrastructure, …

Oracle VirtualBox for Windows Windows Server Guest VM Part I — Understanding This Approach 1.1  Why Build a Windows Server Guest VM? The ORDS and APEX guides in this series are …

Oracle Data Guard 12c Physical Standby Configuration Using RMAN Duplicate and DGMGRL This detailed blog explains how to configure Oracle Data Guard 12c Physical Standby Database using RMAN Active Duplicate …

Installing and Configuring MySQL 8.0 on Ubuntu for Production Use In this blog, we will walk through the complete installation and basic production-level configuration of MySQL 8.0 on Ubuntu Linux. …