aging acolyte has asked for the wisdom of the Perl Monks concerning the following question:
Monks,
I am confused (my usual state) but right now I have reason!
I am trying to get a perl script to talk to an Oracle database. Oracle DBD seems to be installed correctly.But I get this strange error (see below).
My perl script sits on a linux box and my Oracle dB on a sun server. However, I am confident that Oracle is set up correctly as I can access it via sqlplus from my linux box.
A search of the site revealed a few related links 28533 but all seem to indicate that the Oracle library(LD_LIBRARY_PATH) isn't installed correctly. But I think it is.
Any ideas?
Thanks
A.A.
generates the error message:#!/usr/bin/perl -w BEGIN { $ENV{ORACLE_BASE} = '/usr/local/share/oracle'; $ENV{ORACLE_HOME} = "$ENV{ORACLE_BASE}/815client"; $ENV{LD_LIBRARY_PATH} = "$ENV{ORACLE_HOME}/lib"; $ENV{TNS_ADMIN} = "$ENV{ORACLE_HOME}/network/admin"; } use strict; use CGI; use CGI::Carp 'fatalsToBrowser'; use DBI; use DBD::Oracle; use Data::Dumper; . . . print "path = $ENV{LD_LIBRARY_PATH} \n"; my $dbh = DBI->connect("dbi:Oracle:database=XYZDEV01", 'user', 'pass') + || die $DBI::errstr; . . .
Commenting out the my $dbh line.. reveals thatperl: relocation error: /usr/lib/perl/5.6.1/auto/DBD/Oracle/Oracle.so: + undefined symbol: OCIInitialize
as it should be!path = /usr/local/share/oracle/815client/lib
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Oracle DBI
by mpeppler (Vicar) on Jan 21, 2003 at 18:53 UTC | |
Re: Oracle DBI
by OM_Zen (Scribe) on Jan 21, 2003 at 16:12 UTC | |
by aging acolyte (Pilgrim) on Jan 21, 2003 at 16:18 UTC | |
Re: Oracle DBI
by OM_Zen (Scribe) on Jan 21, 2003 at 18:12 UTC | |
Re: Oracle DBI
by perrin (Chancellor) on Jan 21, 2003 at 16:58 UTC |
Back to
Seekers of Perl Wisdom