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, [...]
Database
Insights and Experiences from Doyensys’ Database Administrators.
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 [...]
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. [...]
All 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 [...]
By Gobinath
Posted sys.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 [...]
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 Group Limits: [...]
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 stem from [...]
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 [...]
All 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 [...]
By Gobinath
Posted sys.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 according to [...]
By Gobinath
Posted AWR 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 [...]
ORA-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 [...]
Enable CloudWatch Contributor Insights of DynamoDB tables in AWS Console
Introduction Amazon CloudWatch Contributor Insights is a powerful tool that helps you understand the most active and impactful contributors to your DynamoDB workloads. Whether you’re managing a [...]
Backup a DynamoDB Table Using AWS Management Console
Introduction Amazon DynamoDB is a popular database service used by many businesses to store important data. Just like you would save your work to avoid losing it, backing up your DynamoDB tables [...]
OEM13.4 TARGET STATUS SHOWING WARNING
INTRODUCTION This blog is about, one of our non-prod OEM13C environment the Database target status was showing warning eventhough the target is actually up and running. SOLUTION Login into OEM [...]