Justice Asante, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts Remote Database Administration Fri, 13 Mar 2026 16:25:53 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Justice Asante, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts 32 32 How to Resolve ORA-3815 “Software edition is incompatible with SQL plan management” Error https://virtual-dba.com/blog/how-to-resolve-ora-3815-software-edition-incompatible-with-sql-plan-management-error/ Tue, 10 Mar 2026 19:26:01 +0000 https://virtual-dba.com/?p=243717 SUMMARY: Database administrators can permanently resolve the ORA-3815 “Software edition is incompatible with SQL plan management” error in Oracle Standard Edition 2 by disabling the SQL Tuning Advisor autotask. Disabling this unsupported dependency guarantees that routine database maintenance tasks will run normally without triggering further alert log errors. Introduction Oracle’s Standard Edition 2 (SE2) does […]

The post How to Resolve ORA-3815 “Software edition is incompatible with SQL plan management” Error appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Performance Tuning in Oracle 19c: From AWR to SQL Plan Management https://virtual-dba.com/blog/performance-tuning-in-oracle-19c-awr-to-sql-plan-management/ Thu, 15 Jan 2026 20:22:14 +0000 https://virtual-dba.com/?p=243595 SUMMARY: Database Administrators can maximize the stability and efficiency of Oracle 19c environments by leveraging built-in diagnostic tools to pinpoint bottlenecks, automate query optimization, and enforce consistent execution plans. By integrating these utilities into a routine maintenance checklist, IT teams can shift from reactive troubleshooting to proactive performance management, ensuring critical systems remain fast and […]

The post Performance Tuning in Oracle 19c: From AWR to SQL Plan Management appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Oracle 12c to 19c Database Upgrade Manual https://virtual-dba.com/blog/oracle-12c-to-19c-database-upgrade-manual/ Fri, 31 Oct 2025 03:08:00 +0000 https://virtual-dba.com/?p=243467 SUMMARY: Database administrators can achieve improved performance, stability, and extended support by executing a four-step migration from Oracle 12c to the long-term support version 19c, primarily utilizing the visual and automated Database Upgrade Assistant (DBUA). Using the Database Upgrade Assistant (DBUA) provides an intuitive graphical interface that automates many manual tasks; however, administrators must still […]

The post Oracle 12c to 19c Database Upgrade Manual appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> RMAN Level 0 and Level 1 Backup Strategy in Oracle 19c https://virtual-dba.com/blog/rman-level0-level1-backup-strategy-in-oracle-19c/ Tue, 28 Oct 2025 21:17:16 +0000 https://virtual-dba.com/?p=243452 Summary This blog post outlines how to design and implement an RMAN Level 0 and Level 1 incremental backup plan in Oracle 19c, covering configuration, automation, validation, and maintenance for reliable database recovery. Introduction In today’s data-driven enterprise environments, database reliability and recoverability are non-negotiable. Oracle Recovery Manager (RMAN) remains one of the most powerful […]

The post RMAN Level 0 and Level 1 Backup Strategy in Oracle 19c appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> How to Resolve EM13c [Handshake Has No Peer] Error After Java Upgrade on OMS Server https://virtual-dba.com/blog/how-to-resolve-em13c-handshake-has-no-peer-error/ Wed, 20 Aug 2025 00:44:46 +0000 https://virtual-dba.com/?p=243235 SUMMARY: The Oracle Enterprise Manager 13c (EM13c) “[handshake has no peer]” error, which occurs after a Java upgrade on the Oracle Management Server (OMS), is an SSL/TLS communication failure that can be resolved by applying a specific Release Update (RU) patch. If the error persists after applying the patch, upgrading to Oracle Enterprise Manager 13.5 […]

The post How to Resolve EM13c [Handshake Has No Peer] Error After Java Upgrade on OMS Server appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Resolving Oracle Patch Issues: Troubleshooting ORA-20001 and Applying Datapatch https://virtual-dba.com/blog/resolving-oracle-patch-issues-troubleshooting-ora-20001-and-applying-datapatch/ Wed, 11 Jun 2025 00:40:20 +0000 https://virtual-dba.com/?p=243025 SUMMARY: Database administrators can successfully resolve the Oracle 19c datapatch ORA-20001 error, which signals an incomplete patch application, by modifying the qopiprep.bat script’s shell interpreter and then re-running the datapatch utility. Verifying patch application and consistently running datapatch after installing updates are crucial steps for maintaining an operational and fully patched Oracle database. Keeping your […]

The post Resolving Oracle Patch Issues: Troubleshooting ORA-20001 and Applying Datapatch appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Using Oracle Cloud Storage with RMAN for Backups https://virtual-dba.com/blog/using-oracle-cloud-storage-with-rman-for-backups/ Tue, 03 Jun 2025 21:20:52 +0000 https://virtual-dba.com/?p=243017 SUMMARY: Database administrators can establish cost-effective, reliable, and scalable cloud-based backups for their Oracle databases by integrating Oracle Recovery Manager (RMAN) directly with Oracle Cloud Infrastructure (OCI) Object Storage using the Oracle Database Cloud Backup Module. Leveraging OCI for RMAN backups minimizes on-premise infrastructure costs while significantly improving data security and disaster recovery capabilities. Oracle […]

The post Using Oracle Cloud Storage with RMAN for Backups appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Restoring Database from OCI Cloud Storage (Standard Cloud Account) https://virtual-dba.com/blog/restoring-database-from-oci-cloud-storage-standard-cloud-account/ Tue, 27 May 2025 15:51:00 +0000 https://virtual-dba.com/?p=243006 SUMMARY: Database administrators can achieve robust disaster recovery solutions by leveraging the Oracle Recovery Manager (RMAN) and the Oracle Database Cloud Backup Module to restore an Oracle database seamlessly from OCI Object Storage. When correctly configured, this process provides cloud resilience and scalability, ensuring critical data can be reliably restored with minimal manual intervention. Oracle […]

The post Restoring Database from OCI Cloud Storage (Standard Cloud Account) appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]>