Database Blog

Using Azure Automation Runbooks for Scheduled Maintenance

Introduction / Issue:  In Azure environments, performing regular maintenance tasks such as patching, cleanup, and service restarts is essential for operational health. Manual execution of these tasks can be time-consuming…

Read More

Creating Custom Dashboards in Azure Monitor for Hybrid Environments

Introduction / Issue:  In hybrid cloud environments, monitoring resources across both Azure and on-premises infrastructure can be challenging. Azure Monitor provides a unified platform for telemetry, but without custom dashboards,…

Read More

How to install Data dog agents in Linux server

Introduction / Issue: Monitoring Linux servers without real-time metrics and logs can delay issue detection. The challenge is setting up the Datadog Agent correctly to capture server and application logs…

Read More

Adding servers to azure Load balancer

Introduction / Issue: In Azure environments, load balancers are used to distribute incoming traffic across multiple virtual machines (VMs). A common issue occurs when newly added VMs don’t receive traffic…

Read More

Safely Remove a Used Disk from ASM DiskGroup in Oracle 19c RAC

How to Safely Remove a Used Disk from ASM DiskGroup in Oracle 19c RAC In this post, I’m sharing a step-by-step process to safely remove a used disk from an…

Read More

AFTER_PASTEBINARY_COMMENV

Issue: During adcfgclone execution in EBS 12.2, the commenv.sh file was populated with an incorrect JAVA_HOME path after the paste binary step. This caused the clone process to fail with…

Read More

The Oracle Migration Challenge – Datatype Conversion Nightmares

When Database Migrations Go Wrong: Snowflake to Oracle Every database migration project starts with optimism: “We’ve mapped the tables, the data looks similar – how hard can it be to…

Read More

Encrypting SQL Server Database: Transparent Data Encryption (TDE)

Introduction  Transparent Data Encryption (TDE) in SQL Server secures sensitive data by encrypting database files at rest without impacting application access, helping organizations protect against unauthorized data exposure.  Steps to…

Read More

Removing Transparent Data Encryption (TDE) from SQL Server

Introduction  Removing Transparent Data Encryption (TDE) from SQL Server involves carefully disabling encryption and cleaning up encryption keys to ensure your database is decrypted and accessible.  Steps to remove TDE:  …

Read More

Oracle Autonomous Health Framework Fleet Insights Configuration

Introduction: AHFFI is a function that collects data collected by AHF from multiple servers and  displays it on a single screen. Why we need to do Observe key issues across your fleet-Dashboards allow for in-depth analysis of the root  cause of each issue-If necessary, drill down into specific insight reports to identify  detailed. Support Platform: (OEL) x86_64, (RHEL) x86_64, db 19c or later and ahf 24.9 or later system requirements for ahffi : 4 cores CPU, 16GB RAM, 4GB disk space yum install cronie sudo yum install iproute sudo yum install hostname INSTALLATION STEPS: Download ahffi from link 3043060.1 mos Prerequisite setup Install jdk-24 Install instant client sqlplus 23.4.0 Install instant client basic 23.4.0 Create a user for ahffi on 23ai database create user ahffi identified by ahffi;  grant create session to ahffi;  grant connect, resource to ahffi;  grant create table to ahffi;  grant insert any table to ahffi;  alter user ahffi quota unlimited on users; Download the ahffi file and upload it to the server    …

Read More