Re: DBD error

[email protected] (Christopher Jones) Mon, 20 Jul 2020 09:37:52 +1000
Newsgroups perl.dbi.users
Message-ID <[email protected]>
On 17/7/20 10:02 pm, Bala GANESH wrote:
> Hi Support,

"Support" ? :)

> I am receiving following error while installing DBD Perl module on IBM AIX 7.1 .Please help me to solve this.. bash-3.2# perl Makefile.PL
> ***************************************************************************************************************************************** ld: 
> 0711-736 ERROR: Input file /oracle/product/11.2.0.4/lib/libclntsh.so 
> <https://urldefense.com/v3/__http://11.2.0.4/lib/libclntsh.so__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXh-SIBnPA$>: 
>         XCOFF64 object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. 
> ***************************************************************************************************************************************** 
> pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export ORACLE_HOME=/oracle/product/19.7/ 
> pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export LD_LIBRARY_PATH=/oracle/product/19.7/lib 
> pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# perl Makefile.PL Using DBI 1.643 (for perl 5.028001 on aix-thread-multi) installed in 
> /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/ Configuring DBD::Oracle for perl 5.028001 on aix (aix-thread-multi) If you encounter 
> any problem, a collection of troubleshooting guides are available under lib/DBD/Oracle/Troubleshooting. 'DBD::Oracle::Troubleshooting' is the 
> general troubleshooting guide, while platform-specific troubleshooting hints live in their labelled sub-document (e.g., Win32 hints are gathered in 
> 'lib/DBD/Oracle/Troubleshooting/Win32.pod'). Installing on a aix, Ver#7.1 Using Oracle in /oracle/product/19.7 DEFINE _SQLPLUS_RELEASE = 
> "1907000000" (CHAR) Oracle Version 19.7.0.0 (19.7) Found direct-link candidates: libclntsh.a libclntsh.so Oracle sysliblist: /lib/crt0_64.o -ldl -lc 
> -lm -lpthreads -lodm -lbsd_r -lld -lperfstat Found header files in /oracle/product/19.7/rdbms/public. Your LIBPATH env var is set to '' WARNING: 
> Your LIBPATH env var doesn't include '/oracle/product/19.7/lib' but probably needs to.

Did you try setting LIBPATH instead of LD_LIBRARY_PATH? https://www.ibm.com/support/pages/libpath-environment-variables-aix-platforms

Chris


> client_version=19.7 DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\"19.7.0.0\" -DORA_OCI_102 -DORA_OCI_112 Checking for functioning wait.ph 
> <https://urldefense.com/v3/__http://wait.ph__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXjwPaqgsA$> System: 
> perl5.028001 aix fvt-p7a2-lp2 1 7 0000668a7a00 Compiler:   xlc_r -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias 
> -qlanglvl=extc99 -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES Linker:     /usr/bin/ld Sysliblist: /lib/crt0_64.o -ldl -lc -lm 
> -lpthreads -lodm -lbsd_r -lld -lperfstat Linking with -lclntsh. Unrecognized argument in LIBS ignored: '/lib/crt0_64.o' 
> LD_RUN_PATH=/oracle/product/19.7/lib:/oracle/product/19.7/rdbms/lib Using DBD::Oracle 1.80. Using DBD::Oracle 1.80. Using DBI 1.643 (for perl 
> 5.028001 on aix-thread-multi) installed in /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/ Generating a Unix-style Makefile Writing 
> Makefile for DBD::Oracle Writing MYMETA.yml and MYMETA.json pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# make Skip 
> blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip 
> blib/lib/DBD/Oracle/Troubleshooting/Linux.pod (unchanged) cp mk.pm 
> <https://urldefense.com/v3/__http://mk.pm__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXhp-fS83g$> 
> blib/arch/auto/DBD/Oracle/mk.pm 
> <https://urldefense.com/v3/__http://mk.pm__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXhp-fS83g$> Skip 
> blib/lib/DBD/Oracle/Troubleshooting/Sun.pod (unchanged) Skip blib/lib/DBD/Oracle/Troubleshooting/Aix.pod (unchanged) Skip 
> blib/lib/DBD/Oracle/Troubleshooting/Vms.pod (unchanged) Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) Skip 
> blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod (unchanged) Skip blib/lib/DBD/Oracle/Troubleshooting/Cygwin.pod (unchanged) Skip 
> blib/lib/DBD/Oracle/Troubleshooting/Win32.pod (unchanged) Skip blib/lib/DBD/Oracle/Troubleshooting/Macos.pod (unchanged) Skip 
> blib/lib/DBD/Oracle/Troubleshooting.pod (unchanged) Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/lib/DBD/Oracle/Object.pm (unchanged) Skip 
> blib/lib/DBD/Oracle/Troubleshooting/Win64.pod (unchanged) Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) Running Mkbootstrap for Oracle ()   
>       chmod 644 "Oracle.bs"          "/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs 644   
>       xlc_r -c  -I/oracle/product/19.7/rdbms/public -I/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI  -D_ALL_SOURCE -D_ANSI_C_SOURCE 
> -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -qlanglvl=extc99 -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -O    -DVERSION=\"1.80\" 
>  -DXS_VERSION=\"1.80\"  "-I/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE"  -DUTF8_SUPPORT -DORA_OCI_VERSION=\"19.7.0.0\" -DORA_OCI_102 
> -DORA_OCI_112 Oracle.c         xlc_r -c  -I/oracle/product/19.7/rdbms/public -I/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI 
>  -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -qlanglvl=extc99 -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 
> -D_LARGE_FILES -O    -DVERSION=\"1.80\"  -DXS_VERSION=\"1.80\"  "-I/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE"  -DUTF8_SUPPORT 
> -DORA_OCI_VERSION=\"19.7.0.0\" -DORA_OCI_102 -DORA_OCI_112 dbdimp.c         xlc_r -c  -I/oracle/product/19.7/rdbms/public 
> -I/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI  -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias 
> -qlanglvl=extc99 -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -O    -DVERSION=\"1.80\"  -DXS_VERSION=\"1.80\" 
>  "-I/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE"  -DUTF8_SUPPORT -DORA_OCI_VERSION=\"19.7.0.0\" -DORA_OCI_102 -DORA_OCI_112 oci8.c "oci8.c", 
> line 18.9: 1506-236 (W) Macro name sv_set_undef has been redefined. "oci8.c", line 18.9: 1506-358 (I) "sv_set_undef" is defined on line 809 of 
> /usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE/embed.h.         rm -f blib/arch/auto/DBD/Oracle/Oracle.so         
> LD_RUN_PATH="/oracle/product/19.7/lib:/oracle/product/19.7/rdbms/lib" ld  -bhalt:4 -G -bI:/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE/perl.exp 
>  -bnoentry -lpthreads -lc -lm -bE:Oracle.exp Oracle.o  dbdimp.o  oci8.o  -o blib/arch/auto/DBD/Oracle/Oracle.so    -L/oracle/product/19.7/lib 
> -lclntsh -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lperfstat ld: 0711-736 ERROR: Input file /oracle/product/19.7/lib/libclntsh.so:         XCOFF64 
> object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. Stop. 
> pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# make install          "/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- 
> Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs 644         rm -f blib/arch/auto/DBD/Oracle/Oracle.so         
> LD_RUN_PATH="/oracle/product/19.7/lib:/oracle/product/19.7/rdbms/lib" ld  -bhalt:4 -G -bI:/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE/perl.exp 
>  -bnoentry -lpthreads -lc -lm -bE:Oracle.exp Oracle.o  dbdimp.o  oci8.o  -o blib/arch/auto/DBD/Oracle/Oracle.so    -L/oracle/product/19.7/lib 
> -lclntsh -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lperfstat ld: 0711-736 ERROR: Input file /oracle/product/19.7/lib/libclntsh.so:         XCOFF64 
> object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. Stop.
>
> -- 
>
> Balaganesh Murugan
>
> GCP Architect
>
> M : +32 466259604
>
> [email protected] <mailto:[email protected]>
>
>
> Carrefour België 
> <https://urldefense.com/v3/__https://maps.google.com/?q=Belgi**B0D*0A**A0D*0AOlympiadenlaan*20&entry=gmail&source=g__;w6slJSslJSs!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXhMdiBhuw$>
>
> Olympiadenlaan 20 
> <https://urldefense.com/v3/__https://maps.google.com/?q=Belgi**B0D*0A**A0D*0AOlympiadenlaan*20&entry=gmail&source=g__;w6slJSslJSs!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXhMdiBhuw$>
>
> BE-1140 Brussel
>
>
> This e-mail and any attachment are confidential and intended solely for the use of the individual to whom it is addressed. If you are not the 
> intended recipient, please telephone or email the sender and delete this message and any attachment from your system. Unauthorized publication, use, 
> dissemination, forwarding, printing or copying of this e-mail and its associated attachments is strictly prohibited.
>
> http://disclaimer.carrefour.com/ 
> <https://urldefense.com/v3/__http://disclaimer.carrefour.com/__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXimeCFrLg$>
>
> Let's respect the environment together. Only print this message if necessary.

-- 
https://twitter.com/ghrd