It's no secret that I'm a MySQL newbie and I've had my share of issues installing the MySQL client. That was kind of a special case since I wasn't using a mainstream compiler, but even so, I was able to get the problem fixed in relatively short order.
One of my tasks lately has been to upgrade the Oracle client to version 10.2. I've installed the client software a couple dozen times and the server software maybe 100 times if I want to be conservative. So when I fired up the installer, I wasn't expecting many surprises.
As expected, I installed the base 10.2.0.1 release in about 20 minutes. I then applied the 10.2.0.2 patch on top of it in another 10 minutes. I ran sqlplus as oracle and was able to connect to a database, so I pushed it out to a group of test users.
Two seconds later: "Ah, sqlplus doesn't work."
"I just ran it, your environment variables must not be setup correctly."
"Ah, sqlplus still doesn't work."
So I logout as oracle and try it from my workstation:
ld.so.1: sqlplus: fatal: /usr/local/oracle/lib/libsqlplus.so: Permission denied
sonofa...WTF can be wrong?
Sure enough, I didn't have permission on the library. I logged in as oracle, and I had permission on the file, but world didn't have any permissions.
Hmm, That never happened before. I must have screwed something up.
I re-installed and had the same problem.
I logged a TAR to Oracle support and seems like it's a known bug (4516865).
Another great example of why you get so much more value with Oracle than MySQL. Sigh.