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 MoreIt 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 (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 MoreSYMPTOM 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 MoreIntroduction 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 small application or…
Read MoreIntroduction 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…
Read MoreINTRODUCTION 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…
Read MoreIntroduction to Failover: Oracle Failover is a critical feature designed to ensure high availability and continuous operation of Oracle databases in the event of unexpected system failures. In enterprise environments…
Read MoreISSUE: When I initiated the grid patch, it failed while executing the prerequisite with the following errors: PRVF-4083: Node reachability check failed from node <NODE1>. PRKN-1035: Host unreachable.” Cause of…
Read MoreIntroduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to download the database backup from OCI…
Read More