RE: Oracle - LD_LIBRARY_PATH doesn't work...

[Sterin, Ilya]

What's the error.  It's hard to tell without an error message.  Use trace()
at level 2 if you haven't yet.

Ilya Sterin

-----Original Message-----
From: Raj Srinivasan [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:14 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: DBD:Oracle - LD_LIBRARY_PATH doesn't work...


Hi,

I am building perl for distribution on several machines and I am having
difficulties in using DBD:Oracle with that build.

I have installed the DBD:oracle after setting up ORACLE_HOME and
LD_LIBRARY_PATH.
"make test" didn't report any errors. Available_drivers returns "Oracle"
driver as installed.

Driver: Oracle
        Data Source is dbi:Oracle:DMART01.world
        Data Source is dbi:Oracle:QA01.world
        Data Source is dbi:Oracle:QA02.world
        Data Source is dbi:Oracle:QUIQ.world
        Data Source is dbi:Oracle:TST01.world

Now the question is...

If I declare the LD_LIBRARY_PATH as my shell env variable, I could able
to make connection to the oracle database.

If I declare the LD_LIBRARY_PATH as part of the script, the connection
don't go thru.

#!/netapp01/repository/perl/bin/perl -w
$ENV{"ORACLE_HOME"}="/quiq/share/OracleClient";
$ENV{"LD_LIBRARY_PATH"}="/quiq/share/OracleClient/lib";


Do I have to install DBD for oracle differently.
Am I doing anything wrong? Any ideas?

Thanks.. Raj
====================================================================

$ /netapp01/repository/perl/bin/perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
  Platform:
    osname=linux, osvers=2.2.14-va.2.1smp, archname=i686-linux
    uname='linux selma.west.quiq.com 2.2.14-va.2.1smp #1 smp mon jul 31
21:53:20 pdt 2000 i686 unknown '
    config_args='-Dprefix=/netapp01/repository/perl -des'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
    useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
  Compiler:
    cc='cc', ccflags ='-fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
    optimize='-O2',
    cppflags='-fno-strict-aliasing'
    ccversion='', gccversion='egcs-2.91.66 19990314/Linux (egcs-1.1.2
release)', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
    alignbytes=4, usemymalloc=n, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib
    libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt -lutil
    perllibs=-lnsl -ldl -lm -lc -lposix -lcrypt -lutil
    libc=/lib/libc-2.1.3.so, so=so, useshrplib=false, libperl=libperl.a
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
    cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options: USE_LARGE_FILES
  Built under linux
  Compiled at Apr 23 2001 10:34:09
  @INC:
    /netapp01/repository/perl/lib/5.6.1/i686-linux
    /netapp01/repository/perl/lib/5.6.1
    /netapp01/repository/perl/lib/site_perl/5.6.1/i686-linux
    /netapp01/repository/perl/lib/site_perl/5.6.1
    /netapp01/repository/perl/lib/site_perl
    .