Hi Bala,
I’d show this to my sys admin, looks like there are missing libraries on your system. Cheers !!!! From: Bala GANESH <bala_gan...@carrefour.com> Sent: Tuesday, July 21, 2020 3:18 AM To: Kevin Moore <kmo...@esntech.com> Cc: Christopher Jones <christopher.jo...@oracle.com>; dbi-users@perl.org Subject: Re: DBD error HI Kevin, While DB:Oracle , am facing below error , based on your availability tell me the free time , am ready to share my screen [root@vm-postgresql DBD-Oracle-1.75_2]# make "/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 gcc -lpthread -shared -Wl,-z,relro -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -L/usr/local/lib -fstack-protector-strong Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \ -L/opt/oracle/product/12.1.0/client_1/lib -lclntsh -ldl -lm -lpthread -lnsl -lirc -limf -lirc -lrt -laio -lresolv -lsvml -lperl \ /usr/bin/ld: cannot find -lnsl /usr/bin/ld: cannot find -laio collect2: error: ld returned 1 exit status make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so] Error 1 On Mon, Jul 20, 2020 at 7:35 PM Kevin Moore <kmo...@esntech.com <mailto:kmo...@esntech.com> > wrote: If you’re using an 11.2.0.4 client and that versions libraries, you may want to upgrade the client to something more current because I’m not sure this client is supported by Oracle. Here is what was posted that makes me believe that way: 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$> : From: Christopher Jones <christopher.jo...@oracle.com <mailto:christopher.jo...@oracle.com> > Sent: Sunday, July 19, 2020 4:38 PM To: dbi-users@perl.org <mailto:dbi-users@perl.org> ; bala_gan...@carrefour.com <mailto:bala_gan...@carrefour.com> Subject: Re: DBD error 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 <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_pages_libpath-2Denvironment-2Dvariables-2Daix-2Dplatforms&d=DwMFaQ&c=oYSInPoxeTs4m10ilnGu9Q&r=epNtSOT0Nv3ejsgXp-J4jOmfo8HlYyawp_IXKa881cY&m=6ifBm5aRmkE9Ys1nxaSfQ_qUlmJZ7osJjwXqYzzV2Fo&s=eahDz0l4E-ozVHu3LelqHyh6OVOY6waGt9afuyWYQ2g&e=> 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 bala_ganesh <mailto:jan_vanoeke...@carrefour.com> @carrefour.com <https://lh4.googleusercontent.com/B4hl7g3kRl83N3fpc9S6R6wxwBeg0K_PmBE1Am1j8p384piX66ACxmfcf3msLZCM2LmB8c8_DYIdas0Xw0uWgG2fYMZ74kZTAwM5Gi-FAxt0BzXcKlDp-YjCUNuS2rwrvLhOqGOR> Carrefour <https://urldefense.com/v3/__https:/maps.google.com/?q=Belgi**B0D*0A**A0D*0AOlympiadenlaan*20&entry=gmail&source=g__;w6slJSslJSs!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXhMdiBhuw$> 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 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 <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ghrd&d=DwMFaQ&c=oYSInPoxeTs4m10ilnGu9Q&r=epNtSOT0Nv3ejsgXp-J4jOmfo8HlYyawp_IXKa881cY&m=6ifBm5aRmkE9Ys1nxaSfQ_qUlmJZ7osJjwXqYzzV2Fo&s=GrTim4qn6f3DnGbr0pDpfPmx3aT7sG4unfmM1SuzxYg&e=> -- Balaganesh Murugan GCP Architect M : +32 466259604 bala_ganesh <mailto:jan_vanoeke...@carrefour.com> @carrefour.com <https://lh4.googleusercontent.com/B4hl7g3kRl83N3fpc9S6R6wxwBeg0K_PmBE1Am1j8p384piX66ACxmfcf3msLZCM2LmB8c8_DYIdas0Xw0uWgG2fYMZ74kZTAwM5Gi-FAxt0BzXcKlDp-YjCUNuS2rwrvLhOqGOR> Carrefour <https://maps.google.com/?q=Belgi%C3%AB%0D%0A+%0D%0AOlympiadenlaan+20&entry=gmail&source=g> België <https://maps.google.com/?q=Belgi%C3%AB%0D%0A+%0D%0AOlympiadenlaan+20&entry=gmail&source=g> Olympiadenlaan 20 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/ Let's respect the environment together. Only print this message if necessary.