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 of...
SUMMARY: XTIVIA's expert DBA team addresses the high costs and persistent performance issues associated with managed cloud databases by implementing strategic, holistic optimization techniques, rather than resorting to costly resource over-provisioning. Simply scaling...
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...
SUMMARY: Database administrators must select between the free, open-source Percona XtraBackup and the commercial MySQL Enterprise Backup (MEB) to perform reliable hot backups of large MySQL deployments, weighing cost savings against integrated enterprise features and...
When creating the fast recovery area, place it on a separate disk from the database binaries and data files. For this example, I am using the C drive because this is on a VM, which is what is available. The size of your fast recovery will also depend on several...
SUMMARY: Transparent Application Failover (TAF) is an essential high-availability feature in Oracle Database, typically used in Real Application Clusters (RAC) environments, that automatically reconnects client applications to a healthy instance when a failure (like a...
This article covers the steps to create a temporary tablespace in Oracle and make it the default temporary tablespace for the database. Step-By-Step This method works for both regular Oracle databases and multitenant databases. Each PDB and CDB has its own separate...
Below is a step-by-step guide to walk you through how to upgrade oracle database to 19c. Step 1 Download the Oracle 19c binaries, the latest version of OPatch, How To Download And Install The Latest OPatch (6880880) Version (Doc ID 274526.1) and the AutoupGrade Tool...
SUMMARY: XTIVIA’s Virtual-DBA service addresses the escalating costs of traditional database monitoring by replacing rigid, per-instance licensing with a predictable subscription model that integrates automated alerts with expert, US-based human support to ensure...
Okay, we have to tell you—we're over the moon about these numbers! Our 2024 Net Promoter Score (NPS) and Customer Satisfaction (CSAT) scores for Virtual-DBA are just incredible. This year stood out as a true highlight, marking the peak of client sentiment and...