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...
Welcome to our blog, which is more than just a record of our experiences. It’s a resource.
Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
Create Temporary Tablespace in Oracle and Make It the Default Temporary Tablespace
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...
Transitioning to the Windows App: Essential Information for Remote Access
SUMMARY: Microsoft is replacing the Azure Virtual Desktop Preview with the unified Windows App to ensure uninterrupted service by centralizing access to cloud PCs, virtual desktops, and local resources through a single, cross-platform gateway. The Windows App provides...
How to Upgrade Oracle Database to 19c
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...
The Rising Costs of Database Monitoring Tools and Why Virtual-DBA Is the Smarter Choice
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...
Azure Removing Default Outbound Access for Virtual Machines
SUMMARY: Microsoft is retiring default outbound internet access for new Azure Virtual Machines on September 30, 2025, to enhance cloud security by requiring administrators to replace unmanaged, ephemeral IP addresses with explicit routing solutions like NAT Gateways...
PostgreSQL in GCP: Tackling “permission denied for language C”
SUMMARY: Database administrators can resolve the PostgreSQL "permission denied for language C" error in Google Cloud Platform (GCP) by abandoning custom C-language functions and instead enabling the native uuid-ossp extension for secure UUID generation. GCP Cloud SQL...
Azure Deprecating TLS 1.0 and 1.1
SUMMARY: Microsoft is deprecating Transport Layer Security (TLS) versions 1.0 and 1.1 across Azure SQL services, requiring organizations to upgrade client connectivity to TLS 1.2 by August 31, 2025, to ensure data security and compliance. Azure SQL Database and...
Oracle Database 23ai: To Upgrade or Not To Upgrade?
Table of contentsImportant Note: 23ai AvailabilityWhen Upgrading to Oracle, 23ai Makes SenseWhen Upgrading to Oracle 23ai Might Not Be the Best Idea (Yet)Conclusion As Oracle DBAs, we constantly evaluate new releases, weighing the benefits against the potential risks....
XTIVIA’s 2024 Virtual-DBA Performance: Hot-Off-The-Presses NPS and CSAT Scores
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...









