The effects of COVID-19 continue to disrupt "business as usual." However, there are opportunities for strengthening business processes and even growth that were not present previously. Here is XTIVIA's top 10 list of things your DBA could be doing to help make the...
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.
MongoDB – WARNING: readConcern:majority is enabled
If you're running a 3 member ReplicaSet that uses an Arbiter as its third member, then you will be presented with this warning when you connect to the shell. When a node goes down in a PSA architecture (Primary, Secondary, Arbiter) the wiredTiger storage engine starts...
Golden Gate 19c Unidirectional Replication from non-CDB to PDB
This article explains how to configure Oracle Golden Gate software to perform a unidirectional replication from a source non-CDB database on Oracle 12c to a target pluggable database on Oracle 19c. One possible use case is if you need to migrate from your non-CDB...
MongoDB – WARNING: This server is using MONGODB-CR
MongoDB-CR is the challenge response authentication mechanism used in MongoDB versions before 4.0. In version 4.0 this mechanism is removed and you must upgrade to the new mechanism SCRAM before you upgrade to 4.0. You will receive this warning if you have launched...
MySQL Max Connect Errors
When connection requests to a MySQL database from a given host are interrupted, MySQL keeps track of the number of successive interruptions in the host cache. MySQL will eventually block the host, giving them a message [1129] "Host 'host_name' is blocked because of...
MongoDB – WARNING: This Server is bound to localhost
When you're upgrading from previous versions before 3.6 you might notice this warning showing up in the shell when you start the server for the first time. This warning is telling you that you don't have an IP bound to your instance, preventing any connections to the...
Oracle 11g AUD$ Table Maintenance after ORA-01653: unable to extend table SYS.AUD$
Problem: ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM This error generally results when the aud$ table has a next_extent value that is greater than the available contiguous space in the SYSTEM tablespace. The aud$ table records logins to the...
MongoDB – Disabling Transparent Huge Pages Ubuntu 16.04+
When running a MongoDB instance, it's always important and even recommended to disable Transparent Huge Pages. Database workload can be poor when THP is enabled. Service File This service will allow you to disable THP during startup. Create the service file we'll use....
How to Install Agent for Hybrid Management Via Azure Arc
Microsoft states, "Azure Arc for servers allows you to manage machines which are outside of Azure. When a non-Azure machine is connected to Azure, it becomes a Connected Machine and is treated as a resource in Azure. Each Connected Machine has a Resource ID, is...
Amazon RDS – Serverless Automated Snapshots Tutorial
Snapshots in Amazon when taken manually, are not available for scheduling. In order to accomplish this you could run Amazon CLI but for that you would need to execute from a server based on a cron job or something similar. This solution will allow you to run a...









