Hi, We installed perl 5.8 & DBI & DBD using the same platform u mentioned. AIX 5.2 Oracle 9.2.0.2 perl v5.8.3 DBI 1.41 DBD-Oracle 1.15
But we never succeeded using "gcc". Try to install everything (perl & DBI & DBD ) using xlc_r. You can find xlc_r trial versions...then u can buy the original if u r interested -Sudhahar -----Original Message----- From: Vonnahme, Nathan [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 11:26 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: make fails with "ld: cannot open libgcc.a" for DBD::Oracle on AIX 5.1, gcc Hi, I'm trying to get DBD::Oracle to compile using AIX 5.1 Oracle 8.1.7.4 gcc 2.9-aix51-020209 perl v5.8.3 DBI 1.41 I compiled this perl and DBI with gcc just fine. Other CPAN modules compile OK with gcc. We don't have xlc or cc compilers; is this even possible? I've tried setting the LIB/LIBHOME/LIBPATH env vars to where libgcc.a lives, and I've tried including that path in Oracle's sysliblist file. I suspected make was using AIX's ld so I symlinked ld to gld (GNU ld) but I get the same error either way. Help? Here's the output of perl Makefile.PL && make: 08:56:09 /tmp/cpan/build/DBD-Oracle-1.15 # root:@fai02020 # perl Makefile.PL Using DBI 1.41 (for perl 5.008003 on aix) installed in /usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/oracle/product/8.1.7.4 Oracle version 8.1.7.0.0 (8.107) Found /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Found /u01/oracle/product/8.1.7.4/otrace/demo/atmoci.mk Using /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk Reading /u01/oracle/product/8.1.7.4/rdbms/lib/env_rdbms.mk Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Attempting to discover Oracle OCI build rules gcc -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c by executing: [make -f /u01/oracle/product/8.1.7.4/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o] Oracle oci build command: [-L/u01/oracle/product/8.1.7.4/lib/ -L/u01/oracle/product/8.1.7.4/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o /u01/oracle/product/8.1.7.4/rdbms/lib/kpudfo.o /u01/oracle/product/8.1.7.4/lib/nautab.o /u01/oracle/product/8.1.7.4/lib/naeet.o /u01/oracle/product/8.1.7.4/lib/naect.o /u01/oracle/product/8.1.7.4/lib/naedhs.o -lclntsh /u01/oracle/product/8.1.7.4/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lld -lm /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld -lm -bI:/u01/oracle/product/8.1.7.4/lib/pw-syscall.exp -bI:/u01/oracle/product/8.1.7.4/lib/ksms.imp -lpthreads] Found header files in rdbms/public rdbms/demo. Checking for functioning wait.ph System: perl5.008003 aix fai02020 1 5 000470bf4c00 Compiler: gcc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -D_LARGE_FILES Linker: /opt/freeware/GNUPro/bin/ld Sysliblist: /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld Oracle makefiles would have used these definitions but we override them: CC: $(ORACLE_HOME)/bin/oraxlc $(ORAXLCFLAGS) CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -O3 $(CDEBUG) $(QACCFLAGS) -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/plsql/public -I/u01/oracle/product/8.1.7.4/network/public $(SPFLAGS) $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -L$(LIBHOME) -L$(RDBMSLIB) [-L$(LIBHOME) -L/u01/oracle/product/8.1.7.4/rdbms/lib/] Linking with OTHERLDFLAGS = -L/u01/oracle/product/8.1.7.4/lib/ -L/u01/oracle/product/8.1.7.4/rdbms/lib/ /u01/oracle/product/8.1.7.4/rdbms/lib/kpudfo.o /u01/oracle/product/8.1.7.4/lib/nautab.o /u01/oracle/product/8.1.7.4/lib/naeet.o /u01/oracle/product/8.1.7.4/lib/naect.o /u01/oracle/product/8.1.7.4/lib/naedhs.o -lclntsh /u01/oracle/product/8.1.7.4/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lld -lm /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld -lm -bI:/u01/oracle/product/8.1.7.4/lib/pw-syscall.exp -bI:/u01/oracle/product/8.1.7.4/lib/ksms.imp -lpthreads [from 'build' rule] Warning: You will may need to rebuild perl using the xlc_r compiler. You may also need do: ORACCENV='cc=xlc_r'; export ORACCENV Also see the README about the -p option Warning: If you have problems you may need to rebuild perl with threading enabled. Checking if your kit is complete... Looks good LD_RUN_PATH=/u01/oracle/product/8.1.7.4/lib:/u01/oracle/product/8.1.7.4/ rdbms/lib Using DBD::Oracle 1.15. Using DBD::Oracle 1.15. Using DBI 1.41 (for perl 5.008003 on aix) installed in /usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help files. (Of course, you have read README by now anyway, haven't you?) # 08:56:25 /tmp/cpan/build/DBD-Oracle-1.15 # root:@fai02020 # make cp Oracle.pm blib/lib/DBD/Oracle.pm 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 lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm /usr/bin/perl -e 'use ExtUtils::Mksymlists; \ Mksymlists("NAME" => "DBD::Oracle", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS" => []);' /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI/Driver.xst > Oracle.xsi /usr/bin/perl /usr/local/lib/perl5/5.8.3/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.3/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c gcc -c -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/plsql/public -I/u01/oracle/product/8.1.7.4/network/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -D_LARGE_FILES -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/local/lib/perl5/5.8.3/aix/CORE" -DUTF8_SUPPORT Oracle.c gcc -c -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/plsql/public -I/u01/oracle/product/8.1.7.4/network/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -D_LARGE_FILES -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/local/lib/perl5/5.8.3/aix/CORE" -DUTF8_SUPPORT dbdimp.c gcc -c -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/plsql/public -I/u01/oracle/product/8.1.7.4/network/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -D_LARGE_FILES -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/local/lib/perl5/5.8.3/aix/CORE" -DUTF8_SUPPORT oci7.c gcc -c -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/plsql/public -I/u01/oracle/product/8.1.7.4/network/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/u01/oracle/product/8.1.7.4/rdbms/public -I/u01/oracle/product/8.1.7.4/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -D_LARGE_FILES -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" "-I/usr/local/lib/perl5/5.8.3/aix/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="/u01/oracle/product/8.1.7.4/lib:/u01/oracle/product/8.1.7.4 /rdbms/lib" gcc -Wl,-bhalt:4 -Wl,-bM:SRE -Wl,-bI:/usr/local/lib/perl5/5.8.3/aix/CORE/perl.exp -Wl,-bE:Oracle.exp -Wl,-bnoentry -lc Oracle.o dbdimp.o oci7.o oci8.o -L/u01/oracle/product/8.1.7.4/lib/ -L/u01/oracle/product/8.1.7.4/rdbms/lib/ /u01/oracle/product/8.1.7.4/rdbms/lib/kpudfo.o /u01/oracle/product/8.1.7.4/lib/nautab.o /u01/oracle/product/8.1.7.4/lib/naeet.o /u01/oracle/product/8.1.7.4/lib/naect.o /u01/oracle/product/8.1.7.4/lib/naedhs.o -lclntsh /u01/oracle/product/8.1.7.4/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lld -lm /lib/crt0_r.o -ldl -lc -lpthreads -lodm -lm -lbsd_r -lld -lm -bI:/u01/oracle/product/8.1.7.4/lib/pw-syscall.exp -bI:/u01/oracle/product/8.1.7.4/lib/ksms.imp -lpthreads -o blib/arch/auto/DBD/Oracle/Oracle.so ld: cannot open libgcc.a: A file or directory in the path name does not exist. gcc: file path prefix `/opt/freeware/GNUPro/lib/gcc-lib/I:/u01/oracle/product/8.1.7.4/lib/ksms .imp/2.9-aix51-020209/' never used make: *** [blib/arch/auto/DBD/Oracle/Oracle.so] Error 1 -- nathan vonnahme, system engineer at fairbanks memorial hospital/denali center 1650 cowles street, fairbanks alaska 99701. 907-458-5464
