Tag: troubleshooting

Here’s a short and sweet post. “In Deploy mode, AutoUpgrade also confirms that the upgrade has succeeded, and moves database files such as sqlnet.ora, tnsnames.ora, and listener.ora from the source home to the target home. After these actions are complete,…

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6    5: Troubleshooting In this post I’ll be sharing a few issues that we faced and sorted out. From a…

Jared Still, Pythian Principle Consultant and Oracle ACE, explains how to simplify your trouble shooting tasks through tracefile automation.

Jared Still, Pythian Principle Consultant and Oracle ACE, outlines the difficulties associated with troubleshooting connectivity issues when dealing with Oracle and provides tips on how to overcome them.

Troubleshooting Cassandra Under Pressure This is the second blog post in the series. This is a bit more technical than the first one. I will explain some things that can be made to keep a cluster/server running when you are…

I worked on root cause analysis for a strange node reboot on client’s Oracle Database Appliance yesterday. The case was quite interesting from the perspective that none of the logs contained any information related to the cause of the reboot….

Along with other administrators, life of us, the DBAs are no different but full of adventure.  At times, we encounter an issue which is very new for us, rather, one that we have not faced in the past.  Today, I…

In past few days I had two incidents and an outage, for just a few minutes. However, outage in a production environment is related to cost relatively and strictly. The server that had outage was because of failing over and…

I’ve always wanted to get my hands on SSAS, SSIS and SSRS as I’ve often felt shorthanded in these areas. Yesterday I decided to play around with one of these and get my hands dirty – SSAS. A few months…

Kenny Tilton posted about database troubleshooting, and he anecdotally illustrates and elaborates on a law of troubleshooting that I strongly agree with: Always solve the first problem. The corollary to his law is that “there only is the first problem.” I’m not sure I entirely agree with that one, but I will admit that that corollary is true at least 90% of the time, which is often enough to make it an incredibly useful insight.