Re: DBD::Oracle for Oracle instantclient 10
- From: me@xxxxxxxxxx (Jay Strauss)
- Date: Sat, 22 Oct 2005 08:54:30 -0500
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 .
- Prev by Date: Frustrated with do()
- Next by Date: Remote Login, using dbi:ODBC
- Previous by thread: Frustrated with do()
- Next by thread: Remote Login, using dbi:ODBC
- Index(es):
Relevant Pages
|
|
