On 24/09/07 20:23, Peter Koczan wrote:
> Hello all,
>
> I'm trying to get an Oracle client working under Linux and I'm having
> problems running a test script. Here's the error: [koczan@ator] lab $
> perl oracle.pl perl: symbol lookup error:
> /s/oracle/perl5/lib/site_perl/5.8.6/i686-linux-64int/auto/DBD/Oracle/Oracle.so:
> undefined symbol: OCINlsEnvironmentVariableGet
[snip]
> So, in the perl script, I do this:
> ------------
> #!/s/std/bin/perl
>
> use DBI;
> use lib '/s/oracle/perl5/lib';
> use lib '/s/oracle/perl5/lib/site_perl';
>
> use strict;
>
> $ENV{ORACLE_HOME} ||= "/s/oracle";
> $ENV{TWO_TASK} ||= "INFOACCESS.CS.WISC.EDU";
> $ENV{LD_LIBRARY_PATH} ||= "$ENV{ORACLE_HOME}/lib";
The above is done too late. LD_LIBRARY_PATH must be set before
perl starts.
> $ENV{TNS_ADMIN} ||= "$ENV{ORACLE_HOME}/network/admin";
>
> my $dbh = DBI->connect("dbi:Oracle:", [user], [password])
> || die "Couldn't connect to Oracle: $!";
> #
>
> # more stuff here that never executes
>
--
Charles Jardine - Computing Service, University of Cambridge
c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
