Database Blog

Query to Identify Initial and Latest Login Sessions in Oracle Database

Please use the query below to identify and provide the SID and Serial#.   col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_seen, MAX(sample_time) AS last_seen FROM…

Read More

Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)

Please follow the below steps.   Prerequisites   Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS is healthy before making changes.  …

Read More

How to Unlock Locked SQL Server Logins

How to Unlock Locked SQL Server Logins  Introduction / Issue  During day-to-day SQL Server administration, users may report that they are unable to connect to the SQL Server instance even…

Read More

SQL Server Audit File Enabled for Both Failed and Successful Logins

SQL Server Audit File Enabled for Both Failed and Successful Logins  Introduction   During a routine SQL Server security review, it was observed that SQL Server Audit was configured to capture both FAILED_LOGIN_GROUP and SUCCESSFUL_LOGIN_GROUP events. While…

Read More

Upgrading to PostgreSQL 16 Using pg_dump and pg_tresore 

 One of the safest and most reliable upgrade methods is to use pg_dump and pg_restore. This guide walks through the process of migrating your databases from an older PostgreSQL version to PostgreSQL 16.…

Read More

Kafka Administration Commands

Kafka Administration Commands Introduction Apache Kafka is a distributed event-streaming platform used to build real-time data pipelines and streaming applications. In a production environment, 1. List Topics Displays all topics…

Read More

Applying the October 2025 Critical Patch Update (CPU) in EBS R12.2

Oracle E-Business Suite Release 12.2 – Applying the October 2025 Critical Patch Update (CPU) Overview This article outlines the high-level procedure for applying the Oracle E-Business Suite (EBS) Release 12.2…

Read More

Oracle E-Business Suite R12.2 AD/TXK Delta 16 Upgrade – Practical Implementation Guide

Introduction Oracle E-Business Suite (EBS) Release 12.2 requires periodic updates to its Application DBA (AD) and Technology Stack (TXK) components to maintain security, stability, and Oracle support compliance. AD and…

Read More

Encryption in Vulnerability Management

Introduction/ Issue:  Organizations store and transmit sensitive information, including user credentials, employee records, financial data, system configurations, and vulnerability reports. If this information is not adequately protected, attackers may access…

Read More

Ciphers and Their Importance in Security

Introduction/ Issue:  A cipher is a cryptographic algorithm used to convert readable data, called plaintext, into an unreadable format called ciphertext. Authorized users or systems can restore the original data…

Read More