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 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 MoreOPatch 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 MoreTo 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 MoreHow 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 MoreAzure 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 MoreAll about txkCfgUtlfileDir.pl utility in Oracle 19c for EBS database
All about txkCfgUtlfileDir.pl utility in Oracle 19c for EBS database: Introduction: Recently, we upgraded our ERP system from version 12.1.0.2 to Oracle 19c in an OCI environment. One challenge we…
Read Moresys.wrm$_wr_control( ACTIVE_SESSION_HISTORY)Does Not Get Purged Based upon the Retention Policy
It appears there is an issue with the purging mechanism of AWR (Automatic Workload Repository) tables in Oracle databases. The main problem is that the tables are not being purged…
Read MoreAWR Snapshots to Reduce Space Usage of SYSAUX Tablespace
AWR (Automatic Workload Repository) snapshots can be used to reduce the space usage of the SYSAUX tablespace by periodically purging older snapshots. The SYSAUX tablespace can grow rapidly due to…
Read MoreORA-19809: limit exceeded for recovery files in dataguard
SYMPTOM On primary database side, ORA errors in alert log: Errors in file /u01/app/oracle/diag/rdbms/testdb001/TESTDB001/trace/TESTDB001_arc4_10114.trc: ORA-07286: cannot obtain device information. ARC4: FAL archive failed with error 7286. See trace for details …
Read More