Use 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 MoreIf you’re working with Oracle Database and want to leverage the power of Apache Iceberg for your data Lakehouse. Let me walk you through the different ways you can make…
Read MoreIntroduction/ Issue: When building business applications, it’s common to have dropdowns (Lists of Values) where the available options in one field depend on the selection in another. For example, in…
Read More