this might help
http://coding.derkeiler.com/Archive/Perl/perl.dbi.users/2006-12/msg00029.html>
Subject: wrong ELF class:> Date: Tue, 1 Apr 2008 10:30:00 -0400> From: [EMAIL
PROTECTED]> To: dbi-users@perl.org> CC: [EMAIL PROTECTED]> > > Please advice
where I can find more information for the following error,> suggestions as to
how to debug, or any insight.> > Test runs from command prompt and when
scheduled by "at now", but not> cron.... > > Thank you in advance. > > > Your
"cron" job on sun105z3> ./test_dbi.pl> > produced the following output:> >
install_driver(Oracle) failed: Can't load>
'/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBD/Oracle/Oracl> e.so'
for module DBD::Oracle: ld.so.1: perl: fatal:>
/apps/oracle/10gR2/client/lib/libclntsh.so.10.1: wrong ELF class:> ELFCLASS64
at /usr/local/lib/perl5/5.8.8/sun4-solaris/DynaLoader.pm line> 230.> at (eval
3) line 3> Compilation failed in require at (eval 3) line 3.> Perhaps a
required shared library or dll isn't installed where expected> at ./test_dbi.pl
line 50> > script & full output below...> > John W Moon> > #!
/usr/local/bin/perl -W> use lib "$ENV{HOME}/local/library";> BEGIN {> $x=0;>
foreach $b (@INC) {> print "\$INC[$x] = $b\n";> $x++;> }> foreach $b (sort keys
%ENV) {> if ($b eq 'PATH') {> @path = split /:/, $ENV{PATH};> print "Path\n";>
foreach $p (@path) {> print "\t$p\n";> }> }> else {> print "$b\t =
\t$ENV{$b}\n";> }> }> require MyOracle;> &MyOracle();> }> use DBI;> print
"<$DATABASE, $PASSWD, $INSTANCE>\n";> print "After \&MyOracle()\n";> $x=0;>
foreach $b (@INC) {> print "\$INC[$x] = $b\n";> $x++;> }> foreach $b (sort keys
%ENV) {> if ($b eq 'PATH') {> @path = split /:/, $ENV{PATH};> print "Path\n";>
foreach $p (@path) {> print "\t$p\n";> }> }> else {> print "$b\t =
\t$ENV{$b}\n";> }> } > > $con_str=q{dbi:Oracle:xxxxx};> $u_str=q{xxxxxx};>
$p_str=q{xxxxxx};> $dbh=DBI->connect($con_str,$u_str,$p_str) or die
DBI->errstr;> $sth=$dbh->prepare(q{select count(*) from [EMAIL PROTECTED]) or>
die DBI->errstr;> $sth->execute or die DBI->errstr;> while
(@row=$sth->fetchrow_array) {> print join(',',@row), "\n";> }> > > Your "cron"
job on sun105z3> ./test_dbi.pl> > produced the following output:> >
install_driver(Oracle) failed: Can't load>
'/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBD/Oracle/Oracl> e.so'
for module DBD::Oracle: ld.so.1: perl: fatal:>
/apps/oracle/10gR2/client/lib/libclntsh.so.10.1: wrong ELF class:> ELFCLASS64
at /usr/local/lib/perl5/5.8.8/sun4-solaris/DynaLoader.pm line> 230.> at (eval
3) line 3> Compilation failed in require at (eval 3) line 3.> Perhaps a
required shared library or dll isn't installed where expected> at ./test_dbi.pl
line 50> $INC[0] = /export/home/billing/local/library> $INC[1] =
/usr/local/lib/perl5/5.8.8/sun4-solaris> $INC[2] = /usr/local/lib/perl5/5.8.8>
$INC[3] = /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris> $INC[4] =
/usr/local/lib/perl5/site_perl/5.8.8> $INC[5] = /usr/local/lib/perl5/site_perl>
$INC[6] = .> HOME = /export/home/billing> LOGNAME = xxxxxxxxx> Path> /usr/bin>
SHELL = /usr/bin/sh> TZ = US/Eastern> <xxxxxxxxxxx, xxxxxxx, xxxxxxxxxx>> After
&MyOracle()> $INC[0] = /export/home/billing/local/library> $INC[1] =
/usr/local/lib/perl5/5.8.8/sun4-solaris> $INC[2] = /usr/local/lib/perl5/5.8.8>
$INC[3] = /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris> $INC[4] =
/usr/local/lib/perl5/site_perl/5.8.8> $INC[5] = /usr/local/lib/perl5/site_perl>
$INC[6] = .> HOME = /export/home/billing> LD_LIBRARY_PATH =>
/apps/oracle/10gR2/client/lib32:/usr/local/lib:/usr/lib:/lib:/etc/lib>
LD_LIBRARY_PATH_64 =>
/apps/oracle/10gR2/client/lib:/usr/local/lib:/usr/lib:/lib:/etc/lib> LOGNAME =
xxxxxxx> ORACLE_HOME = /apps/oracle/10gR2/client> Path> /usr/bin>
/apps/oracle/10gR2/client/bin> /apps/oracle/10gR2/client/opmn/bin>
/usr/local/bin> /usr/ucb> /etc> /usr/local/lib/perl5/5.8.8/site_perl>
/usr/local/lib/perl5/5.8.8> SHELL = /usr/bin/sh> TWO_TASK = xxxxxx> TZ =
US/Eastern> > > http://dmspulsesurvey.myflorida.com/is> > > > > >
_________________________________________________________________
Enter today for your chance to win $1000 a day—today until May 12th. Learn more
at SignInAndWIN.ca
http://g.msn.ca/ca55/215
