Figured out the problem. Modified "Makefile" to include "-lCrun -lCstd". These shared object files contain definitions for the symbols that perl is trying to resolve at run time. The libraries that need to be included are /usr/lib/libCrun.so.1 and /usr/lib/libstd.so.i
Everytime worked after that. -----Original Message----- From: Mike Nhan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2008 2:40 PM To: Liu, Phillip Cc: "Tim...."@pobox.com; [email protected] Subject: Re: DBD::Oracle Hi, take a look at README.64bit.txt. You are building 32bit perl with 64bit oracle on 64bit solaris. You are going to have to point DBD-oracle at the 32bit libraries. The Readme has tips on how to do that. Regards, Michael On Wed, 30 Jul 2008, Liu, Phillip wrote: > Date: Wed, 30 Jul 2008 10:19:50 -0400 > From: "Liu, Phillip" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [email protected] > Subject: DBD::Oracle > > Dear Sir/Users, > > I am getting an error " relocation error: file > /opt/local/oracle32/lib/libocci.so.10.1: symbol > __1cDstdJbad_allocG__vtbl_: referenced symbol" when I run the "make > test" command. > > I was wondering if you could please help. > > Best Regards, > Phil > > > [CI ,prod, D_CI_ACE_TST] [936] perl Makefile.PL -m > $ORACLE_HOME/sdk/demo/demo.mk -h $ORACLE_HOME/sdk/include > > Multiple copies of Driver.xst found in: > /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/ > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI/ at > Makefile.PL line 35 Using DBI 1.607 (for perl 5.008005 on > sun4-solaris) installed in > /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/ > > Configuring DBD::Oracle for perl 5.008005 on solaris (sun4-solaris) > > Remember to actually *READ* the README file! Especially if you have > any problems. > > Using Oracle in /opt/local/oracle32 > DEFINE _SQLPLUS_RELEASE = "1002000200" (CHAR) Oracle version 10.2.0.2 > (10.2) Found /opt/local/oracle32/sdk/demo/demo.mk > Using /opt/local/oracle32/sdk/demo/demo.mk > Your LD_LIBRARY_PATH env var is set to > '/usr/lib/sparcv9:/usr/lib:.://opt/local/sybase/12.5.0/lib:/IW/CI/prod > /l > ib:/opt/SUNWspro/lib:/usr/openwin/lib:/usr/lib:/opt/local/oracle32/lib' > WARNING: Your LD_LIBRARY_PATH env var doesn't include > '/opt/local/oracle32/lib32' but probably needs to. > Reading /opt/local/oracle32/sdk/demo/demo.mk > Use of uninitialized value in substitution (s///) at Makefile.PL line > 1348. > Use of uninitialized value in substitution (s///) at Makefile.PL line > 1352. > Use of uninitialized value in substitution (s///) at Makefile.PL line > 1355. > Use of uninitialized value in substitution (s///) at Makefile.PL line > 1356. > Use of uninitialized value in substitution (s///) at Makefile.PL line > 1357. > WARNING: Oracle /opt/local/oracle32/sdk/demo/demo.mk doesn't define a > 'build' rule. > > WARNING: I will now try to guess how to build and link DBD::Oracle for > you. > This kind of guess work is very error prone and Oracle-version > sensitive. > It is possible that it won't be supported in future versions > of DBD::Oracle. > *PLEASE* notify dbi-users about exactly _why_ you had to build > it this way. > > Found header files in /opt/local/oracle32/sdk/include. > > Checking for functioning wait.ph > > > System: perl5.008005 sunos 5.9 generic sun4u sparc sunw,ultra-5_10 > solaris > Compiler: gcc -B/usr/ccs/bin/ -O -fno-strict-aliasing -pipe > -I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 > Linker: /usr/lib/ld > Sysliblist: > CC: /opt/SunProd/SUNWspro6.1/bin/CC > Linking with -L../../ -locci -lclntsh -lthread [from $(CCLIB)] > > > WARNING: If you have problems you may need to rebuild perl with > threading enabled. > Checking if your kit is complete... > Looks good > Warning: -L../../ changed to -L/tmp/oracle/DBD-Oracle-1.21/../../ > LD_RUN_PATH=/opt/local/oracle32/lib32 > Using DBD::Oracle 1.21. > Using DBD::Oracle 1.21. > Multiple copies of Driver.xst found in: > /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/ > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI/ at > Makefile.PL line 1658 Using DBI 1.607 (for perl 5.008005 on > sun4-solaris) installed in > /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/ > Writing Makefile for DBD::Oracle > > *** If you have problems... > read all the log printed above, and the README and README.help.txt > files. > (Of course, you have read README by now anyway, haven't you?) > > $ pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [937] make > cp Oracle.pm blib/lib/DBD/Oracle.pm > cp mkta.pl blib/lib/DBD/mkta.pl > cp oraperl.ph blib/lib/oraperl.ph > cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h > cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h > cp Oraperl.pm blib/lib/Oraperl.pm > cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h > cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm cp lib/DBD/Oracle/GetInfo.pm > blib/lib/DBD/Oracle/GetInfo.pm /usr/bin/perl -p -e > "s/~DRIVER~/Oracle/g" > /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/Driver.xst > > Oracle.xsi /usr/bin/perl /usr/local/lib/perl5/5.8.5/ExtUtils/xsubpp > -typemap /usr/local/lib/perl5/5.8.5/ExtUtils/typemap -typemap typemap > Oracle.xs >> Oracle.xsc && mv Oracle.xsc Oracle.c > gcc -B/usr/ccs/bin/ -c -I/opt/local/oracle32/sdk/include > -I/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI > -fno-strict-aliasing -pipe -I/usr/local/include -I/opt/gnu/include > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" > -DXS_VERSION=\"1.21\" -fPIC > "-I/usr/local/lib/perl5/5.8.5/sun4-solaris/CORE" -Wall -Wno-comment > -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" Oracle.c > gcc -B/usr/ccs/bin/ -c -I/opt/local/oracle32/sdk/include > -I/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI > -fno-strict-aliasing -pipe -I/usr/local/include -I/opt/gnu/include > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" > -DXS_VERSION=\"1.21\" -fPIC > "-I/usr/local/lib/perl5/5.8.5/sun4-solaris/CORE" -Wall -Wno-comment > -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" dbdimp.c > dbdimp.c: In function `ora_st_execute_array': > dbdimp.c:3269: warning: unused variable `sv2' > gcc -B/usr/ccs/bin/ -c -I/opt/local/oracle32/sdk/include > -I/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI > -fno-strict-aliasing -pipe -I/usr/local/include -I/opt/gnu/include > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.21\" > -DXS_VERSION=\"1.21\" -fPIC > "-I/usr/local/lib/perl5/5.8.5/sun4-solaris/CORE" -Wall -Wno-comment > -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" oci8.c > Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f > blib/arch/auto/DBD/Oracle/Oracle.so > LD_RUN_PATH="/opt/local/oracle32/lib32" gcc -B/usr/ccs/bin/ -G > -L/usr/local/lib -L/opt/gnu/lib Oracle.o dbdimp.o oci8.o -o > blib/arch/auto/DBD/Oracle/Oracle.so -L/opt/local/oracle32/lib32 > -L/tmp/oracle/DBD-Oracle-1.21/../.. -locci -lclntsh -lthread > ld: fatal: library -locci: not found > ld: fatal: library -lclntsh: not found > ld: fatal: File processing errors. No output written to > blib/arch/auto/DBD/Oracle/Oracle.so > collect2: ld returned 1 exit status > *** Error code 1 > make: Fatal error: Command failed for target > `blib/arch/auto/DBD/Oracle/Oracle.so' > $ pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [938] > > $ pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [938] ln -s > /opt/local/oracle32/lib/libclntsh.so.10.1 libclntsh.so ln -s > /opt/local/oracle32/lib/libocci.so.10.1 libocci.so make $ > pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [939] ln -s > /opt/local/oracle32/lib/libocci.so.10.1 libocci.so $ > pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [940] make > rm -f blib/arch/auto/DBD/Oracle/Oracle.so > LD_RUN_PATH="/opt/local/oracle32/lib32" gcc -B/usr/ccs/bin/ -G > -L/usr/local/lib -L/opt/gnu/lib Oracle.o dbdimp.o oci8.o -o > blib/arch/auto/DBD/Oracle/Oracle.so -L/opt/local/oracle32/lib32 > -L/tmp/oracle/DBD-Oracle-1.21/../.. -locci -lclntsh -lthread 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 > /usr/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 /usr/bin/perl "-MExtUtils::MY" > -e "MY->fixin(shift)" > blib/script/ora_explain > Manifying blib/man1/ora_explain.1 > Manifying blib/man3/DBD::Oracle.3 > Manifying blib/man3/DBD::Oraperl.3 > $ pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [941] find . -name "*.so" > ./blib/arch/auto/DBD/Oracle/Oracle.so > ./libclntsh.so > ./libocci.so > $ pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [942] ls -alt > ./blib/arch/auto/DBD/Oracle/Oracle.so > -rwxr-xr-x 1 pliu iwdev 218884 Jul 30 10:09 > ./blib/arch/auto/DBD/Oracle/Oracle.so > $ pliudevel:/tmp/oracle/DBD-Oracle-1.21 > [CI ,prod, D_CI_ACE_TST] [943] make test > > PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" > "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t > t/01base................Failed to load Oracle extension and/or shared > libraries: > install_driver(Oracle) failed: Can't load > '/tmp/oracle/DBD-Oracle-1.21/blib/arch/auto/DBD/Oracle/Oracle.so' for > module DBD::Oracle: ld.so.1: perl: fatal: relocation error: file > /opt/local/oracle32/lib/libocci.so.10.1: symbol > __1cDstdJbad_allocG__vtbl_: referenced symbol not found at > /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230. > at (eval 3) line 3 > Compilation failed in require at (eval 3) line 3. > Perhaps a required shared library or dll isn't installed where > expected at t/01base.t line 19 The remaining tests will probably also > fail with the same error. > > *** Please read the README and README.help.txt files for help. *** > > t/01base................FAILED tests 4-5 > > Failed 2/5 tests, 60.00% okay > t/10general.............install_driver(Oracle) failed: Can't load > '/tmp/oracle/DBD-Oracle-1.21/blib/arch/auto/DBD/Oracle/Oracle.so' for > module DBD::Oracle: ld.so.1: perl: fatal: relocation error: file > /opt/local/oracle32/lib/libocci.so.10.1: symbol > __1cDstdJbad_allocG__vtbl_: referenced symbol not found at > /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230. > at (eval 3) line 3 > Compilation failed in require at (eval 3) line 3. > Perhaps a required shared library or dll isn't installed where > expected at /tmp/oracle/DBD-Oracle-1.21/blib/lib/Oraperl.pm line 55 > Compilation failed in require at t/10general.t line 6. > BEGIN failed--compilation aborted at t/10general.t line 6. > # Looks like your test died before it could output anything. > t/10general.............dubious > > Test returned status 255 (wstat 65280, 0xff00) > t/12impdata.............Can't load > '/tmp/oracle/DBD-Oracle-1.21/blib/arch/auto/DBD/Oracle/Oracle.so' for > module DBD::Oracle: ld.so.1: perl: fatal: relocation error: file > /opt/local/oracle32/lib/libocci.so.10.1: symbol > __1cDstdJbad_allocG__vtbl_: referenced symbol not found at > /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230. > at t/nchar_test_lib.pl line 6 > Compilation failed in require at t/nchar_test_lib.pl line 6. > BEGIN failed--compilation aborted at t/nchar_test_lib.pl line 6. > Compilation failed in require at t/12impdata.t line 26. > # Looks like your test died before it could output anything. > t/12impdata.............dubious > > Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED > tests 1-7 > Failed 7/7 tests, 0.00% okay > t/14threads.............skipped > all skipped: this solaris perl 5.008005 not configured to > support iThreads t/15nls.................Can't load > '/tmp/oracle/DBD-Oracle-1.21/blib/arch/auto/DBD/Oracle/Oracle.so' for > module DBD::Oracle: ld.so.1: perl: fatal: relocation error: file > /opt/local/oracle32/lib/libocci.so.10.1: symbol > __1cDstdJbad_allocG__vtbl_: referenced symbol not found at > /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230. > at t/nchar_test_lib.pl line 6 > Compilation failed in require at t/nchar_test_lib.pl line 6. > BEGIN failed--compilation aborted at t/nchar_test_lib.pl line 6. > Compilation failed in require at t/15nls.t line 9. > # Looks like your test died before it could output anything. > t/15nls.................dubious > > Test returned status 255 (wstat 65280, 0xff00) > ###################################################################### > ############# This communication is confidential and may be > privileged. If you received it in error, please destroy without > copying and advise the sender. > > By submitting personal information to CI Investments, you agree to the > collection, use and disclosure of such personal information for the > purposes described in our Privacy Policy available at www.ci.com. > > > Cette communication est confidentielle et pourrait être privilégiée. > Si vous la recevez par erreur, veuillez l'éliminer sans en faire une > copie et aviser l'expéditeur. > > Lorsque vous soumettez des renseignements personnels à Placements CI, > vous nous permettez de conserver, utiliser et divulguer ces > renseignements personnels aux fins décrites dans nos Principes > directeurs en matière de protection des renseignements personnels qui > sont disponibles au www.ci.com. > > ################################################################ > > -- ---//--- Time flies like the wind. Fruit flies like bananas. --- Groucho Marx Either write something worth reading or do something worth writing. --- Benjamin Franklin ################################################################################### This communication is confidential and may be privileged. If you received it in error, please destroy without copying and advise the sender. By submitting personal information to CI Investments, you agree to the collection, use and disclosure of such personal information for the purposes described in our Privacy Policy available at www.ci.com. Cette communication est confidentielle et pourrait être privilégiée. Si vous la recevez par erreur, veuillez l'éliminer sans en faire une copie et aviser l'expéditeur. Lorsque vous soumettez des renseignements personnels à Placements CI, vous nous permettez de conserver, utiliser et divulguer ces renseignements personnels aux fins décrites dans nos Principes directeurs en matière de protection des renseignements personnels qui sont disponibles au www.ci.com. ################################################################
