Re: DBD::Oracle for Oracle instantclient 10

piet paaltjens wrote:
> Dear Jay (Strauss),
>
> following your advise this is what happens now:
>
> perl Makefile.PL -m
> /usr/lib/oracle/10.2.0.1/client/proc.mk
> Multiple copies of Driver.xst found in:
> /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/ DBI/
> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/aut o/DBI/
> at Makefile.PL line 39
> Using DBI 1.48 (for perl 5.008003 on
> i386-linux-thread-multi) installed in
> /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/ DBI/
>
> Configuring DBD::Oracle ...
>
>
>>>> Remember to actually *READ* the README file!
>
> Especially if you have any problems.
>
> Using Oracle in /usr/lib/oracle/10.2.0.1/client
> DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
> Oracle version 10.2.0.1 (10.2)
> Found /usr/lib/oracle/10.2.0.1/client/proc.mk
> Using /usr/lib/oracle/10.2.0.1/client/proc.mk
> Reading /usr/lib/oracle/10.2.0.1/client/proc.mk
> ERROR parsing /usr/lib/oracle/10.2.0.1/client/proc.mk:
> Unable to determine what to link with.
> Please send me copies of these files (one per mail
> message):
> /usr/lib/oracle/10.2.0.1/client/proc.mk
>
> The contents of that file can be found in the
> attachment.
>
> The directory structure now looks like :
>
> /usr/lib/oracle/10.2.0.1/client:
> total 24
> drwxr-xr-x 2 root root 4096 Oct 19 11:09 bin
> drwxr-xr-x 2 root root 4096 Oct 19 12:22 lib
> drwxr-xr-x 3 root root 4096 Oct 19 11:35 network
> -rw-r--r-- 1 root root 4053 Oct 19 12:38 proc.mk
>
> /usr/lib/oracle/10.2.0.1/client/bin:
> total 12
> -r-xr-xr-x 1 root root 8697 Oct 11 00:40 sqlplus
>
> /usr/lib/oracle/10.2.0.1/client/lib:
> total 99548
> -r--r--r-- 1 root root 1590491 Oct 11 00:39
> classes12.jar
> -r--r--r-- 1 root root 1525 Oct 11 00:39
> glogin.sql
> lrwxrwxrwx 1 root root 17 Oct 19 12:22
> libclntsh.so -> libclntsh.so.10.1
> -rwxr-xr-x 1 root root 18505986 Oct 11 00:39
> libclntsh.so.10.1
> -r-xr-xr-x 1 root root 5480533 Oct 11 00:39
> libnnz10.so
> lrwxrwxrwx 1 root root 15 Oct 19 12:22
> libocci.so -> libocci.so.10.1
> -rwxr-xr-x 1 root root 1397960 Oct 11 00:39
> libocci.so.10.1
> -rwxr-xr-x 1 root root 70659429 Oct 11 00:39
> libociei.so
> -r-xr-xr-x 1 root root 119947 Oct 11 00:39
> libocijdbc10.so
> -r-xr-xr-x 1 root root 1434227 Oct 11 00:39
> libsqlplusic.so
> -r-xr-xr-x 1 root root 1047293 Oct 11 00:39
> libsqlplus.so
> -r--r--r-- 1 root root 1536979 Oct 11 00:39
> ojdbc14.jar
>
> /usr/lib/oracle/10.2.0.1/client/network:
> total 4
> drwxr-xr-x 2 root root 4096 Oct 19 11:56 admin
>
> /usr/lib/oracle/10.2.0.1/client/network/admin:
> total 48
> -rw-r--r-- 1 root root 191 Oct 19 11:55 sqlnet.ora
> -rw-r--r-- 1 root root 8623 Oct 19 11:56 tnsnames.ora
>
> And my environment looks like this:
>
> LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.1/client/lib
> ORACLE_HOME=/usr/lib/oracle/10.2.0.1/client
>
> What do I (need to) do now?
>
> Thanks in advance!

I don't have a proc.mk in my setup, I used demo.mk. Additionally, some
of your files are in different areas than mine (not that mine is the
perfect setup). Here is what mine looks like:

jstrauss@ubuntu:/usr/local/src/instantclient_10_2$ ls -R
..:
bin demo include java lib network

../bin:
glogin.sql ott sqlplus

../demo:
cdemo81.c occidemod.sql occidml.cpp occiobj.typ
demo.mk occidemo.sql occiobj.cpp

../include:
nzerror.h occiControl.h oci1.h ocidef.h oci.h oratypes.h
oro.h
nzt.h occiData.h oci8dp.h ocidem.h ocikpr.h orid.h
ort.h
occiAQ.h occi.h ociap.h ocidfn.h ocixmldb.h ori.h
xa.h
occiCommon.h occiObjects.h ociapr.h ociextp.h odci.h orl.h

../java:
classes12.jar ojdbc14.jar ottclasses.zip

../lib:
libclntsh.so libnnz10.so libociei.so libsqlplusic.so
libclntsh.so.10.1 libocci.so.10.1 libocijdbc10.so libsqlplus.so

../network:
admin

../network/admin:
listener.ora shrept.lst sqlnet.ora tnsnames.ora


I think maybe you should delete your oracle client directory and start
over from source. you might want to follow this thread:

http://groups.google.com/group/perl.dbi.users/browse_frm/thr ead/f8aa4db3c1172fe0/c55a0b9cdb0a76d9?q=jay+strauss&rnum=3&h l=en#c55a0b9cdb0a76d9

Jay