February 2016

One of the challenges when taking a new position as an Oracle DBA is getting a good survey of the landscape for which you are responsible. Especially in smaller shops with only one Oracle DBA there is often a dearth of reliable documentation – or any documentation at all! An initial look at a server
Read More

In a recent exchange on the Oracle Technology Network forums, one of the participants asked “What was the Y2K problem ? Please describe in details.”  And a few years ago a younger co-worker told me point-blank that he had “read about Y2K” and concluded the whole thing was a hoax. These comments disturbed me in
Read More

Configuring the Oracle VirtualBox Network

In “Create a private Oracle test lab” I made the case that there is no excuse for someone who considers themselves to be a professional DBA to not have their own personal database for testing and learning. I pointed out that by using Oracle’s VirtualBox product, Oracle Linux, and Oracle database under the terms of
Read More

Some time back I began to get an odd complaint from some of my end users. It seems that when they connected to the Oracle database, they received a warning that their password was about to expire, and yet never – even after the password grace period had passed – received a prompt to change
Read More

I recently assisted a user on OTN with an ora-12514 that was a bit more of a puzzle, and in the end resulted from the “interference” of the TWO_TASK environment variable.  My explanation to him looked very much like a good posting, so here’s the improved version. Background There are essentially two methods of establishing
Read More

Taking a breather from my exploration of TNS connection issues, I’d like to take a quick romp through the use (and mis-use) of date formatting. There are no deep mysteries revealed here, and everything is quite well documented. But judging from traffic on popular Oracle forums, it appears this is an area that leaves a
Read More

I often see people afraid to try even the simplest of tasks on their Oracle databases, asking “Can I <fill in the blank>?” When it is suggested they try for themselves and see what happens, the common excuse is “I don’t have a test system.” Every oracle professional (or student) should have their own private
Read More