RE: All tests fail for any other than user 'oracle'

-----Original Message-----
From: Michael Muratet [mailto:mikemuratet@xxxxxxx]
Sent: Tuesday, January 15, 2008 2:30 PM
To: dbi-users@xxxxxxxx
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
.

Relevant Pages

  • Re: Adding RAM
    ... About Oracle, I currently use Mysql for my TM databases but I have been ... Limited to a 4GB database but that should be adequate ... The rpm is easy to install and you get a nice tutorial to ... Here's the link to the Oracle-10g + Compiere installation on SuSE ...
    (alt.os.linux.suse)
  • Re: Upgrade 8i to 9i --- multiple oracle_base !!!!!!
    ... > it's own system owning account. ... > 1) Install one copy of the latest version of SQL-Backtrack into its own ... completely separate from any Oracle directories. ... > 2) Shutdown and cold backup both databases. ...
    (comp.databases.oracle.server)
  • RE: DBD::Oracle on Oracle 11g 64 bit fedora 10
    ... I am having some worries with a new install of fedora 10. ... I also installed oracle 11.1.0.7. ... Napier University is a registered Scottish charity. ... Edinburgh Napier University is a registered Scottish charity. ...
    (perl.dbi.users)
  • RE: Problems to Install Oracle Client 10g over Red Hat AS 3.0update3
    ... Oracle 10g R1 DB go out of memory once in a while goes for a toss till it ... "General Red Hat Linux discussion list" ... Problems to Install Oracle Client 10g over Red Hat AS 3.0update3 ...
    (RedHat)
  • Re: ORA-01031
    ... I Installed Oracle Instant Client as instructed by ORACLE in the ... 'Application Account' which is not an oracle account. ... Then you have to ask yourself what password you put in when you install ...
    (comp.databases.oracle.misc)