(Fwd) DBD-Oracle-1.16 Makefile.PL error

From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 11/14/04


Date: Sun, 14 Nov 2004 11:53:01 +0000
To: dbi-users@perl.org


----- Forwarded message from "Wikander, Ronald J" <Ronald.J.Wikander@bankofamerica.com> -----

Delivered-To: tim.bunce@pobox.com
X-SPF-Guess: pass (seems reasonable for Ronald.J.Wikander@bankofamerica.com to mail through 171.159.192.79)
X-Pobox-Antispam: Bad HELO hostname returned DENY: no A or MX records found for vadmzmailmx02.bankofamerica.com
Date: Sat, 13 Nov 2004 18:46:37 -0500
From: "Wikander, Ronald J" <Ronald.J.Wikander@bankofamerica.com>
Subject: DBD-Oracle-1.16 Makefile.PL error
To: Tim.Bunce@pobox.com
X-OriginalArrivalTime: 13 Nov 2004 23:46:37.0901 (UTC) FILETIME=[0437E7D0:01C4C9DB]

I am running perl5.8.5, DBI-1.45 and DBD-Oracle-1.16, perl was installed via sunfreeware package and DBI seemed to install without any problems.
I am however having issues with DBD, this is the first time I am installing it, so I am not sure if I am missing prerequisites. See below for more info.

HOSTNAME# perl -V
Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
  Platform:
    osname=solaris, osvers=2.8, archname=sun4-solaris
    uname='sunos 5.8 generic_108528-11 sun4u sparc sunw,ultra-5_10 '
    config_args='-Dcc=gcc -B/usr/ccs/bin/'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='gcc -B/usr/ccs/bin/', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
    optimize='-O',
    cppflags='-fno-strict-aliasing -pipe -I/usr/local/include'
    ccversion='', gccversion='3.3.2', gccosandvers='solaris2.8'
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='gcc -B/usr/ccs/bin/', ldflags =' -L/usr/local/lib '
    libpth=/usr/local/lib /usr/lib /usr/ccs/lib
    libs=-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc
    perllibs=-lsocket -lnsl -ldl -lm -lc
    libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
    cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'

Characteristics of this binary (from libperl):
  Compile-time options: USE_LARGE_FILES
  Built under solaris
  Compiled at Jul 26 2004 05:02:51
  @INC:
    /usr/local/lib/perl5/5.8.5/sun4-solaris
    /usr/local/lib/perl5/5.8.5
    /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris
    /usr/local/lib/perl5/site_perl/5.8.5
    /usr/local/lib/perl5/site_perl
    .
-------------------------------------------------------------------------------------------------------

I received the following message when running 'perl Makefile.PL';
DBI object version 1.45 does not match $DBI::VERSION 1.15

I tried updating the DBI.pm file and changing the version from 1.15 to 1.45, no more errors received regarding version mismatch.
So now when I run the 'perl Makefile.PL I receive the following;

nyrskdap5# perl Makefile.PL
Subroutine fetchrow_hashref redefined at /usr/local/lib/perl5/5.8.5/sun4-solaris/DBI.pm line 1118.
Using DBI 1.45 (for perl 5.008005 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/

 Configuring DBD::Oracle ...

>>> Remember to actually *READ* the README file!
        Especially if you have any problems.

  The ORACLE_HOME environment variable must be set.
  It must be set to hold the path to an Oracle installation directory
  on this machine (or a machine with a compatible architecture).
  See the README.clients file for more information.
  ABORTED!

I am assuming that the DBAs need to adjust the ORACLE_HOME variable but just need confirmation.
Please let me know your thoughts, thanks in advance.

Ronald--

----- End forwarded message -----



Relevant Pages

  • ANNOUNCE: UnixODBC 0.31
    ... UnixODBC provides a toolkit for writing Perl ODBC clients. ... - Installing and Configuring the Bridge Server ... UnixODBC.pm provides Perl programs with a subset of the X/Open ... Bridge Server," below. ...
    (comp.lang.perl.modules)
  • Re: Unix commands
    ... might have a problem or two with installing some CPAN modules as well. ... Skilled programmers are able to see the ... Then their problem already starts with using Perl on Windows (for ... Most external tools have switches that enable / disable features. ...
    (comp.lang.perl.misc)
  • Source Code Control and Naming ThingiePoo was Re: Starting Perl
    ... > I need to fix them). ... why not treat your 'perl code' like as if it were RealCode? ... Makefile.PL that will simplify installing the Perl Module in the ...
    (perl.beginners)
  • Re: Win32::TieRegistry problem
    ... Not only am I limited by the perl ... >> installing a CPAN module is not allowed by my client (meaning the ... >> writing is a script to verify the installation of Rational Clearcase ...
    (comp.lang.perl.modules)
  • Re: Installing DBI
    ... Perl is working great. ... had no problem installing PERL on my own windows laptop. ... I would double check your download, your copy, and your gunzip before ...
    (perl.beginners)