DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

Post by tm » Fri, 09 Mar 2007 21:43:09


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
 
 
 

DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

Post by scole » Sat, 10 Mar 2007 00:08:43

On thing about the instant client is that it has to make a symbolic link to
compile correctly here

some thing like this

$ ln -s instantclient_10_2/libclntsh.so.10.1 libclntsh.so

If the user that is doing the compile doe not have permission to do this
link then you may get a failure like this.


----- Original Message -----
From: "tm" < XXXX@XXXXX.COM >
To: < XXXX@XXXXX.COM >
Sent: Thursday, March 08, 2007 7:43 AM
Subject: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch
won't install

 
 
 

DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

Post by ekrivdyu » Sat, 10 Mar 2007 02:26:47


I've successfully installed DBD::Oracle with instant client on Debian
etch two days ago. You may found this link useful:

http://www.yqcomputer.com/

--
WBR, Eugene Krivdyuk
 
 
 

DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

Post by tm » Sat, 10 Mar 2007 18:09:09

i John,
What are you suggesting? Currently all my Oracle inst client files are
user oracle group oinstall yet lib bin and other dirs have 755
permission so root should be able to access and execute these softlibs.
As I have written, I have installed DBD::Oracle-1.19 many times with a
full client without problem, yet with the limited instant client it does
not find the mk file, and the one mk file (namely demo.mk) that the
instant client installs does not work. So I don't think its a linker
problem. Thanks for the suggestion though!

I am compiling with user root.

Any other suggestions, or how to edit the DBD::Oracle-1.19 Makefile to
make it work without the .mk files?

Thanks for any help!

Toby

John Scoles schrieb:

 
 
 

DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

Post by tm » Sat, 10 Mar 2007 18:16:21

i Eugene,

I have seen this link before, yet I have tried the instructions (unfortunatly have not tried hard enough) on this site and I didn't get it to work due to my noobist knowledge :)

But if you say that it works, i give it another shot with these instructions. If I should hit a wall please help out, thanks!

Cheers,
Toby




 
 
 

DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

Post by tm » Sun, 11 Mar 2007 01:06:02

o I got it to make the makefile :)

/pascal:~/.cpan/build/DBD-Oracle-1.19# *perl Makefile-instantclient.PL*
Using DBI 1.53 (for perl 5.008008 on i486-linux-gnu-thread-multi)
installed in /usr/lib/perl5/auto/DBI/
Checking if your kit is complete...
Looks good
Using DBI 1.53 (for perl 5.008008 on i486-linux-gnu-thread-multi)
installed in /usr/lib/perl5/auto/DBI/
Writing Makefile for DBD::Oracle
pascal:~/.cpan/build/DBD-Oracle-1.19#/

but after that I am getting a lot of warnings, and I mean a lot of (here
is a snippet):

/
oci8.c: In function bd_phs_in
oci8.c:401: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:402: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c: In function bd_phs_out
oci8.c:472: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:483: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:484: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c: In function etch_func_varfield
oci8.c:534: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:536: warning: unused variable mp_drh oci8.c: In function etch_cleanup_rset
oci8.c:609: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:617: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:618: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:620: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c: In function etch_func_rset
oci8.c:633: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:639: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:640: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:642: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:652: warning: value computed is not used
oci8.c:657: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:658: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:660: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:665: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c: In function bd_rebind_ph_lob
oci8.c:734: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:734: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:737: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:737: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:748: warning: value computed is not used
oci8.c:765: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:765: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:779: warning: value computed is not used
oci8.c:787: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:787: war
 
 
 

DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

Post by ekrivdyu » Wed, 21 Mar 2007 01:01:41

2007/3/9, tm < XXXX@XXXXX.COM >:
[... skipped ...]

Just install libstdc++5 package and then reinstall DBD::Oracle.