So 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 âdbd_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 âdbd_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 âfetch_func_varfieldâ:
oci8.c:534: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:536: warning: unused variable âimp_drhâ
oci8.c: In function âfetch_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 âfetch_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 âdbd_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: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:799: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:799: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:804: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:804: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:814: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:815: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:820: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:820: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:820: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c: In function âora_blob_read_pieceâ:
oci8.c:966: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:966: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:966: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:973: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:973: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1014: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1015: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1025: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1025: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1025: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1029: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1030: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1044: warning: dereferencing type-punned pointer will break
strict-aliasing rules
oci8.c:1045: warning: dereferencing type-punned pointer will break
strict-aliasing rules
/
/Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/10.2.0.3/client/lib" cc -shared
-L/usr/local/lib Oracle.o dbdimp.o oci8.o -o
blib/arch/auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/10.2.0.3/client/lib -lclntsh -lnnz10
-locci -lociei -locijdbc10 \
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/ora_explain
Manifying blib/man1/ora_explain.1p
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" Makefile-instantclient.PL
Makefile-instantclient
Using DBI 1.53 (for perl 5.008008 on i486-linux-gnu-thread-multi)
installed in /usr/lib/perl5/auto/DBI/
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
/
after *make install* and getting/testing the test_dbd_oracle.pl
I get:
/pascal:~/.cpan/build/DBD-Oracle-1.19# *perl test_dbd_oracle.pl*
Can't load '/usr/local/lib/perl/5.8.8/auto/DBD/Oracle/Oracle.so' for
module DBD::Oracle: libstdc++.so.5: cannot open shared object file:
No such file or directory at /usr/lib/perl/5.8/DynaLoader.pm line 225.
at test_dbd_oracle.pl line 12
Compilation failed in require at test_dbd_oracle.pl line 12.
BEGIN failed--compilation aborted at test_dbd_oracle.pl line 12.
/
I am using recipie from
http://jeanchristophe.duber.free.fr/dbd_oracle_instantclient_linux/ as
suggested by Eugene
Any help or pointers in my direction would help greatly!
Thanks,
Toby
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
Hi,
