Folks,
Some of these posts remind me that a few weeks ago I came across
a Solaris 8 server that had functioning sqlplus access to a separate
oracle server and perl 5.8.7.
The vendor was trying to load a compiled version of DBI from their
installation media. Their install would claim success but neither DBI
nor DBD::Oracle would work (it would just fail upon the use statement).
Rather than wait for the vendor to "escalate" things (which would be sad
seeing as how I see 5000 DBI related emails a day) I compared the Oracle
installs (one was a server one was a client install). As it turns out,
even though sqlplus worked from this machine, the "broken" machine was
missing a few files in the following directories :
(these directories weren't empty but they were exactly the same)
/export/home/oracle/product/9.2.0/rdbms/lib and
/export/home/oracle/product/9.2.0/rdbms/lib32
In this case I just copied what was missing them from the Oracle server
(luckily same OS and same platform) and immediately everything worked
fine. Removing the files again "broke" DBI in the same way again so the
fix/cause was clear.
Just thought I'd post since I think people something think that if you
have sqlplus access working then everything must be fine and it clearly
wasn't in this case.
-Matt
