Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
How to Create an RMAN Recovery Catalog in Oracle 18c
Recovery Catalog Purpose: The RMAN recovery catalog is a schema created inside of a new or existing database that is used to store metadata about Oracle databases. It's recommended by XTIVIA that the catalog be created in its own dedicated database due to the...
What’s in Our Virtual-DBA Name?
Virtual-DBA came out of XTIVIA's response to an urgent need in the market to limit travel during the dotcom bubble burst. It was vital for our customers to conserve travel resources, both time and money, while getting immediate response on database issues. In that...
Top 10 Things You and Your DBA Can Do to Pivot From the Effects of COVID-19
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...
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...