Posts by Sivakumar Venkatachalam

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