RE: Oracle DBD runtime error

I don't know about 10 but on 9.2.0.4 you need to make sure to set up
your environment correctly. I usually have to set all of the following
variables with values like so :

LD_LIBRARY_PATH=/export/home/oracle/product/9.2.0/lib:/export/home/oracl
e/product/9.2.0/lib32:/export/home/oracle/product/9.2.0/ctx/lib
ORACLE_BASE=/export/home/oracle
ORACLE_HOME=/export/home/oracle/product/9.2.0
ORACLE_SID=xxxx
NLS_LANG=american_america.we8iso8859p1 (normally only on windows)

Are any of these vastly different between a working and non working user
profile?

-M

-----Original Message-----
From: Terry Maragakis [mailto:TMaragakis@xxxxxxxxxxxxxxxxxx]
Sent: Monday, January 29, 2007 5:56 PM
To: dbi-users@xxxxxxxx
Subject: Oracle DBD runtime error

I just installed DBI and Oracle DBD.



I can run the following program without error as root:



#!/bin/sh
echo DEFANGED.74
exit
#!/bin/perl -w



use DBI;

use DBD::Oracle;



my $dbh=DBI->connect("dbi:Oracle:DWHDEVR1","scott","tiger");



$dbh->disconnect();



But when I try to run it under my own user ID I get the following error:



Can't load
'/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle

..so' for module DBD::Oracle: ld.so.1: perl: fatal:
/software/app/oracle/product/

10.1.0/db_1/lib32/libclntsh.so.10.1: Permission denied at
/usr/perl5/5.8.4/lib/s

un4-solaris-64int/DynaLoader.pm line 230.

at ./test.pl line 4

Compilation failed in require at ./test.pl line 4.

BEGIN failed--compilation aborted at ./test.pl line 4.



It looks like a permissions problem but I cannot figure out where.



The Oracle version is 10.1 on Solaris 10.



Thanks,



Terry Maragakis

.