OraEasy

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...