The symbol kgefac_ should be in the Oracle shared library libclntsh.so.

With objdump -t (or nm) you can find out whether libclntsh.so does in fact provide the symbol, or not (e.g. wrong lib version):

$ objdump -t libclntsh.so.10.1 | grep kgefac_
[download]

(first find out where the lib resides, of course)

And ldd will tell you if your Oracle.so maybe hasn't been linked against libclntsh.so at all (problem at build time):

$ ldd /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/
+Oracle/Oracle.so
[download]

(In case it has been linked properly (so it would try to load the lib), but the lib cannot be found at runtime, you should have gotten a different error ("... cannot open shared object file: No such file or directory", or some such).)

This may have something to do with me manually editing the Makefile to point to /opt/oracle/product/10g/lib/ instead of where it was looking /opt/oracle/product/10g/lib32/ Is there a better way (say in Makefile.PL) rather than Makefile to make these changes

The only thing I've ever had to do to get DBD::Oracle installed was set ORACLE_HOME. Its always installed fine for me after that.

The only problem with that is: /opt/oracle/product/10g/rdbms/lib/ does not contain libclntsh.so

[kpiadmin@lsp1app124 ~/kevin/DBD-Oracle-1.27]$ ls /opt/oracle/product/
+10g/rdbms/lib/
Display all 111 possibilities? (y or n)
config.c        genezi.o        hout.o          kgupc.o         kpundf
+.o        kzlnlbac.o      libskgxpg.a     rfsd.o          sbbdpt.o   
+     srfsd.o         sulmain.o       zsmsdrv.o
config.o        genksms.o       hsxaora.o       kgutc.o         ksms.o
+          kzvndv.o        libskgxpr.a     rfsin.o         shorm.o    
+     ssbbded.o       tg4pwd.o
cursize.o       hoaoci.o        ins_rdbms.mk    kkpoban.o       ksnkcs
+.o        libdbtools10.a  libskgxpu.a     rfsxc.o         shou.o     
+     sskfeded.o      tstshm.o
dbfsize.o       hoat.o          jox.o           kkxntp.o        ksnkkp
+o.o       libdsga10.a     libxdb.a        s0exudrv.o      sjsex.o    
+     sskfoded.o      ttcoerr.o
defopt.o        hoax.o          joxoff.o        kkxwtp.o        ksnktd
+.o        libknlopt.a     mapsga.o        s0impdrv.o      skfedpt.o  
+     sskrmed.o       ttcsoi.o
dmndm.o         homts.o         kciwcx.o        kopc.o          ksnnni
+.o        libodm10.a      maxmem.o        s0kudbv.o       skfodpt.o  
+     sskrned.o       wpspldrv.o
dmndmse.o       hormc.o         kcsm.o          kprnts.o        ksnnt2
+.o        libperfsrv10.a  nmliblist       s0kuzr.o        skrmpt.o   
+     sskrsed.o       xaondy.o
dmwdm.o         hormd.o         kecnr.o         kprwts.o        ktd.o 
+          libqsmashr.a    opimai.o        s0kvpf.o        skrnpt.o   
+     ssoraed.o       xaonsl.o
dumpsga.o       horm.o          kecwr.o         kpucb.o         kxmnsd
+.o        libskgxns.a     osh.o           s0udexp.o       skrspt.o   
+     sstrced.o       xsnoolap.o
env_rdbms.mk    hormt.o         kfod.o          kpudfo.o        kxmwsd
+.o        libskgxpd.a     rfscom.o        s0udimp.o       sllfls.o   
+     strcpt.o        xsyeolap.o
[download]

[kpiadmin@lsp1app124 ~/kevin/DBD-Oracle-1.27]$ ls /opt/oracle/product/
+10g/lib/lib
Display all 181 possibilities? (y or n)
libagent10.a           libdbcfg10.so          libmgwagent.so         l
+ibnmastk.so           libnmuc.so             libocci10_343.a        l
+iborasdk.so.10.2      libsql10.a
libagtsh.so            libemmas10.so          libmm.a                l
+ibnmastk.so.0         libnmuc.so.0           libocci10_343.so.10.1  l
+ibordim10.a           libsqlplus.a
libagtsh.so.1.0        libexpat.a             libn10.a               l
+ibnmcfhc.so           libnmuk.so             libocci10.a            l
+ibordim10.so          libsqlplus.so
libavstub10.a          libexpat.la            libnavhoa.a            l
+ibnmcfsga.so          libnmuk.so.0           libocci.so             l
+ibordim10.soO         libsqora.so.10.1
libclient10.a          libexpat.so            libnbeq10.a            l
+ibnmeclurac.so        libnnet10.a            libocijdbc10.so        l
+ibordimt10.a          libsrvm10.so
libclntsh.so           libexpat.so.0          libncrypt10.a          l
+ibnmefos.so           libnnetd10.a           libocijdbcst10.a       l
+ibordsdo10.a          libsrvm10.so0
libclntsh.so.10.1      libexpat.so.0.5.0      libnhost10.a           l
+ibnmefos.so.0         libnnz10.a             libocr10.a             l
+ibOsUtils.so          libsrvmhas10.so
libclntst10.a          libgeneric10.a         libnid.a               l
+ibnmefsql.so          libnnz10.so            libocr10.so            l
+ibowm2.so             libsrvmhas10.so0
libclsr10.a            libgx10.a              libnjni10.so           l
+ibnmefsql.so.0        libnoname10.a          libocrb10.a            l
+ibplc10.a             libsrvmocr10.so
libclsra10.so          libhasgen10.so         libnjssl10.so          l
+ibnmefud.so           libnque10.so           libocrb10.so           l
+ibplp10.a             libsrvmocr10.so0
libclsrx10.a           libheteroxa10.so       libnl10.a              l
+ibnmefud.so.0         libnro10.a             libocrutl10.a          l
+ibpls10.a             libuini10.a
libcommon10.a          libhsbase.so           libnldap10.a           l
+ibnmefut.so           libnsgr10.a            libocrutl10.so         l
+ibpsa10.a             libuini10.so
libcore10.a            libhsnav.so            libnls10.a             l
+ibnmefut.so.0         libnsgrsh10.a          libodm10.so            l
+ibqsmashr.so          libunls10.a
libcorejava.so         libimf.so              libnmadbg.so           l
+ibnmefvr.so           libnsslb10.a           libodmd10.so           l
+ibserver10.a          libunwind.so.5
libcoresh10.so         libirc.a               libnmadbg.so.0         l
+ibnmefvr.so.0         libntcp10.a            liboevm.a              l
+ibskgxn2.so           libvsn10.a
libcprts.so.5          libisqlplus.so         libnmadm.so            l
+ibnmefw.so            libntcpaio10.so        libolapapi10.so        l
+ibskgxns.so           libvsn10_std.a.dbl
libctx10.a             libjmisc.so            libnmadm.so.0          l
+ibnmefw.so.0          libntcps10.a           libons.so              l
+ibskgxp10.so          libwwg.a
libctxc10.a            libjox10oraawt.so      libnmalk.so            l
+ibnmemso.so           libntcps10_std.a.dbl   liboraioser.so         l
+ibskgxpd.so           libxdb.so
libctxs10.a            libjox10.so            libnmalk.so.0          l
+ibnmemso.so.0         libntns10.a            liborajaas.so          l
+ibskgxpg.so           libxml10.a
libcxaguard.so.5       libldapclnt10.a        libnmarl.so            l
+ibnmeoci.so           libnus10.a             liboraolap10.a         l
+ibskgxpr.so           libzx10.a
libcxa.so.3            libldapjclnt10.a       libnmarl.so.0          l
+ibnmeoci.so.0         libnzjs10.a            liborasdkbase.so       l
+ibskgxpu.so
libcxa.so.5            libldapjclnt10.so      libnmasf.so            l
+ibnmevq.so            libocci10_296.a        liborasdkbase.so.10.2  l
+ibslax10.a
libdbcfg10.a           liblxled.a             libnmasf.so.0          l
+ibnmevq.so.0          libocci10_296.so.10.1  liborasdk.so           l
+ibsnls10.a
[download]

LD_LIBRARY_PATH is a path. It can contain multiple things, separated by colons.

That said, /opt/oracle/product/10g/rdbms/lib/ doesn't look like it contains any .so files. So my "educated guess" seems to be incorrect.

Perhaps it's as simple as properly setting some environment variables so the Oracle stuff can load the proper client library.

It seems the linking may be good.

[kpiadmin@lsp1app124 /opt/oracle/product/10g/lib]$ objdump -t libclnts
+h.so.10.1 | grep kgefac_
00d23a20 g     O .rodata        00000004              kgefac_
[download]

Mmm, that's not what I mean.

I presume there are 2 "DLL"s for Oracle: one from Oracle itself with the client libraries, and the Perl compiled XS file, which is a glue file, for the most part.

I think that, while your compiled XS file may be fine, that it and the client DLL are not compatible.

Have you got sqlplus connecting to this Oracle yet?

Set ORACLE_HOME env var to point into your oracle tree and export it, run perl Makefile.PL and make and post the output of both here. If the make succeeds, set ORACLE_USERID=username/password and DBI_DSN=dbi:Oracle:host=x;sid=y (or whatever you need to connect to Oracle) and run make test. Post the output here.

It looks as if you have a 32 bit Perl but is this a 32bit machine?