I had already looked through the archives but couldn't find any direct references. So far I have found a C++ style comment in the dbdimp.c file (removing this line will fix the syntax error). But now the make can't find -lclntsh, I know this is present under product/9.2/lib/libclntsh.so. I followed a suggestion by someone about using LD_OPTIONS="-D libs,detail" for detailed debugging, and I have noticed that for the libraries found almost all of them have a *.a file as well but libclntsh.so does not have a *.a equivalent. The archives and google are not very helpful in pointing out why this library is not found and any workarounds. As you can probably tell by now, my programming skills are limited, I am the sysadmin on the box trying to install/build the DBD:Oracle module.
Zahid -----Original Message----- From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 6:37 AM To: 'Naqvi Zahid - znaqvi' Subject: RE: DBD Oracle would not install on solaris Have you looked at the archives? Their have been so many posts on this issue, please take a look at the archive and I am sure you will find the answer to your issue. -----Original Message----- From: Naqvi Zahid - znaqvi [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:44 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: DBD Oracle would not install on solaris Sorry for the re-post but I didn't get any attention the first time around. I am trying to build DBD::Oracle on a Solaris 7 machine and keep running into make errors. I have read all the readme files and tried Google search for matching errors but no sucess so far. The logs as requested in the README file are copied below. Any help is greately appreciated. # perl Makefile.PL -v Using DBI 1.39 installed in /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u01/app/oracle/product/9.2 Oracle version 9.2.0.0.0 Found header files in rdbms/public rdbms/demo. Found /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk Found /u01/app/oracle/product/9.2/otrace/demo/atmoci.mk Found /u01/app/oracle/product/9.2/precomp/demo/proc/demo_proc.mk Using /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk Reading /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk Reading /u01/app/oracle/product/9.2/rdbms/lib/env_rdbms.mk Read a total of 2318 lines from /u01/app/oracle/product/9.2/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 2674 lines from /u01/app/oracle/product/9.2/rdbms/demo/demo_rdbms.mk (including inclusions) Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o Deleted AR definition: AR=ar Deleted AS definition: AS=as Deleted CC definition: CC=cc Deleted CHMOD definition: CHMOD=chmod Deleted CPP definition: CPP=cpp Deleted ECHO definition: ECHO=echo Deleted LD definition: LD=ld Deleted PERL definition: PERL=perl Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE3) Deleted AR definition: AR=/usr/ccs/bin/ar Deleted AS definition: AS=/usr/ccs/bin/as Deleted LD definition: LD=/usr/ccs/bin/ld Deleted CPP definition: CPP=$(CC) -E $(ANSI) Deleted CHMOD definition: CHMOD=/bin/chmod Deleted ASFLAGS definition: ASFLAGS=$(NOKPIC_ASFLAGS) $(KPIC_OPTION) Deleted CCFLAGS definition: CCFLAGS=$(NOKPIC_CCFLAGS) $(KPIC_OPTION) 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. Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ 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. Deleted ORA_NLS33 definition: ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxpd.a /u01/app/oracle/product/9.2/rdbms/lib/libskgxpu.a /u01/app/oracle/product/9.2/rdbms/lib/libskgxpt.a' to EXTRALIBS Appending '$(LIBHOME)libskgxp9.so' to SHLIBS Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxp9.a' to LIBS Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxns.a /u01/app/oracle/product/9.2/rdbms/lib/libskgxnd.a /u01/app/oracle/product/9.2/rdbms/lib/libskgxnr.a' to EXTRALIBS Appending '$(LIBHOME)libskgxn9.so' to SHLIBS Appending '/u01/app/oracle/product/9.2/rdbms/lib/libskgxn9.a' to LIBS Evaluating `cat $(LIBHOME)sysliblist` expanded `cat /u01/app/oracle/product/9.2/lib/sysliblist` returned '-lnsl -lsocket -lgen -ldl ' Attempting to discover Oracle OCI build rules /opt/SUNWspro/bin/cc -c DBD_ORA_OBJ.c by executing: (make -f /u01/app/oracle/product/9.2/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) returned: [echo -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build -L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /u01/app/oracle/product/9.2/lib/ldflags` `cat /u01/app/oracle/product/9.2/lib/sysliblist` -R/u01/app/oracle/product/9.2/lib -laio -lposix4 -lkstat -lm -lthread [-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build -L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio -lposix4 -lkstat -lm -lthread ] reduced to: [-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build -L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio -lposix4 -lkstat -lm -lthread ] Oracle oci build command: + -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build -L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio -lposix4 -lkstat -lm -lthread System: perl5.008 sunos daytona 5.7 generic_106541-14 sun4us sparc fjsv,gpusk Compiler: /opt/SUNWspro/bin/cc -O -D_REENTRANT -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/ccs/bin/ld Sysliblist: -lnsl -lsocket -lgen -ldl Oracle makefiles would have used these definitions but we override them: CC: cc CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign -xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3 -W2,-AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 -xcode=abs44 -Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC -I/u01/app/oracle/product/9.2/rdbms/demo -I/u01/app/oracle/product/9.2/rdbms/public -I/u01/app/oracle/product/9.2/plsql/public -I/u01/app/oracle/product/9.2/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)] LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) [-o $@ -L/u01/app/oracle/product/9.2/rdbms/lib/ -L$(LIBHOME)] Linking with OTHERLDFLAGS = -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build -L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/ -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio -lposix4 -lkstat -lm -lthread [from 'build' rule] Argument "9.200.0.0" isn't numeric in numeric ge (>=) at Makefile.PL line 669. MakeMaker (v6.03) Checking if your kit is complete... Looks good ABSTRACT_FROM => q[Oracle.pm] AUTHOR => q[Tim Bunce ([EMAIL PROTECTED])] DEFINE => q[ -DUTF8_SUPPORT] DIR => [] EXE_FILES => [q[ora_explain]] INC => q[-I/u01/app/oracle/product/9.2/rdbms/demo -I/u01/app/oracle/product/9.2/rdbms/public -I/u01/app/oracle/product/9.2/plsql/public -I/u01/app/oracle/product/9.2/network/public -I/u01/app/oracle/product/9.2/rdbms/demo -I/u01/app/oracle/product/9.2/rdbms/public -I/u01/app/oracle/product/9.2/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI] NAME => q[DBD::Oracle] OBJECT => q[$(O_FILES)] PREREQ_PM => { DBI=>q[0] } VERSION_FROM => q[Oracle.pm] clean => { FILES=>q[Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def ora_explain mk.pm] } dist => { DIST_DEFAULT=>q[clean distcheck disttest ci tardist], COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f Makefile.old distdir], SUFFIX=>q[gz] } dynamic_lib => { OTHERLDFLAGS=>q[ -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build -L/u01/app/oracle/product/9.2/rdbms/lib/ -L/u01/app/oracle/product/9.2/lib/ -lclntsh -lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/u01/app/oracle/product/9.2/lib -laio -lposix4 -lkstat -lm -lthread ] } Using PERL=/usr/local/bin/perl LD_RUN_PATH=/u01/app/oracle/product/9.2/lib:/u01/app/oracle/product/9.2/rdbm s/lib Using DBD::Oracle 1.14. Using DBD::Oracle 1.14. Using DBI 1.39 installed in /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/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?) # make cp Oracle.pm blib/lib/DBD/Oracle.pm cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h cp oraperl.ph blib/lib/oraperl.ph cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h cp Oraperl.pm blib/lib/Oraperl.pm cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm /usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI/Driv er.xst > Oracle.xsi /usr/local/bin/perl /usr/local/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c /opt/SUNWspro/bin/cc -c -I/u01/app/oracle/product/9.2/rdbms/demo -I/u01/app/oracle/product/9.2/rdbms/public -I/u01/app/oracle/product/9.2/plsql/public -I/u01/app/oracle/product/9.2/network/public -I/u01/app/oracle/product/9.2/rdbms/demo -I/u01/app/oracle/product/9.2/rdbms/public -I/u01/app/oracle/product/9.2/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI -D_REENTRANT -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -KPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris-thread-multi/CORE" -DUTF8_SUPPORT Oracle.c "/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 927: warning: parameter has incomplete type: tdo "/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1042: warning: parameter has incomplete type: type_ref "/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1044: warning: parameter has incomplete type: tdo "/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6338: warning: parameter has incomplete type: hndl "/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6556: warning: parameter has incomplete type: argv /opt/SUNWspro/bin/cc -c -I/u01/app/oracle/product/9.2/rdbms/demo -I/u01/app/oracle/product/9.2/rdbms/public -I/u01/app/oracle/product/9.2/plsql/public -I/u01/app/oracle/product/9.2/network/public -I/u01/app/oracle/product/9.2/rdbms/demo -I/u01/app/oracle/product/9.2/rdbms/public -I/u01/app/oracle/product/9.2/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-multi/auto/DBI -D_REENTRANT -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" -KPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris-thread-multi/CORE" -DUTF8_SUPPORT dbdimp.c "/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 927: warning: parameter has incomplete type: tdo "/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1042: warning: parameter has incomplete type: type_ref "/u01/app/oracle/product/9.2/rdbms/demo/ort.h", line 1044: warning: parameter has incomplete type: tdo "/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6338: warning: parameter has incomplete type: hndl "/u01/app/oracle/product/9.2/rdbms/demo/ociap.h", line 6556: warning: parameter has incomplete type: argv "dbdimp.c", line 263: syntax error before or at: / cc: acomp failed for dbdimp.c *** Error code 2 make: Fatal error: Command failed for target `dbdimp.o' In case dbdimp.c has any impact on the make process the line which has the syntax error is pasted below //Move (((char *)shared_dbh) + DBH_DUP_OFF, ((char *)imp_dbh) + DBH_DUP_OFF , DBH_DUP_LEN, char *) ; Needless to say any help is greately appreciated. Zahid Naqvi Unix Systems Engineer "Perfection of means and confusion of goals seem-in my opinion-to characterize our age." - Albert Einstein ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.
