Thread

[ home | FAQ | about | stats | new post | login | register | tags ]
Attend the Test automation using Perl master class on 19-20 June in Chicago, IL. Just after YAPC::NA

DBD-Oracle [search.cpan.org] [Kobes search] [View and report bugs] [Ratings 3.5 (13) ]
[AnnoCPAN] [CPAN Tests results] [CPANTS]
Posted on Thu Mar 8 14:16:41 2007 by tobstar
DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install
Hi,

I am having a problem setting up DBD::Oracle version 1.19 on a Debian Etch. I am running perl 5.8.8 and have dbi 1.53 (I believe) installed. I have instantclient-basic, instantclient-devel, and sqlplus installed. I can, without a problem, connect to my external DB Server via sqlplus. I have ORACLE_HOME and LD_LIB path set everything works great, and I am user root.

I have several times installed DBD::Oracle 1.19 on Debian Etch without any problem, BUT only with a FULL Oracle client. The installer needs x-server and I don't want an x on this server, nor do I want a full oracle client installed.

It just won't work with the inst client.

I am a total noobie to dbi and perl so bare with me!

I have this error, and I know that there are some fixes, but they all seem to be for older DBD:Oracle Makefiles.

Using Oracle in /usr/lib/oracle/10.2.0.3/client DEFINE _SQLPLUS_RELEASE = "1002000300" (CHAR) Oracle version 10.2.0.3 (10.2) Unable to locate an oracle.mk, proc.mk or other suitable *.mk file in your Oracle installation. (I looked in /usr/lib/oracle/10.2.0.3/client/rdbms/demo/demo_xe.mk /usr/lib/oracle/10.2.0.3/client/rdbms +/lib/oracle.mk /usr/lib/oracle/10.2.0.3/client/rdbms/demo/oracle.mk /usr/lib/oracle/10.2.0.3/clien +t/rdbms/demo/demo_rdbms.mk /usr/lib/oracle/10.2.0.3/client/precomp/demo/proc/proc.mk /usr/lib/orac +le/10.2.0.3/client/precomp/demo/proc/demo_proc.mk /usr/lib/oracle/10.2.0.3/client/proc/lib/proc.mk + /usr/lib/oracle/10.2.0.3/client/proc16/lib/proc16.mk under /usr/lib/oracle/10.2.0.3/client) The oracle.mk (or demo_rdbms.mk) file is part of the Oracle RDBMS product. The proc.mk (or demo_proc.mk) file is part of the Oracle Pro*C product. You need to build DBD::Oracle on a system which has one of these Oracle components installed. (Other *.mk files such as the env_*.mk files will not work.) Alternatively you can use Oracle Instant Client.

I also have tried: perl Makefile.PL -m /usr/share/oracle/10.2.0.3/client/demo.mk
which is the only mk file that instant client provides.

It also gives me a makefile for DBD::Oracle but install and test fail utterly.

Can anybody point me in a direction what I should do. Any pointers to reciepies how to get this baby working. Really appreciate your time and effort.

Greets,
tm
Direct Responses: 6211 | Write a response
Posted on Wed Oct 10 00:25:57 2007 by mralexk in response to 4510
Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3
Have you found the solution yet? I have similar problem and will appreciate if you could share your ideas.
Direct Responses: 6214 | Write a response
Posted on Wed Oct 10 13:41:20 2007 by byterock in response to 6211
Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3
You would be much better off posting your question to dbi-users@perl.org (you don't need to subscribe in order to post) and you won't be automatically subscribed either. Very few people actully use or view this form for dbi or driver support. dbi-users is where you'll get the best support Ad for your problem you most likely have to make a symbolic link to the .so file like this
libclntsh.so -> \export/home\10g\instantclient_10_2\libclntsh.so.10.1
Write a response
[ home | FAQ | about | stats | new post | login | register | tags ]
Attend the Test automation using Perl master class on 19-20 June in Chicago, IL. Just after YAPC::NA
Service launched on 2nd of February 2005.
Comments, and other submissions on CPAN Forum are Copyright 2005-2007, their respective owners.
Site maintainer is not responsible for content. Privacy Policy
Maintained and hosted by Gabor Szabo at Perl Training Israel
See also World Wide Perl Training