Knowledge increases exponentially. Today, you probably own more books than great universities of times past—Cambridge University owned less than two hundred books in the fifteenth century. First came the invention of writing, then alphabets, then paper, then the printing press, then mechanization. Each step caused an exponential increase in the collective human knowledge. In our generation, Al Gore invented the internet and the last barriers to the spread of knowledge have been broken. Today, everybody has the ability to contribute, communicate, and collaborate. We are all caught up in a tsunami, an avalanche, a conflagration, a veritable explosion of knowledge for the betterment of humankind. This is the blog of the good folks at Database Specialists, a brave band of Oracle database administrators from the great state of California. We bid you greeting, traveler. We hope you find something of value on these pages and we wish you good fortune in your journey.

An introduction to emacs SQLi mode

Introduction

Early in my career, when I was first introduced to Unix, my mentor at the time recommended that I use a text editor called emacs, but also learn how to use vi as well. I personally like both editors, but I prefer emacs for coding. Over the decades, I’ve continued to use emacs; [...]

postgreSQL, mysql, and Oracle

Although my main interest is in the venerable Oracle database as database administrator and as a programmer over the past 17 years or so, at the same time I have been following along with the progress of the various open-source databases as well with quite a keen interest. The two that I’ve [...]

Installing 11g Grid Control on Linux

I recently installed Oracle Grid Control 11g on my linux workstation. Below are the steps that I went through to get it working.  Prior to installing Control, I had already installed Grid Infrastructure 11.2.0.2 and Oracle Database 11.2.0.2 and created a database to be used as the Grid Control repository.
Step 1) Download the Grid Control software:
- [...]

Upgrading Grid Infrastructure and ASM from 11.2.0.1 to 11.2.0.2 (and a bit about Oracle Restart)

My initial goal was simply to create a test ASM environment on my PC running Oracle Enterprise Linux 5 and Oracle Database 11.2.0.2. The first step was easy…download and install Grid Infrastructure 11.2.0.1. This went without a problem until I ran the ASM Configuration Assistant (asmca) and realized that ASM couldn’t see any available [...]