Database Blog

Resolving Port Conflicts During ADOP Validation in Oracle E-Business Suite

Introduction: The ADOP (Autonomous Database Operations) process is a crucial component of the Oracle E-Business Suite (EBS) used during patching, cloning, and upgrades. During the validation phase of ADOP, a series of…

Read More

Detect symbolic link directories in Oracle

With the de-support of UTL_FILE_DIR with Oracle Database 18c. There’s a major behavior change in Oracle 18c/19c: No symbolic links for Data Pump directories. So if you have created a…

Read More

Using INCLUDE & EXCLUDE parameters together in Data Pump – Oracle 21c

A new enhancement in Oracle Database version 21c is saving a lot if effort in Data pump activities. In the earlier versions of Oracle using the INCLUDE and EXCLUDE parameters…

Read More

How to Generate AWR snaps for Multitenant Database at CDB and PDB level

The AWR snaps are usually generated at the CDB level by default. They can be created both at the CDB and PDB level.   To generate AWR report at CDB…

Read More

Oracle Latest DBSAT – Database Security Tool

In today’s fast-paced digital landscape, the importance of database security cannot be overstated. For leaders across your organization—be it a CEO guiding overall strategy, a CTO focused on technology innovation,…

Read More

Resource access issue in Azure resource Group

Why We Need to Do Cause of the Issue  Cause of the Issue:  Intermittent resource access issues in an Azure Resource Group can be caused by various factors, including:  Resource…

Read More

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