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 MoreUsing 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 MoreHow 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 MoreResource 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 MoreNetwork 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 MoreSQL 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 MoreError 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 MoreManually 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 MoreOAM 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 MoreThe 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