Database Blog

Network Connectivity issue in Azure VM

Introduction/ Issue: Intermittent network connectivity drops on an Azure Virtual Machine (VM)  Why we need to do / Cause of the issue:  Network connectivity issues on an Azure VM can…

Read More

SQL Always on Configuration

Description:  SQL Server Always On is a feature that keeps your databases available even if something goes wrong with the server. It copies your data to other servers so that…

Read More

Error while changing Apps _NE Password

Unable to alter user APPS_NE to change password while changing APPS password using FNDCPASS  Issue:  Changing apps password using FNDCPASS fails with below error APP-FND-02704: Unable to alter user APPS_NE…

Read More

Manually Upgrade APEX for 19c upgrade:

Introduction: This document is intended for APEX upgrade from 23.1 to 24.1 Why we need to do: Upgrade older version to newer version. Steps to upgrade: a. Check the current…

Read More

OAM and OID Issue

OAM is configured with EBS and you see errors like below while opening SSO Url (although EBS non-SSO link is working fine). Error 500–Internal Server Error Failure of server APACHE…

Read More

The listener supports no services.

The listener supports no services Introduction: This document is intended for DBA’s who need to know the listener supports no services. Why we need to do: Listener is not support…

Read More

OPatch failed with Error code 73

NOTE: While applying patch in Agile server database we got this error    INTRODUCTION:   This document aims to provide a comprehensive guide for troubleshooting OPatch error code 73. It will…

Read More

To Move a PostgreSQL Data Directory To a different location

Description: This document outlines the steps required to change the data directory of a PostgreSQL database to a different location. The data directory is where PostgreSQL stores all of its…

Read More

How to Install PostgreSQL 16 on Oracle Linux 8

Description: This document provides simple, step-by-step instructions for installing PostgreSQL on Oracle Linux. It guides you through the entire process, from setup to configuration, ensuring you can get PostgreSQL up…

Read More

Azure deployment of IaaC with Terraform

Azure deployment of IaaC with Terraform Introduction: In this blog, we will go through steps to deploy terraform for deploying infrastructure to Azure. Using below steps, we can deploy infrastructure…

Read More