by Justice Asante | Mar 10, 2026 | Blog, Oracle
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. Administrators must first run a database...
by Justice Asante | Jan 15, 2026 | Blog, Database, Oracle
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. The Automatic Workload...
by Justice Asante | Oct 30, 2025 | Blog, Database, Oracle
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)....
by Justice Asante | Oct 28, 2025 | Blog, Oracle
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. Table of contentsSummaryIntroductionKey...
![How to Resolve EM13c [Handshake Has No Peer] Error After Java Upgrade on OMS Server](https://virtual-dba.com/wp-content/uploads/How-to-Resolve-EM13c-_Handshake-Has-No-Peer_-Error-After-Java-Upgrade-on-OMS-Server.jpg)
by Justice Asante | Aug 19, 2025 | Blog, Database, Oracle
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)...
by Justice Asante | Jun 10, 2025 | Blog, Database, Oracle
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. The appearance...
