DBD::Oracle 1.19 with Oracle instantclient 10.2.0.3
I wanted to contribute my experience with the compilation of DBD::Oracle 1.19 with the Oracle InstantClient 10.2.0.3 on Debian Etch.
I mainly followed the guide on http://jeanchristophe.duber.free.fr/dbd_oracle_instantclient_linux/
That documentation is based on an older Oracle InstantClient v10.1.0.3, so I had to make some modifications...
I will quickly point out my steps:
- Download DBD::Oracle (http://search.cpan.org/CPAN/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.19.tar.gz)
- Download Oracle InstantClient 10.2.0.3 (http://www.oracle.com/technology/software/tech/oci/instan...Make error: DBD-Oracle-1.14 , DBI-1.39, Oracle rdbms 184.108.40.206.0 , solaris 9
When I make DBD-Oracle 1.14 , Makefile.PL generates a Makefile with "-o
build" in the compiler string before blib/arch/auto/DBD/Oracle/Oracle.so and
prevents Oracle.so from being built correctly.
demo_rdbms.mk appears to be to supplying this:
Attempting to discover Oracle OCI build rules^M
gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c^M
by executing: (make -f
ild ECHODO=echo EC...DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
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
I have several times installed DBD::Oracle 1.19 on Debian Etch without
an...DBD::Oracle 1.19 tests core against Oracle 10.2.0.1
I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core
files during the test phase. I've tried all the hints suggested in both
the README and README.help.txt files with the same result. Any
# uname -a
SunOS carnivore 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-V240
# perl Makefile.PL -v
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi-64int)
installed in /opt/VRTSperl/lib/site
Configuring DBD::Oracle for perl 5.008008 on ...DBD::Oracle 1.16 on OSX 10.3 running Oracle 10.1 (ORA 00600 error)
As described in the subject, I'm getting an ORA-00600 error. It is =
intermittent (happening about 50%) of the time and is not
dependent on having a long datatype in the table I'm selecting from. The =
actual error is:
DBD::Oracle::st execute failed: ORA-00600: internal error code,
arguments: [kpofdr-long], , , , , , , 
which I get on doing various types of select statements.
I believe this is a bug in Oracle 10.1 (Oracle bug note 3612581.8) . The =
problem here is that Oracle 10 release 2 may not be released for a few =
months. And there is no...[dbd-oracle-1.19] Problem with Makefile.PL & Oracle XE 10.2.0
I got errors when compiling dbd-oracle-1.19.
My server is running Linux Mandriva 2007 + Oracle Database 10g Express
Edition with Perl 5.8.8 and DBI 1.52.
Bellow you will find some more informations :
* uname -a
* perl -V
* perl Makefile.PL
* make test
* make install
Thanks for your help,
[root@oranux DBD-Oracle-1.19]# uname -a
Linux oranux 2.6.17-5mdv #1 SMP Wed Sep 13 14:32:31 EDT 2006 i686 Intel(R)
Pentium(R) M processor 2.00GHz GNU/Linux
===============...EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
I'm having some problems in this configuration on Windows
I am developing websites on an Oracle database (8.1.7), with
EAServer 5.3.0 (build 53016), Java objects using JSP as a
Here is my problem, I have a table with 2 VARCHAR2(4000),
and when I access the webpage, the they are displayed as
'?????????????'. If I debug the PB component, when I affect
the DW field to a variable, it displays it as it doesn't
"understand" a thing (each character is replaced by a
The codeset of EAServer is UTF8, and on my client, it is
AM...Re: DBD::Oracle doesn't work with Oracle 10g (10.1.0.3) under Mac OS X (10.3.8) or how to make it working?
Hermez, et al,
On Apr 9, 2005, Hermez <4Hertz@gmx.de> wrote:
> After painful days and nights, trying to make DBD::Oracle working
> with Oracle 10g Release 1 (10.1.0.3) on Mac OS X, I am at my wits'
> I have started the hard trip with the Oracle instant client and even
> the above mentioned full version doesn't lead to a solution.
> Afterwards, I have followed the advice mentioned in README.macosx
> (included in DBD::Oracle), and installed Perl from scratch. Without
> progress, unfortunately.
> Let me describe the affected envir...DBD::Oracle 1.12 on Oracle 9iR2 220.127.116.11 test errors
I am having some problems testing DBD-Oracle-1.12 in the following
Compilation is fine.
Output from test stage is:
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/long.......Unexpectedly had to drop old test table 'dbd_ora__drop_me'
t/long.......ok 97/143Use of uninitialized value in numeric eq (==) at
t/long.t line 230.
# failed test 98 at line 230...DBD::Oracle 1.12 on Oracle 9iR2 18.104.22.168 test errors (again)
I am still not having any luck in getting the tests to pass. It appears to
be the CLOB re-reading that is failing.
I have checked all the usual places for help. I have also tried creating a
test stub that does a similar thing to the failed tests.
Below is the full set of information from the build and test as requested
(note this is long).
Anyone any ideas?
> perl Makefile.PL -v
Using DBI 1.32 installed in
Duplicate specification "S=s" for option "s"
Configuring D...Oracle 10.1.0.2, RedHat AS, and DBD::Oracle
We got a fancy new RedHat AS server here at work, and our Sys Admin
installed the Oracle 10.1.0.2 client on it (although the Oracle server
is running version "Oracle8i Release 22.214.171.124.0"). SQL*Plus seems to
work fine for connecting to our Oracle servers, despite the version
I was attempting to install DBD::Oracle on this machine and, as you
might expect, ran into a few problems.
I guess my first question is: Should I even try to install DBD::Oracle
(v 1.15) with Oracle 10.1.0.2 on RedHat AS? My sense of the situation
is that this version of Oracle is too re...DBD::Oracle 1.19 using instantclient 10.1.0.5 crashes under mod_perl
I am experiencing a problem with DBD::Oracle 1.19, when building
against the Oracle "Instant Client" libraries version 10.1.0.5,
with perl 5.8.8 on an Ubuntu "Edgy Eft" system.
Everything works correctly when i use DBD::Oracle in perl scripts
executed by /usr/bin/perl. However, when i attempt to run this
same code from apache-mod_perl, apache crashes.
I am using the distro's apache:
$ /usr/sbin/apache -V
Server version: Apache/1.3.34 (Ubuntu)
Server built: Oct 25 2006 09:16:15
Server's Module Magic Number: 19990320:18
Server compiled wit...Oracle Instant Client 10.1.0.3 SDK and DBD::Oracle
The latest patch set (10.1.0.3) for the Oracle Instant Client 10g includes
the long awaited SDK.
I had a quick look at it, and it seems Oracle decided to put the header =
in the traditional /usr/include and /usr/share directories. This won't =
out of the box with DBD::Oracle, as it's tuned to having the header files
available relative to $ORACLE_HOME.
These are the current locations of the library and header files for the
Instant Client 10g:
[###### oic]$ rpm -q -l -p oracle-instantclient-basic-10.1.0.3-1.i386.rpm
/usr/lib/oracle/10.1.0.3/client/lib/c...building DBD-Oracle-1.14 on Windows 2000 with Oracle 126.96.36.199.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
I'm trying to build DBD-Oracle-1.14 on a Windows 2000 machine with
Oracle 188.8.131.52.0 Standard installed. I should also point out that I'm
working within a unix environment (a product called Microsoft Windows
Services for Unix) which runs under Windows and I'm trying to install
DBD into the perl that came with the unix environment. I don't believe
the unix environment under Windows has anything to do with my problems