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/auto/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/thread/f8aa4db3c1172fe0/c55a0b9cdb0a76d9?q=jay+strauss&rnum=3&hl=en#c55a0b9cdb0a76d9

Jay
.

Relevant Pages

  • Re: DBI 1.45 and perl 5.8.2 - bug 24463
    ... > threads and debugging enabled which causes a DBI test to fail. ... The perl bug is in thread creation and unrelated to the DBI. ... Configuring both is even worse. ...
    (perl.dbi.users)
  • Re: Perl 6 DBI API ideas
    ... Though I didn't raise my hand when you asked for people to contribute to a DBI module for Perl 6, I've had some ideas that I thought about sharing. ... I would also love to see some standardization on the driver names ("mysql" when it's normally written ... DBI is supposed to be query language agnostic, even if SQL is the most commonly used group of languages, and if a user can declare this explicitly, it saves the driver from having to guess what they were given, which might be ambiguous. ...
    (perl.dbi.users)
  • Problem of DBI build
    ... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
    (perl.dbi.users)
  • Problem of DBI build
    ... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
    (perl.dbi.users)
  • Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
    ... T> expected a mature library like DBI to behave like this. ... I learned plenty about the perl side of things from her posts. ... closely represent the SQL idea of a null. ... trivially easy to perform bulk loads using the DB's particular ...
    (comp.lang.perl.misc)