Blog Posts

PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing – Oracle installation requires old rpm versions, what to do?

September 13, 2024

Below packages can usually be ignored as oracle installer thinks they are not available and are still needed while they already exists. [root@rac2 Desktop]# yum install libaio-0.3.105-2.i386.rpm Loaded plugins: refresh-packagekit, security Setting up Install Process No package libaio-0.3.105-2.i386.rpm available. Error: Nothing to do [root@rac2 Desktop]# rpm -ivh compat-libstdc++* error: File not found by glob:…
LAST DDL change time on a table in ORACLE Database

August 5, 2024

A general question among most of developers is ” HOW can I know when LAST DDL was done??” The best option will be to go and look at the table details. While you can also query the same details from user_objects/dba_objects. Lets create a table test1 sql > create table test1 (id number); table TEST1…
Oracle Virtual Columns: A Powerful Feature in Database Design

July 24, 2024

Oracle Virtual Columns: A Powerful Feature in Database Design Oracle Virtual Columns: A Powerful Feature in Database Design Oracle 11g introduced the concept of Virtual Columns, a unique feature that allows dynamic calculations within a table. These columns behave like regular table columns but with some significant differences, making them highly useful for specific use…
Configure Putty tunnel

June 24, 2024

How to Configure WinSCP and PuTTY for SSH Tunneling Setting up WinSCP and PuTTY to use SSH tunneling ensures secure and efficient connections to your servers through an intermediate host. This guide provides step-by-step instructions for configuring both tools. WinSCP Configuration The WinSCP configuration is straightforward, leveraging its “tunnel” feature. Follow these steps: Open WinSCP…
Oracle Database DBMS_SCHEDULER: Creating and Managing Jobs

May 27, 2024

Oracle DBMS_SCHEDULER: Creating and Managing Jobs The DBMS_SCHEDULER package in Oracle is a powerful tool for scheduling and automating tasks. Unlike its predecessor, DBMS_JOB, it provides advanced features such as calendaring expressions, better logging, and robust error handling. This article explores the key operations you can perform with DBMS_SCHEDULER, including creating, running, modifying, and monitoring…