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.
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-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...
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...
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...
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...
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....
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...
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...
In my previous blog, I presented some of the issues you can run into when setting up one auxiliary HADR standby and a potential solution. This blog discusses setting up two auxiliary standby databases in detail. Let's start with all the information we need to set the...
Data is the lifeblood of your business, which means taking care of it is essential for operating your business. Whether your company uses SQL Server, Oracle, Db2, or PostgreSQL, quality database support, maintenance, and protection must be an integral part of your...