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!
Low Disk Space on Server
Overview This document will cover procedures for low disk space alert on OS/C: drives as well as general disk space low alert. Low disk space can have potentially negative consequences with a server. Some examples are: Unable to install critical OS security...
Refreshing a Physical Standby Using Recover from Service on 12c
If you're in a situation where you need to resolve a gap in a Data Guard environment due to missing/corrupt archive logs, rolling forward the Physical Standby would be your best option vs. having to rebuild your entire physical standby database. It has become much...
What is MFA and Why does it Matter?
Multi-Factor Authentication (MFA) is something a lot of IT professionals know about but never want to bring up to their clients. MFA is the next step defense in your everyday battle in protecting your day to day operations. So let's talk about it. What is MFA?...
Validating VIP Usage
Recently, I was working on a database using HADR with failover handled by TSAMP. The database was configured to use a virtual IP (VIP) address. However, when I tested the failover with the application team, some of the applications were getting SQL1776N errors from...
ORA-00933: SQL command not properly ended
Prior to diving into this error, it's important we discuss how Oracle processes queries logically and in what order. Oracle has a couple of rules as to how it executes each query in a specific processing order. Oracle processes a query as below: Gathers rows based on...
Sockets, Cores, and Threads, oh my!
What do you mean, exactly, by "CPU"? Once upon a time, computers sat on our desks; we knew exactly how many processors they had; and back then our biggest uncertainty was whether they could handle Y2K. Fast forward to today: our computers have 4, 8 or 16 processors —...
Writing SQL with SQL
The Db2 RDBMS offers many great tools for getting things done. There are, however, times when tools are unavailable. This isn’t a problem when you’re performing a simple and discrete task. When the task has many iterations then like dropping triggers or granting...
MongoDB – WARNING: This replica set was configured with protocol version 0
If you’re upgrading a ReplicaSet from a version before 3.2 of MongoDB to a new version, you will run into this warning when connecting to the shell. Protocol Version 0 is not supported in MongoDB 4.0. Checking Protocol Compatibility To verify which protocol version...