In a recent thread on OTN, the OP was having a difficult time understanding dynamic registration. They were confused about the interactions of settings in listener.ora, tnsnames.ora, and the local_listener parameter.  After responding to the thread with a summary, I thought it might be worth repeating here, along with a few more  references.  I actually
Read More

VirtualBox Computer Lab Framework

In my article, Create a Private Oracle Test Lab I expressed my opinion that every serious student of Oracle databases should have their own private computer lab.  In Configuring the Oracle Virtual Box Network, I detailed the specifics of configuring the network adapters in virtual machines running under VirtualBox.  In the time since I wrote
Read More

Sometimes the solution to a problem is not technology. Many years ago I read a column in PC Magazine, written by by John Dvorak. In the article, Mr. Dvorak was questioning the growing popularity of digital pagers. That alone gives a clue as to how long ago the article was published. In the article, Mr.
Read More

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