Posts by Sivakumar Venkatachalam

Installation and Configuration of Apex 26.1 in Oracle 26AI Database

Introduction: Oracle APEX is Oracle’s low-code development platform that enables developers to build secure, scalable, and enterprise-grade web applications with minimal coding. A successful APEX deployment requires proper installation and…

Read More

Upgrade Oracle Container Database from 19c to 26AI using AUTOUPGRADE Utility.

Introduction: Keeping Oracle databases on supported releases is essential for security, performance, and access to new features. Oracle AI Database 26ai introduces several enhancements over Oracle Database 19c, making it…

Read More

Oracle Linux OS Upgrade from 7.9 to 8.1 with Oracle 19c database (On-Prem) using LEAPP utility

Prerequisites: 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 More

Creating a Database Link in Oracle 19c Database to connect MS SQL Server using ODBC Driver

Prerequisite: 1. MS SQL Server with a SQL Authenticated User.       CREATE LOGIN Sivakumar WITH PASSWORD = 'Doyen@123', CHECK_POLICY = OFF;         SELECT name, type_desc,…

Read More