> -----Original Message----- > From: Michael Muratet [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 15, 2008 2:30 PM > To: [email protected] > Subject: All tests fail for any other than user 'oracle' > > Greetings > > I installed the Oracle Instant Client packages by rpm back in > December. Because of the install or more likely coincidentally I had > problems with corruption of the system files of the database. The > database was empty at the time and I simply rebuilt it.
Did you install all three packages? oracle-instantclient-devel-10.2.0.3-1 oracle-instantclient-basic-10.2.0.3-1 oracle-instantclient-sqlplus-10.2.0.3-1 > I am trying now to get DBD::Oracle working. The DBI install came off > without a hitch. The DBD perl build and the make worked OK (logs are > at the end). The first attempt at testing failed. I recalled something > I had read about file permissions and the user 'oracle'. I logged in > as oracle and all the tests were successful. sqlplus works but only > for user oracle. I find something like this helps a lot: cd /usr/lib sudo ln -sf /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so.10.1 . sudo ln -sf /usr/lib/oracle/10.2.0.3/client/lib/libclntsh.so . sudo ln -sf /usr/lib/oracle/10.2.0.3/client/lib/libnzz10.so . > Is this normal? If the user is 'nobody' or 'daemon' as in a web > application, it seems doomed to fail. Should I be looking for problems > with the client installation? (I am aware of the security issues > surround access to the executables.) I've found nothing the > documentation that seems to fit. > > Thanks > > Mike > -- Stephen
