Oracle.dll load Failure V5.8.1

From: Paula J Capacio (PCAPACIO_at_amfam.com)
Date: 12/29/03


Date: Mon, 29 Dec 2003 16:03:38 -0600
To: <dbi-users@perl.org>

I just installed ActivePerl 5.8.1.807 on a WinXP box.
I downloaded and installed DBI 1.37 and DBD-Oracle 1.13 from
ftp.esoftmatic.com without incurring any errors.

However, when attempting to run this code:
#code snippet
use DBI;
$dbh = DBI->connect("dbi:Oracle:host=hxddba01;sid=mp3u", 'scott',
'tiger')
     or die "connect failed: $DBI::errstr\n";
print "If this prints...you are connected\n";
$dbh->disconnect;
#End of Code
I get a pop-up box titled: perl.exe - Entry Point Not Found
which states: The procedure entry point Perl_Glockhook_ptr could
not be located in the dynamic link library perl58.dll.
Must click OK, at which point the command window displays this error:

install_driver(Oracle) failed:
Can't load 'C:/Perl58/site/lib/auto/DBD/Oracle/Oracle.dll'
for module DBD::Oracle: load_file:
The specified procedure could not be
 found at C:/Perl58/lib/DynaLoader.pm line 229.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at u:\perl_info\oraconn_woTNSnames.pl line 2

I have tried copying the Oracle.dll to c:/perl58/bin --> didn't work.
Also tried adding C:/Perl58/site/lib/auto/DBD/Oracle
to my system PATH variable...no luck.

The Oracle client is installed and works correctly, via SQL*Plus.
Also ActivePerl5.6.1 Build 630 is installed in a separate directory
on this XP box, it has DBI 1.14 and DBD-Oracle 1.06 and works
perfectly with the code snippet above, so the problem has to be
with the installation of 5.8 and the modules.
Here's the PPM output from the module installs:
###PPM output###
Installing module DBI
        ====================
        Install 'DBI' version 1.37 in ActivePerl 5.8.1.807.
        ====================
        Successfully installed DBI version 1.37 in ActivePerl 5.8.1.807.
        Installing C:\Perl58\site\lib\auto\DBI\dbd_xsh.h
        Installing C:\Perl58\site\lib\auto\DBI\DBI.bs
        Installing C:\Perl58\site\lib\auto\DBI\DBI.dll
        Installing C:\Perl58\site\lib\auto\DBI\DBI.exp
        Installing C:\Perl58\site\lib\auto\DBI\DBI.lib
        Installing C:\Perl58\site\lib\auto\DBI\dbipport.h
        Installing C:\Perl58\site\lib\auto\DBI\DBIXS.h
        Installing C:\Perl58\site\lib\auto\DBI\dbi_sql.h
        Installing C:\Perl58\site\lib\auto\DBI\Driver.xst
        Installing C:\Perl58\site\lib\auto\DBI\Driver_xst.h
        Files found in blib\arch: installing files in blib\lib into
architecture dependent library tree
        Installing C:\Perl58\site\lib\DBI.pm
        Installing C:\Perl58\site\lib\Bundle\DBI.pm
        Installing C:\Perl58\site\lib\DBD\ExampleP.pm
        Installing C:\Perl58\site\lib\DBD\NullP.pm
        Installing C:\Perl58\site\lib\DBD\Proxy.pm
        Installing C:\Perl58\site\lib\DBD\Sponge.pm
        Installing C:\Perl58\site\lib\DBI\Changes.pm
        Installing C:\Perl58\site\lib\DBI\DBD.pm
        Installing C:\Perl58\site\lib\DBI\FAQ.pm
        Installing C:\Perl58\site\lib\DBI\Profile.pm
        Installing C:\Perl58\site\lib\DBI\ProfileData.pm
        Installing C:\Perl58\site\lib\DBI\ProfileDumper.pm
        Installing C:\Perl58\site\lib\DBI\ProxyServer.pm
        Installing C:\Perl58\site\lib\DBI\PurePerl.pm
        Installing C:\Perl58\site\lib\DBI\W32ODBC.pm
        Installing C:\Perl58\site\lib\DBI\Const\GetInfoReturn.pm
        Installing C:\Perl58\site\lib\DBI\Const\GetInfoType.pm
        Installing C:\Perl58\site\lib\DBI\Const\GetInfo\ANSI.pm
        Installing C:\Perl58\site\lib\DBI\Const\GetInfo\ODBC.pm
        Installing C:\Perl58\site\lib\DBI\DBD\Metadata.pm
        Installing C:\Perl58\site\lib\DBI\ProfileDumper\Apache.pm
        Installing C:\Perl58\site\lib\Win32\DBIODBC.pm
        Installing C:\Perl58\bin\dbiprof
        Installing C:\Perl58\bin\dbiprof.bat
        Installing C:\Perl58\bin\dbiproxy
        Installing C:\Perl58\bin\dbiproxy.bat

Installing module DBD-Oracle
        ====================
        Install 'DBD-Oracle' version 1.13 in ActivePerl 5.8.1.807.
        ====================
        Successfully installed DBD-Oracle version 1.13 in ActivePerl
5.8.1.807.
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\dbdimp.h
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\mk.pm
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\ocitrace.h
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.bs
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.dll
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.exp
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.h
        Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.lib
        Files found in blib\arch: installing files in blib\lib into
architecture dependent library tree
        Installing C:\Perl58\site\lib\oraperl.ph
        Installing C:\Perl58\site\lib\Oraperl.pm
        Installing C:\Perl58\site\lib\DBD\Oracle.pm
        Installing C:\Perl58\bin\ora_explain
        Installing C:\Perl58\bin\ora_explain.bat
###End of PPM###
Any help will be appreciated. Thanks in advance.



Relevant Pages

  • RE: problem installing DBD-mysql-2.9002 on OS X 10.2.8 (perl 5.8. 1)
    ... problem installing DBD-mysql-2.9002 on OS X 10.2.8 (perl ... Make absolutely sure DBI is installed where DBD::mysql can find it. ... Give a hobbit a ring and he eats fish for an age. ...
    (perl.dbi.users)
  • RE: installing DBI
    ... Subject: installing DBI ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • Re: Perl+DBI question [C1]
    ... I am trying to use DBI in my program, ... Can't we use PERL5LIB environment variable to specify non standard perl ... using PREFIX or similar incantation when building and installing. ...
    (perl.dbi.users)
  • Re: Problems while installing PERL (DBD::DB2 module)
    ... I was successful in installing the DBI module. ... But on installing the DBD module, i am facing the following errors ... dbdimp.h:18: warning: data definition has no type or storage class ...
    (perl.dbi.users)
  • Re: Installing Perl DBI and Oracle DBD in AIX 5.1
    ... I installed the Oracle DBI by following ... >> the perl DBI and oracle DBD in this machine. ... > discussion about installing DBI on AIX and with ...
    (perl.beginners)