OraEasy

Introduction In this post, we will cover the Oracle Enterprise Manager (OEM) 24ai Release 1 installation step by step, including repository database preparation, installation prerequisites, OMS configuration, WebTier configuration, plugin deployment, and post-installation verification. Oracle Enterprise Manager 24ai is Oracle’s latest Enterprise Manager release for monitoring and managing Oracle databases, middleware, hosts, and other enterprise targets from a centralized platform. Prerequisites Below are the minimum requirements for a Linux environment: CPU: 2 cores RAM: 10GB Disk space: 50GB (/u01) and 60GB (/oem) OEM binary, downloadable here . Root user or sudo access. Firewall disabled. Environment Used in This Guide Hostname oem.oraeasy.com / 192.168.1.43 OS OEL 9.1 OEM Version 24ai Release 1 (24.1) OMS Home /oem/app/oracle/middleware Agent Base /oem/app/oracle/agent Reposit...

Introduction Oracle Network Access Control List (ACL) controls which database users are allowed to make network connections from the Oracle Database to external hosts. In other words, it governs the outbound traffic leaving the database toward the outside world. It is commonly required when database PL/SQL packages such as UTL_SMTP , UTL_HTTP , and UTL_TCP need to access external network services. In this article, we will configure an Oracle Network ACL on Oracle Database 19c and use it to send an email through Gmail SMTP using UTL_SMTP . Gmail SMTP is used here purely to demonstrate the configuration end to end; the same steps apply to any SMTP server, so feel free to substitute your own SMTP host, port, and credentials. We will also configure an Oracle Wallet for TLS and use a Gmail App Password for authentication. The complete configuration will be demonstrated step by step, starting with the error received when no ACL is configured and ending with a successful email d...

Introduction Point-in-Time Recovery (PITR) is an Oracle RMAN recovery technique used to recover a database to a specific point in time, SCN, or log sequence. It is particularly useful when unwanted changes, accidental data deletion, or logical corruption occurs and the database needs to be restored to a known consistent state before the incident. In this article, we will demonstrate how to perform an RMAN Point-in-Time Recovery using database backups, incremental backups, archived redo logs, and the control file. We will restore the database to a specific point in time and verify the database after recovery. PITR Scenario For this demonstration, we have an Oracle database named CDBORCL . We will first take an RMAN Level 0 backup followed by Level 1 incremental backups, archived redo log backups, and control file backups. After taking the required backups, we will perform additional INSERT and UPDATE operations on a sample table. We will then identify a specific recovery point...