topic DBD::Oracle issues in Operating System - Linux

DBD::Oracle issues

MauriceConway — Fri, 02 Jun 2006 18:11:01 GMT

Im trying to compile DBD::Oracle on an hpux 11.23 Itanium system. Perl is 64bit, Oracle is 64bit. I complete "perl Makefile.PL" just fine, but when I run "make", I get this error;

***********************************************
LD_RUN_PATH="/app/common/oracle/product/10.1.0.4
/lib:/app/common/oracle/product/10.1.0.4/rdbms/lib" /usr/bin/ld -b -L/usr/local/lib -L/usr/lib/hpux64 Oracle.o dbdimp.o oci7.o oci8.o -Wl,+s -Wl,+n +DD64 -o build -L/app/common/oracle/product/10.1.0.4/rdbms/lib/ -L/app/common/oracle/product/10.1.0.4/lib/ -lclntsh -lnbeq10 -lnhost10 -lnus10 -lnldap10 -lldapclnt10 -lnsslb10 -lnoname10 -lntcp10 -lntcps10 -lnsslb10 -lntcp10 -lntns10 -l:librt.so -l:libnss_dns.so.1 -l:libdld.so -lm -lpthread -lunwind -lm -o blib/arch/auto/DBD/Oracle/Oracle.so
ld: Unrecognized argument: -Wl,+s
Fatal error.
make: *** [blib/arch/auto/DBD/Oracle/Oracle.so] Error 1

***********************************************

I've checked google, and cant really find much thats is specific to my scenerio. there is lots of info out there, but nothing that seems to fit my situcation.

any suggestions?

Thank you.

Re: DBD::Oracle issues

Dennis Handly — Fri, 02 Jun 2006 21:05:35 GMT

>/usr/bin/ld -b -L/usr/local/lib -L/usr/lib/hpux64 Oracle.o dbdimp.o oci7.o oci8.o -Wl,+s -Wl,+n
ld: Unrecognized argument: -Wl,+s

You are confusing compiler driver options with linker options. If you invoke ld directly, not recommended, you don't use the "-Wl," prefix.

Re: DBD::Oracle issues

melvyn burnard — Sat, 03 Jun 2006 15:22:33 GMT

duplicate threads removed as requested

Re: DBD::Oracle issues

H.Merijn Brand (procura — Sun, 04 Jun 2006 03:33:45 GMT

x1:/tmp 110 > cc +DD64 -c malloc_sizer.c
x1:/tmp 111 > ld +DD64 -Wl,+s malloc_sizer.o
ld: Unrecognized argument: +DD64
Fatal error.
Exit 1
x1:/tmp 112 > ld -Wl,+s malloc_sizer.o
ld: Unrecognized argument: -Wl,+s
Fatal error.
Exit 1
x1:/tmp 113 > ld +s malloc_sizer.o -lc
x1:/tmp 114 >

Guess that indeed might be Itanium specific.
I'll have a look at the README's
For now, tweak the Makefile so the 'ld' does not get those options or run that ld command from the command line and continue your regular process.

Enjoy, Have FUN! H.Merijn

Re: DBD::Oracle issues

MauriceConway — Mon, 05 Jun 2006 10:44:57 GMT

Thanks for looking into this for me Procura, thank you for the feedback Dennis, and thank you for cleaning up my multiple posts Melvyn. :)

Im looking at the Makefile now to see if I can find where those flags are being set. Hopefully I can adjust them there.

Re: DBD::Oracle issues

MauriceConway — Mon, 05 Jun 2006 11:03:02 GMT

Good morning again.

Ok, I have had time to play with the ld parameters.

I started by removing the "-Wl +s" and re-ran make. It blew up saying "-Wl +n" was unrecognized, just like the first. So I went and removed those flags. Re-ran make and it failed with "+DD64" unrecognized command. So I removed those flags. I re-ran make and here is the output, it doesnâ t look like it failed, so maybe I am past this hurdle.

Going to try and compile a few more modules so the DBA's can test DBD.

***********************************************
=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2006.06.05 08:57:58 =~=~=~=~=~=~=~=~=~=~=~=
make
gcc -c -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/oracle/product/10.1.0.4/plsql/public -I/app/common/oracle/product/10.1.0.4/network/public -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/site_perl/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -mlp64 -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -fPIC "-I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT Oracle.c
gcc -c -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/oracle/product/10.1.0.4/plsql/public -I/app/common/oracle/product/10.1.0.4/network/public -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/site_perl/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -mlp64 -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -fPIC "-I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT dbdimp.c
gcc -c -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/oracle/product/10.1.0.4/plsql/public -I/app/common/oracle/product/10.1.0.4/network/public -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/site_perl/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -mlp64 -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -fPIC "-I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT oci7.c
gcc -c -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/oracle/product/10.1.0.4/plsql/public -I/app/common/oracle/product/10.1.0.4/network/public -I/app/common/oracle/product/10.1.0.4/rdbms/demo -I/app/common/oracle/product/10.1.0.4/rdbms/public -I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/site_perl/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/auto/DBI/ -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -mlp64 -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -fPIC "-I/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/IA64.ARCHREV_0-thread-multi-LP64/CORE" -DUTF8_SUPPORT oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/app/common/oracle/product/10.1.0.4/lib:/app/common/oracle/product/10.1.0.4/rdbms/lib" /usr/bin/ld -b -L/usr/local/lib -L/usr/lib/hpux64 Oracle.o dbdimp.o oci7.o oci8.o -o build -L/app/common/oracle/product/10.1.0.4/rdbms/lib/ -L/app/common/oracle/product/10.1.0.4/lib/ -lclntsh -lnbeq10 -lnhost10 -lnus10 -lnldap10 -lldapclnt10 -lnsslb10 -lnoname10 -lntcp10 -lntcps10 -lnsslb10 -lntcp10 -lntns10 -l:librt.so -l:libnss_dns.so.1 -l:libdld.so -lm -lpthread -lunwind -lm -o blib/arch/auto/DBD/Oracle/Oracle.so
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/app/common/home/mnmiller/sandbox/perl-5.8.0_build/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/app/common/home/mnmiller/sandbox/perl-5.8.0_build/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
ml052-mnmiller>
***********************************************

Re: DBD::Oracle issues

MauriceConway — Mon, 05 Jun 2006 13:41:59 GMT

ok, I re-did some things to try and get this to make.

I am doing the make as myself, not root.

I set the following veriables:
ORACLE_SID
ORACLE_HOME
ORACLE_USERID
SHLIB_PATH
LD_LIBRARY_PATH

Using Perl 5.8.0 which I compiled myself

Using DBI which I compiled myself

The "make test" is still failing, Im looking through the DBD_README_hpux for any hints to the problem now.

Here is the new "make test" output;

*********************************************
ml052-mnmiller> make test
PERL_DL_NONLAZY=1 /app/common/home/mnmiller/sandbox/perl-5.8.0_build/bin/perl "-MExtUtils::Command::MM" "-e"

"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base......./usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for module

DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at (eval 2) line 3
Compilation failed in require at (eval 2) 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.

*** Please read the README and README.help files for help. ***

t/base.......FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/cursor...../usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
Can't load '/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for

module DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at t/cursor.t line 18
Compilation failed in require at t/cursor.t line 18.
BEGIN failed--compilation aborted at t/cursor.t line 18.
t/cursor.....dubious
Test returned status 255 (wstat 65280, 0xff00)
t/general..../usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
install_driver(Oracle) failed: Can't load

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for module

DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/general.t line 20
t/general....dubious
Test returned status 255 (wstat 65280, 0xff00)
t/long......./usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
Can't load '/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for

module DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at t/long.t line 4
Compilation failed in require at t/long.t line 4.
BEGIN failed--compilation aborted at t/long.t line 4.
t/long.......dubious
Test returned status 255 (wstat 65280, 0xff00)
t/meta......./usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
install_driver(Oracle) failed: Can't load

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for module

DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/meta.t line 23
t/meta.......dubious
Test returned status 255 (wstat 65280, 0xff00)
t/ph_type..../usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
Can't load '/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for

module DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at t/ph_type.t line 18
Compilation failed in require at t/ph_type.t line 18.
BEGIN failed--compilation aborted at t/ph_type.t line 18.
t/ph_type....dubious
Test returned status 255 (wstat 65280, 0xff00)
t/plsql....../usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
Can't load '/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for

module DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at t/plsql.t line 17
Compilation failed in require at t/plsql.t line 17.
BEGIN failed--compilation aborted at t/plsql.t line 17.
t/plsql......dubious
Test returned status 255 (wstat 65280, 0xff00)
t/reauth.....skipped
all skipped: no reason given
t/select...../usr/lib/hpux64/dld.so: Unsatisfied code symbol '__divsi3' in load module

'/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so'.
Can't load '/app/common/home/mnmiller/downloads/modules/DBD-Oracle-1.14/
blib/arch/auto/DBD/Oracle/Oracle.so' for

module DBD::Oracle: Unresolved external at

/app/common/home/mnmiller/sandbox/perl-5.8.0_build/lib/5.8.0/
IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line

229.
at t/select.t line 4
Compilation failed in require at t/select.t line 4.
BEGIN failed--compilation aborted at t/select.t line 4.
t/select.....dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------
t/base.t 5 2 40.00% 4-5
t/cursor.t 255 65280 ?? ?? % ??
t/general.t 255 65280 ?? ?? % ??
t/long.t 255 65280 ?? ?? % ??
t/meta.t 255 65280 ?? ?? % ??
t/ph_type.t 255 65280 ?? ?? % ??
t/plsql.t 255 65280 ?? ?? % ??
t/select.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 8/9 test scripts, 11.11% okay. 2/5 subtests failed, 60.00% okay.
make: *** [test_dynamic] Error 2
ml052-mnmiller>
*********************************************