OraEasy

Introduction In this article, we will install Oracle 19c (version 19.3) on Windows OS. Difference from Linux On Windows, you don't need to configure or install any OS-level prerequisites the way you would on Linux. There's also no root script to run after the installation finishes, the whole process stays within a single GUI-driven flow. Prerequisites Minimum requirements for the Windows environment: CPU: 2 cores RAM: 4 GB Disk space: 25 GB OS: Windows 8.1 or later Software Download Oracle 19c for Windows: Click Here Now let's start the installation, step by step. Part 1: Install the Oracle Software Step 1: Create the ORACLE_HOME Directory and Place the Software C:\Users\oraeasy> mkdir -p D:\app\oracle\product\19c\db_home1 C:\Users\oraeasy> dir D:\app\oracle\product\19c\ Volume in drive D is Data Volume Serial Number is 60FC-A6D2 Directory of D:\app\oracle\product\19c 30-08-2025 14:22 <DIR> . 30-08-2025 14...

Introduction In this article, we will restore a single PDB from an RMAN backup. This is useful when the source database has multiple PDBs, but you only need to restore one specific PDB onto the target machine, without pulling across the others. Prerequisites A valid RMAN full backup. Environment used here Source Database Hostname orcl.oraeasy.com Database Name ORCL PDB Name ORCLPDB Database Version 19c (19.27) Target Database Hostname uat.oraeasy.com Database Version 19c (19.27) On the source, we have two PDBs, ORCLPDB and TESTPDB . We will restore only ORCLPDB on the target machine. Now let's proceed to restore the single PDB via RMAN, step by step. Step 1: Run a Precheck So Data Can Be Verified Post-Restoration Before backing anything up, capture a snapshot of the current state of ORCLPDB : da...

Introduction APEX and ORDS versions are tied together closely enough that upgrading one without the other usually isn't an option. In this guide, we'll upgrade Oracle APEX from 23.2 to 24.2, and ORDS from 22.3 to 25.2, on the same environment. Since ORDS 25.2 requires a newer JDK than what most 22.3 installs run on, we'll also upgrade Java to version 17 along the way. Prerequisites Keep the SYS user password handy, you'll need it during both the APEX and ORDS installers. Minimum Java 17 is required for ORDS 25.2. Take a full database backup before starting, in case you need to roll back. Environment Used in This Guide Server apex.oraeasy.com / 192.168.101.7 APEX (current) 23.2 ORDS (current) 22.3 Database Name APEXDB Download the Software APEX 24.2 ORDS 25.2 Java 17 Part 1: Upgrade APEX Step 1: Check Current APEX and ORDS Versions ...