Re: Oracle.dll load Failure V5.8.1

From: David N Murray (dmurray_at_jsbsystems.com)
Date: 12/30/03 

Date: Mon, 29 Dec 2003 20:52:30 -0500 (EST)
To: "Capacio, Paula J" <PCAPACIO@amfam.com>

I got this same error and have seen others post with the same problem. I
d/l'd the whole oracle kit (dbd-oracle-1.14, from cpan) and built it on my
machine, and it works fine (DBI doesn't have any .dll dependencies that
I'm aware of). I have the full oracle 8.1.4 client installed, MSVC 6 SP3,
and perl 5.8.2 build 808 (ActiveState) on XP Pro. The commands I used (in
a command window) were: vcvars32.bat (configures command-line MSVC
environment), perl Makefile.pl (complained about not being able to find
Oracle headers), nmake (worked despite prev warning), nmake install.

If someone has some info on how I can bundle this up, I'd be happy to do
it. My concern is with the various pieces that I used, however. I don't
really have access to any other Oracle clients and I don't know what the
DLL hell would look like if I tried to ship this.

Dave

On Dec 29, Capacio, Paula J scribed:

> 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: MS02-018 Breaking ASP ODBC
    ... > after installing the latest security hotfixes as of April ... >>1) IIS 5 web server can't be contacted. ... >>before the patch and that fixed that problem. ... >>load some VB components that fail to connect to my Oracle ...
    (microsoft.public.inetserver.iis.security)
  • Re: was(can someone please explain what this blog tagging this is all about?), now, happy NY!
    ... Someone puts out a video of Oracle being "instantly" ... installing 10.2 base, then installing 10.2.0.3 on top of it ... meme propagation allows corrective feedback, ... In the traditional scientific community, ...
    (comp.databases.oracle.server)
  • was(can someone please explain what this blog tagging this is all about?), now, happy NY!
    ... Someone puts out a video of Oracle being "instantly" ... installing 10.2 base, then installing 10.2.0.3 on top of it ... While I'm here and on the subject of aggregators and ... next time I'm taking a shorter holiday! ...
    (comp.databases.oracle.server)
  • Re: How many names and addresses can you have for ID card
    ... Think command line only (except when you're installing, ... which is unsettling to we Linux users. ... This is NOTHING to do with Oracle though. ...
    (uk.legal)
  • Re: Possible Feature
    ... As interesting as that code snippet was I don't see the relevance to my ... against column datatypes. ... Rather than reinventing the wheel why not copy what Oracle many years ... TYPE myarray IS TABLE OF parent%ROWTYPE; l_data myarray; ...
    (comp.databases.informix)