Date: Fri, 1 Apr 2005 11:08:45 -0500 From: Richard Morse <remorse@partners.org> To: questions@freebsd.org Subject: Compiling DBD::Oracle against Oracle 10g (Linux)? Message-ID: <5305CA2D-A2C8-11D9-806B-000A956EB07E@partners.org>
next in thread | raw e-mail | index | archive | help
--Apple-Mail-2-920539307 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Hi! I'm trying to set up DBD::Oracle to use the Oracle 10g Client (for Linux). I have Oracle installed, and sqlplus works just fine. However, DBD::Oracle seems to have problems. I've included a "script" session which contains a typical build (I did run through the all the various suggestions in the README, but they had no real differences). I haven't yet emailed the dbi-users list; I thought I would ask here first to see if anyone has solved this problem before, especially since I am using the linux compatibility layer to get Oracle to run... The primary error that I'm trying to understand is, when running make test: install_driver(Oracle) failed: Can't load '/root/.cpan/build/DBD-Oracle-1.16/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: Shared object "libnnz10.so" not found, required by "libclntsh.so.10.1" at /usr/local/lib/perl5/5.8.6/mach/DynaLoader.pm line 230. Thanks, Ricky Morse --Apple-Mail-2-920539307 Content-Transfer-Encoding: quoted-printable Content-Type: application/octet-stream; x-mac-type=54455854; x-unix-mode=0644; name="dbd-ora-session" Content-Disposition: attachment; filename=dbd-ora-session Script=20started=20on=20Fri=20Apr=20=201=2010:29:00=202005=0A=0Ahedwig#=09= perl=20Makefile.PL=20=0A=0AUsing=20DBI=201.47=20(for=20perl=205.008006=20= on=20i386-freebsd-64int)=20installed=20in=20= /usr/local/lib/perl5/site_perl/5.8.6/mach/auto/DBI/=0A=20Configuring=20= DBD::Oracle=20...=0A>>>=09Remember=20to=20actually=20*READ*=20the=20= README=20file!=0A=20=20=20=09Especially=20if=20you=20have=20any=20= problems.=0AUsing=20Oracle=20in=20/usr/local/oracle=0ADEFINE=20= _SQLPLUS_RELEASE=20=3D=20"1001000300"=20(CHAR)=0AOracle=20version=20= 10.1.0.3=20(10.1)=0AFound=20/usr/local/oracle/rdbms/demo/demo_rdbms.mk=0A= Using=20/usr/local/oracle/rdbms/demo/demo_rdbms.mk=0AReading=20= /usr/local/oracle/rdbms/demo/demo_rdbms.mk=0AReading=20= /usr/local/oracle/rdbms/lib/env_rdbms.mk=0A=0AAttempting=20to=20discover=20= Oracle=20OCI=20build=20rules=0Acc=20-O=20-pipe=20=20-c=20DBD_ORA_OBJ.c=0A= by=20executing:=20[make=20-f=20= /usr/local/oracle/rdbms/demo/demo_rdbms.mk=20build=20ECHODO=3Decho=20= ECHO=3Decho=20GENCLNTSH=3D'echo=20genclntsh'=20CC=3Dtrue=20OPTIMIZE=3D=20= CCFLAGS=3D=20EXE=3DDBD_ORA_EXE=20OBJS=3DDBD_ORA_OBJ.o]=0AWarning:=20= Oracle=20build=20rule=20discovery=20failed=20(256)=0AOracle=20oci=20= build=20prolog:=0A=20=09["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20= line=20222:=20Need=20an=20operator]=0A=09= ["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=20224:=20Need=20an=20= operator]=0A=09["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=20= 226:=20Need=20an=20operator]=0A=09= ["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=20244:=20Need=20an=20= operator]=0A=09["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=20= 248:=20Need=20an=20operator]=0A=09= ["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=20252:=20Need=20an=20= operator]=0A=09["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=20= 2525:=20Missing=20dependency=20operator]=0A=09= ["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=202527:=20Need=20an=20= operator]=0A=09["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=20= 2529:=20Need=20an=20operator]=0A=09= ["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=202532:=20Missing=20= dependency=20operator]=0A=09["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20= line=202536:=20Need=20an=20operator]=0A=09= ["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20line=202538:=20Missing=20= dependency=20operator]=0A=09["/usr/local/oracle/rdbms/lib/env_rdbms.mk",=20= line=202540:=20Need=20an=20operator]=0A=09[make:=20fatal=20errors=20= encountered=20--=20cannot=20continue]=0AOracle=20oci=20build=20command:=0A= =09[]=0AUnable=20to=20interpret=20Oracle=20build=20commands=20from=20= /usr/local/oracle/rdbms/demo/demo_rdbms.mk.=07=0A(Will=20continue=20by=20= using=20fallback=20approach.)=0APlease=20report=20this=20to=20= dbi-users@perl.org.=20See=20README=20for=20what=20to=20include.=0A=0A= Found=20header=20files=20in=20rdbms/public.=0A=0AChecking=20for=20= functioning=20wait.ph=0A=0ASystem:=20perl5.008006=20freebsd=20= hedwig.mgh.harvard.edu=205.3-stable=20freebsd=205.3-stable=20#1:=20mon=20= dec=2013=2011:31:45=20est=202004=20= root@hedwig.mgh.harvard.edu:usrobjusrsrcsyshedwig_v2=20i386=20=0A= Compiler:=20=20=20cc=20-O=20-pipe=20=20= -DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.6/BSDPAN"=20-DHAS_FPSETMASK=20= -DHAS_FLOATINGPOINT_H=20-fno-strict-aliasing=20-pipe=20= -I/usr/local/include=0ALinker:=20=20=20=20=20/usr/bin/ld=0ASysliblist:=20= -ldl=20-lm=20-lpthread=20-lnsl=20-lirc=20=0AOracle=20makefiles=20would=20= have=20used=20these=20definitions=20but=20we=20override=20them:=0A=20=20= CC:=20=20=20=20=20=20=20cc=0A=0A=20=20CFLAGS:=20=20=20$(GFLAG)=20= $(OPTIMIZE)=20$(CDEBUG)=20$(CCFLAGS)=20$(PFLAGS)\=0A=09$(SHARED_CFLAG)=20= $(USRFLAGS)=0A=20=20=20=20=20=20=20=20=20=20=20[$(GFLAG)=20-O3=20= $(CDEBUG)=20$(CCFLAGS)=20-I/usr/local/oracle/rdbms/demo=20= -I/usr/local/oracle/rdbms/public=20-I/usr/local/oracle/plsql/public=20= -I/usr/local/oracle/network/public=20-DLINUX=20-D_GNU_SOURCE=20= -D_LARGEFILE64_SOURCE=3D1=20-D_LARGEFILE_SOURCE=3D1=20-DSLTS_ENABLE=20= -DSLMXMX_ENABLE=20-D_REENTRANT=20-DNS_THREADS=20$(LPFLAGS)=20= $(USRFLAGS)]=0A=0A=20=20build:=20=20=20=20=20$(CC)=20$(ORALIBPATH)=20-o=20= $(EXE)=20$(OBJS)=20$(OCISHAREDLIBS)=0A=20=20=20=20=20=20=20=20=20=20=20[=20= cc=20-L$(LIBHOME)=20-L/usr/local/oracle/rdbms/lib/=20-o=20$(EXE)=20= $(OBJS)=20-lclntsh=20$(EXPDLIBS)=20$(EXOSLIBS)=20-ldl=20-lm=20-lpthread=20= -lnsl=20-lirc=20-ldl=20-lm=20$(USRLIBS)=20]=0A=0A=20=20LDFLAGS:=20=20-o=20= $@=20$(LDPATHFLAG)$(PRODLIBHOME)=20$(LDPATHFLAG)$(LIBHOME)=20= $(LDPATHFLAG)$(LIBHOME)stubs/=0A=20=20=20=20=20=20=20=20=20=20=20[-o=20= $@=20-L/usr/local/oracle/rdbms/lib/=20-L$(LIBHOME)=20-L$(LIBHOME)stubs/]=0A= =0ALinking=20with=20/usr/local/oracle/rdbms/lib/defopt.o=20=20-lclntsh=20= -ldl=20-lm=20-lpthread=20-lnsl=20-lirc=20-ldl=20-lm=20=20[from=20= $(DEF_OPT)=20$(OCISHAREDLIBS)]=0A=0AWarning:=20If=20you=20have=20= problems=20you=20may=20need=20to=20rebuild=20perl=20with=20threading=20= enabled.=07=0A=0AWarning:=20If=20you=20have=20problems=20you=20may=20= need=20to=20rebuild=20perl=20with=20-Uusemymalloc.=07=0A=0AChecking=20if=20= your=20kit=20is=20complete...=0ALooks=20good=0ANote=20(probably=20= harmless):=20No=20library=20found=20for=20-ldl=0ANote=20(probably=20= harmless):=20No=20library=20found=20for=20-lnsl=0ANote=20(probably=20= harmless):=20No=20library=20found=20for=20-ldl=0A= LD_RUN_PATH=3D/usr/local/oracle/lib=0AUsing=20DBD::Oracle=201.16.=0A= Using=20DBD::Oracle=201.16.=0AUsing=20DBI=201.47=20(for=20perl=20= 5.008006=20on=20i386-freebsd-64int)=20installed=20in=20= /usr/local/lib/perl5/site_perl/5.8.6/mach/auto/DBI/=0AWriting=20Makefile=20= for=20DBD::Oracle=0A=0A***=20=20If=20you=20have=20problems...=0A=20=20=20= =20=20read=20all=20the=20log=20printed=20above,=20and=20the=20README=20= and=20README.help=20files.=0A=20=20=20=20=20(Of=20course,=20you=20have=20= read=20README=20by=20now=20anyway,=20haven't=20you?)=0A=0Ahedwig#=09make=0A= =0Acp=20Oracle.pm=20blib/lib/DBD/Oracle.pm=0Acp=20oraperl.ph=20= blib/lib/oraperl.ph=0Acp=20dbdimp.h=20blib/arch/auto/DBD/Oracle/dbdimp.h=0A= cp=20ocitrace.h=20blib/arch/auto/DBD/Oracle/ocitrace.h=0Acp=20Oraperl.pm=20= blib/lib/Oraperl.pm=0Acp=20Oracle.h=20blib/arch/auto/DBD/Oracle/Oracle.h=0A= cp=20lib/DBD/Oracle/GetInfo.pm=20blib/lib/DBD/Oracle/GetInfo.pm=0Acp=20= mk.pm=20blib/arch/auto/DBD/Oracle/mk.pm=0A/usr/bin/perl=20-p=20-e=20= "s/~DRIVER~/Oracle/g"=20= /usr/local/lib/perl5/site_perl/5.8.6/mach/auto/DBI//Driver.xst=20>=20= Oracle.xsi=0A/usr/bin/perl=20/usr/local/lib/perl5/5.8.6/ExtUtils/xsubpp=20= =20-typemap=20/usr/local/lib/perl5/5.8.6/ExtUtils/typemap=20-typemap=20= typemap=20=20Oracle.xs=20>=20Oracle.xsc=20&&=20mv=20Oracle.xsc=20= Oracle.c=0Acc=20-c=20=20-I/usr/local/oracle/rdbms/demo=20= -I/usr/local/oracle/rdbms/public=20-I/usr/local/oracle/plsql/public=20= -I/usr/local/oracle/network/public=20-I/usr/local/oracle/rdbms/demo=20= -I/usr/local/oracle/rdbms/public=20= -I/usr/local/lib/perl5/site_perl/5.8.6/mach/auto/DBI/=20=20= -DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.6/BSDPAN"=20-DHAS_FPSETMASK=20= -DHAS_FLOATINGPOINT_H=20-fno-strict-aliasing=20-pipe=20= -I/usr/local/include=20-O=20-pipe=20=20=20=20-DVERSION=3D\"1.16\"=20=20= -DXS_VERSION=3D\"1.16\"=20-DPIC=20-fPIC=20= "-I/usr/local/lib/perl5/5.8.6/mach/CORE"=20=20-Wall=20-Wno-comment=20= -DUTF8_SUPPORT=20-DNEW_OCI_INIT=20-DORA_OCI_VERSION=3D\"10.1.0.3\"=20= Oracle.c=0AOracle.c:=20In=20function=20= `XS_DBD__Oracle__db_ora_lob_append':=0AOracle.xs:191:=20warning:=20= unused=20variable=20`startp'=0Acc=20-c=20=20= -I/usr/local/oracle/rdbms/demo=20-I/usr/local/oracle/rdbms/public=20= -I/usr/local/oracle/plsql/public=20-I/usr/local/oracle/network/public=20= -I/usr/local/oracle/rdbms/demo=20-I/usr/local/oracle/rdbms/public=20= -I/usr/local/lib/perl5/site_perl/5.8.6/mach/auto/DBI/=20=20= -DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.6/BSDPAN"=20-DHAS_FPSETMASK=20= -DHAS_FLOATINGPOINT_H=20-fno-strict-aliasing=20-pipe=20= -I/usr/local/include=20-O=20-pipe=20=20=20=20-DVERSION=3D\"1.16\"=20=20= -DXS_VERSION=3D\"1.16\"=20-DPIC=20-fPIC=20= "-I/usr/local/lib/perl5/5.8.6/mach/CORE"=20=20-Wall=20-Wno-comment=20= -DUTF8_SUPPORT=20-DNEW_OCI_INIT=20-DORA_OCI_VERSION=3D\"10.1.0.3\"=20= dbdimp.c=0Adbdimp.c:=20In=20function=20`ora_db_login6':=0Adbdimp.c:314:=20= warning:=20cast=20to=20pointer=20from=20integer=20of=20different=20size=0A= dbdimp.c:328:=20warning:=20cast=20to=20pointer=20from=20integer=20of=20= different=20size=0Adbdimp.c:338:=20warning:=20cast=20to=20pointer=20from=20= integer=20of=20different=20size=0Adbdimp.c:342:=20warning:=20cast=20to=20= pointer=20from=20integer=20of=20different=20size=0Adbdimp.c:=20In=20= function=20`dbd_rebind_ph_char':=0Adbdimp.c:1120:=20warning:=20cast=20= from=20pointer=20to=20integer=20of=20different=20size=0Acc=20-c=20=20= -I/usr/local/oracle/rdbms/demo=20-I/usr/local/oracle/rdbms/public=20= -I/usr/local/oracle/plsql/public=20-I/usr/local/oracle/network/public=20= -I/usr/local/oracle/rdbms/demo=20-I/usr/local/oracle/rdbms/public=20= -I/usr/local/lib/perl5/site_perl/5.8.6/mach/auto/DBI/=20=20= -DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.6/BSDPAN"=20-DHAS_FPSETMASK=20= -DHAS_FLOATINGPOINT_H=20-fno-strict-aliasing=20-pipe=20= -I/usr/local/include=20-O=20-pipe=20=20=20=20-DVERSION=3D\"1.16\"=20=20= -DXS_VERSION=3D\"1.16\"=20-DPIC=20-fPIC=20= "-I/usr/local/lib/perl5/5.8.6/mach/CORE"=20=20-Wall=20-Wno-comment=20= -DUTF8_SUPPORT=20-DNEW_OCI_INIT=20-DORA_OCI_VERSION=3D\"10.1.0.3\"=20= oci8.c=0Aoci8.c:566:=20warning:=20'fetch_func_nty'=20defined=20but=20not=20= used=0Aoci8.c:1012:=20warning:=20'fbh_setup_getrefpv'=20defined=20but=20= not=20used=0ARunning=20Mkbootstrap=20for=20DBD::Oracle=20()=0Achmod=20= 644=20Oracle.bs=0Arm=20-f=20blib/arch/auto/DBD/Oracle/Oracle.so=0A= LD_RUN_PATH=3D"/usr/local/oracle/lib"=20cc=20=20-shared=20=20= -L/usr/local/lib=20Oracle.o=20=20dbdimp.o=20=20oci8.o=20= /usr/local/oracle/rdbms/lib/defopt.o=20=20-o=20= blib/arch/auto/DBD/Oracle/Oracle.so=20=20=20-L/usr/local/oracle/lib/=20= -lclntsh=20-lm=20-lpthread=20-lirc=20-lm=20=20=20=0Achmod=20755=20= blib/arch/auto/DBD/Oracle/Oracle.so=0Acp=20Oracle.bs=20= blib/arch/auto/DBD/Oracle/Oracle.bs=0Achmod=20644=20= blib/arch/auto/DBD/Oracle/Oracle.bs=0A/usr/bin/perl=20"-Iblib/arch"=20= "-Iblib/lib"=20ora_explain.PL=20ora_explain=0AExtracted=20ora_explain=20= from=20ora_explain.PL=20with=20variable=20substitutions.=0Acp=20= ora_explain=20blib/script/ora_explain=0A/usr/bin/perl=20"-MExtUtils::MY"=20= -e=20"MY->fixin(shift)"=20blib/script/ora_explain=0AManifying=20= blib/man1/ora_explain.1=0AManifying=20blib/man3/DBD::Oracle.3=0A= Manifying=20blib/man3/DBD::Oraperl.3=0A=0Ahedwig#=09setenv=20TWO_TASK=20= ***=0Ahedwig#=09setenv=20ORACLE_USERID=20***/***=0A=0Ahedwig#=09make=20= test=0APERL_DL_NONLAZY=3D1=20/usr/bin/perl=20"-MExtUtils::Command::MM"=20= "-e"=20"test_harness(0,=20'blib/lib',=20'blib/arch')"=20t/*.t=0A= t/01base................Failed=20to=20load=20Oracle=20extension=20and/or=20= shared=20libraries:=0Ainstall_driver(Oracle)=20failed:=20Can't=20load=20= '/root/.cpan/build/DBD-Oracle-1.16/blib/arch/auto/DBD/Oracle/Oracle.so'=20= for=20module=20DBD::Oracle:=20Shared=20object=20"libnnz10.so"=20not=20= found,=20required=20by=20"libclntsh.so.10.1"=20at=20= /usr/local/lib/perl5/5.8.6/mach/DynaLoader.pm=20line=20230.=0A=20at=20= (eval=203)=20line=203=0ACompilation=20failed=20in=20require=20at=20(eval=20= 3)=20line=203.=0APerhaps=20a=20required=20shared=20library=20or=20dll=20= isn't=20installed=20where=20expected=0A=20at=20t/01base.t=20line=2019=0A= The=20remaining=20tests=20will=20probably=20also=20fail=20with=20the=20= same=20error.=07=0A***=20Please=20read=20the=20README=20and=20= README.help=20files=20for=20help.=20***=0A=0A^C=0A=0AScript=20done=20on=20= Fri=20Apr=20=201=2010:30:25=202005=0A= --Apple-Mail-2-920539307--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5305CA2D-A2C8-11D9-806B-000A956EB07E>