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:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 5:56 PM To: [email protected] 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
