Introduction: A software image in Oracle Base Database Cloud Service serves as a preconfigured template containing a specific Oracle Database and Grid Infrastructure Release Update. By creating and managing software…
Read MoreIntroduction Partitioning is one of Oracle Database’s most powerful features for managing large tables efficiently. Among the available partitioning methods, Reference Partitioning allows a child table to inherit its partitioning…
Read MoreUse Case: This integration debugging script and approach is used to analyze and resolve common runtime errors in SFTP-based file transfer services, especially during file archival (Move File) operations. It…
Read MoreIntroduction This document explains how to configure a normal Oracle Data Guard physical standby in Oracle Database 23ai, where the primary database is a Non-CDB and the standby database is…
Read MoreIntroduction High availability and predictable disaster recovery are critical in any Oracle production environment. While managing Data Guard manually via SQL*Plus is possible, the number of manual steps during incidents…
Read MorePrerequisites: a. Oracle Linux 7.9 b. Oracle 19c database (should be 19.3 or higher version), Check using… SELECT target_version AS RU_VERSION FROM dba_registry_sqlpatch WHERE action = 'APPLY' ORDER BY action_time…
Read MorePrerequisite: 1. MS SQL Server with a SQL Authenticated User. CREATE LOGIN Sivakumar WITH PASSWORD = 'Doyen@123', CHECK_POLICY = OFF; SELECT name, type_desc,…
Read MoreOracle Cloud Infrastructure’s Identity and Access Management (IAM) service now supports explicit deny policies, providing administrators with the ability to explicitly block unwanted actions and enforce more precise access controls…
Read MoreIntroduction Many OCI users are noticing sudden cost increases even though their compute or storage usage hasn’t changed. In most cases, this happens because logging features like Flow Logs, DNS…
Read MoreIf you’ve been watching the data engineering space lately, you know how painful data silos and vendor lock-in have become. Oracle just rolled out something that might really shake things…
Read More