OraEasy

Introduction: In this article we will be doing the installation of Oracle 19c (version19.3) on Windows OS . Difference from Linux: In windows, we don't need to configure or install the prerequisites. Also there is no root script to be executed. Prerequisites: Below are the minimum requirements for Windows environment. CPU - 2core RAM - 4GB Disk space - 25GB OS - Windows 8.1 Software Download: Oracle 19c for Windows : Click Here Now start installation step by step: 1. Create ORACLE HOME directory and place the Oracle 19c 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:22 <DIR> .. 30-08-2025 14:23 <DIR> db_home1 0 File(s) 0 bytes ...

Introduction: In this article, we will restore a single PDB from RMAN backup. It will help in such scenario where there are multiple PDBs but you want to restore a specific PDB on target machine. Prerequisites: A valid RMAN full backup. Environment: 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 source, We have two PDB's ORCLPDB & TESTPDB. We will restore only ORCLPDB on target machine. Now let's proceed to restore the single PDB via RMAN step by step: 1. First take some precheck so that data can be verified post restoration. SQL> DEF DEFINE _DATE = "15-SEP-25" (CHAR) DEFINE _CONNECT_IDENTIFIER = "orcldc" (CHAR) DEFINE _USER ...

Introduction: In this article, we will upgrade APEX from 23.2 to 24.2, and ORDS from 22.3 to 25.2. Prerequisites: Please keep sys user password. Minimum Java 17 is required. Also take full DB backup for rollback purpose. Environment: Server apex.oraeasy.com/192.168.101.7 APEX 23.2 ORDS 22.3 Database Name APEXDB Download the software: Apex 24.2 . ORDS 25.2 . Java 17 . Now let's proceed for upgradation step by step: 1. Check APEX & ORDS current version. Also check IMAGE_PREFIX parameter value. SQL> col VERSION_NO for a20 SQL> col API_COMPATIBILITY for a20 SQL> col PATCH_APPLIED for a20 SQL> select * from apex_release; VERSION_NO API_COMPATIBILITY PATCH_APPLIED -------------------- -------------------- -------------------- 23.2.0 2023.10.31 APPLIED SQL> col NAME for a30 SQL> col VALU...