DBD::Oracle Install Problems

[Tonya Underwood]

HAVING ISSUES INSTALLING DBD:Oracle...

OUTPUT OF perl -V


[root@bdhp4264:/home/aq1764/DBD-Oracle-1.14]
## perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration:
Platform:
osname=hpux, osvers=11.00, archname=PA-RISC2.0
uname='hp-ux ness b.11.00 a 9000780 2012209406 two-user license '
config_args='-d -e -Dcc=gcc -Dprefix=/usr/local useposix=true'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_HPUX_SOURCE -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE',
optimize='-O2',
cppflags='-D_HPUX_SOURCE -D_HPUX_SOURCE -fno-strict-aliasing -I/usr/local/include'
ccversion='', gccversion='3.3.2', gccosandvers='hpux11.00'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4
alignbytes=8, prototype=define
Linker and Libraries:
ld='/usr/bin/ld', ldflags =' -L/usr/local/lib -L/opt/local/lib'
libpth=/usr/local/lib /opt/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lnsl -lnm -lndbm -lgdbm -ldb -lmalloc -ldld -lm
perllibs=-lnsl -lnm -lmalloc -ldld -lm
libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='-fPIC', lddlflags='-b -L/usr/local/lib -L/opt/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under hpux
Compiled at Feb 2 2004 09:09:51
@INC:
/usr/local/lib/perl5/5.8.3/PA-RISC2.0
/usr/local/lib/perl5/5.8.3
/usr/local/lib/perl5/site_perl/5.8.3/PA-RISC2.0
/usr/local/lib/perl5/site_perl/5.8.3
/usr/local/lib/perl5/site_perl
.


*****************************************************
# perl Makefile.PL
Multiple copies of Driver.xst found in: /usr/local/lib/perl5/5.8.3/PA-RISC2.0/auto/DBI /usr/local/lib/perl5/site_perl/5.8.3/PA-RISC2.0/auto/DBI at Makefile.PL line 36
Using DBI 1.40 (for perl 5.008003 on PA-RISC2.0) installed in /usr/local/lib/perl5/5.8.3/PA-RISC2.0/auto/DBI

Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
Especially if you have any problems.

The ORACLE_HOME environment variable must be set.
It must be set to hold the path to an Oracle installation directory
on this machine (or a machine with a compatible architecture).
See the README.clients file for more information.
ABORTED!

[root@bdhp4264:/home/aq1764/DBD-Oracle-1.14]
# echo $ORACLE_HOME
/opt/oracle/product/9.2.0.4


How can I get around this?

[ranganath ramachandra]

has the variable been exported ?

[H.Merijn Brand (procura]

If it can be echoed, it's exported enough.

What's your vesion of DBD::Oracle you want to install?

Enjoy, Have FUN! H.Merijn

[Fred Ruffet]

looking at your PATH, it should be DBD::Oracle 1.14 :)

Why this version ? There is now a more recent version.

Could you send output from
set | grep -e ORA -e NLS

Regards,

Fred

[ranganath ramachandra]

i'm assuming that the script really didnt find the variable set.

i could not get a shell script to access the value of a parent shell's variable that was not exported (i tried only sh & bash on hpux and linux) so here goes some blah-blah:
----
bash-2.01$ BLAH=blah
bash-2.01$ echo $BLAH
blah
bash-2.01$ cat /tmp/blah
echo $BLAH
bash-2.01$ sh -x /tmp/blah
+ echo

bash-2.01$ bash -x /tmp/blah
+ echo

bash-2.01$ sh
$ echo $BLAH

$ BLAH=blah
$ sh -x /tmp/blah
+ echo

$ bash -x /tmp/blah
+ echo

---

[H.Merijn Brand (procura]

# export ORACLE_HOME
# export ORACLE_SID

BUT, I can't imagine that Oracle would work at all when these are not exported.

That said, as Fred said, DBD::Oracle-1.15 is the most recent DBD-Oracle, and DBI-1.43 is newer than 1.40 (at the moment of writing. I expect DBD-Oracle-1.16 pretty soon)

Enjoy, Have FUN! H.merijn

[Tonya Underwood]

Very sorry for the late response...

[root@bdhp4264:/root]
# set | grep -e ORA -e NLS
ORACLE_HOME=/opt/oracle/product/9.2.0.4
ORACLE_SID=dummy101
_=ORACLE_HOME=/opt/oracle/product/9.2.0.4

[root@bdhp4264:/root]
#


I am going to try 1.15 and then we'll see what happens

[Tonya Underwood]

OK... on 1.15 I get through with no errors until make test.

Here is a snip... but I have attached the entire output as well...


PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base......./usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /usr/lib/libpthread.1
/usr/lib/dld.sl: Exec format error
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load '/home/aq1764/DBD-Oracle-1.15/blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec format error at /usr/local/lib/perl5/5.8.3/PA-RISC2.0/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/base.t line 19
The remaining tests will probably also fail with the same error.

[H.Merijn Brand (procura · Accepted solution]

Looks like an easy call, which is explained in Perl's README.hpux

If all is properly installed, check

# man perlhpux

and then

# perl -V:libs

If that does not have -lcl and -lpthread you're out of luck for Oracle, and you will have to get yourself another Perl binary

Enjoy, Have FUN! H.Merijn

[Tonya Underwood]

[root@bdhp4264:/home/aq1764/DBD-Oracle-1.15]
# perl -V:libs
libs='-lnsl -lnm -lndbm -lgdbm -ldb -lmalloc -ldld -lm';

[root@bdhp4264:/home/aq1764/DBD-Oracle-1.15]
#


You are right...

So, if new binary needed... you are speaking of new perl install correct? How can I be sure I will have these libs prior to install...

[H.Merijn Brand (procura]

Take my ports :)

My HP ITRC site pages can be found at (please use LA as primary choice):

USA Los Angeles http://mirrors.develooper.com/hpux/
SGP Singapore https://www.beepz.com/personal/merijn/
USA Chicago http://ww.hpux.ws/merijn/
NL Hoofddorp http://www.cmve.net/~merijn/

Enjoy, have FUN! H.Merijn

[Tonya Underwood]

THANKS!!!

[Tonya Underwood]

Procura.... I don't suppose you have 5.6.1 with those libs do you? Or must I go with 5.8.x?

[Tonya Underwood]

Extracted your perl version... perl 5.8.5... Do I need to do something else?

# ./perl/bin/perl -v
/usr/lib/pa20_64/dld.sl: Unable to find library 'libnm.sl'.
Killed

[root@bdhp4224:/var/opt/9IAS/iamslms]
#

[H.Merijn Brand (procura]

I /think/ you fetched yourself a 64bit perl, where the original question was about using perl with Oracle in a 32bit environment!

--8<---
Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration:
Platform:
osname=hpux, osvers=11.00, archname=PA-RISC2.0
uname='hp-ux ness b.11.00 a 9000780 2012209406 two-user license '
config_args='-d -e -Dcc=gcc -Dprefix=/usr/local useposix=true'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
-->8---

This is a gcc compiled perl for 32bit environment.

On HP-UX 32bit and 64bit do *not* mix. period.

Check your OS:
# uname -a

if it is 11.11 (11i), get yourself a 11.11 build. If it is 11.00, get yourself the 11.00 build

http://mirrors.develooper.com/hpux/perl-5.8.5-gcc-3.4.1-11.00-pa20.tbz

is what I think you want. And it is not unlikely you also want the matching GNU gcc compiler:

http://mirrors.develooper.com/hpux/gcc-3.4.1-32-11.00-hppa2.0.tbz

Those will not use /usr/lib/pa20_64/dld.sl
If they do, I made a huge error, which I will have to fix right away.

Enjoy, Have FUN! H.Merijn

[Tonya Underwood]

Yes... I accidentally misposted this... Very sorry.

Thanks.