in reply to issue with dbd-oracle installation on win32

This I downloaded from cpan
No, ActiveState :)
DBD-Oracle-1.17.zip unpacks into DBD-Oracle-1.17.tar.gz and DBD-Oracle.ppd. DBD-Oracle-1.17.tar.gz unpacks into 
blib/
blib/lib/
blib/lib/DBD/
blib/lib/DBD/.exists
blib/lib/DBD/Oracle/
blib/lib/DBD/Oracle/GetInfo.pm
blib/lib/DBD/Oracle.pm
blib/lib/auto/
blib/lib/auto/DBD/
blib/lib/auto/DBD/Oracle/
blib/lib/auto/DBD/Oracle/.exists
blib/lib/Oraperl.pm
blib/lib/oraperl.ph
blib/arch/
blib/arch/auto/
blib/arch/auto/DBD/
blib/arch/auto/DBD/Oracle/
blib/arch/auto/DBD/Oracle/dbdimp.h
blib/arch/auto/DBD/Oracle/mk.pm
blib/arch/auto/DBD/Oracle/.exists
blib/arch/auto/DBD/Oracle/Oracle.h
blib/arch/auto/DBD/Oracle/Oracle.bs
blib/arch/auto/DBD/Oracle/ocitrace.h
blib/arch/auto/DBD/Oracle/Oracle.dll
blib/arch/auto/DBD/Oracle/Oracle.exp
blib/arch/auto/DBD/Oracle/Oracle.lib
blib/arch/auto/DBD/Oracle/Oracle.pdb
blib/script/
blib/script/ora_explain.bat
blib/script/.exists
blib/script/ora_explain
ioic
oracle-instant-client/
oracle-instant-client/LICENSE
oracle-instant-client/i686-linux-thread-multi/
oracle-instant-client/MSWin32-x86-multi-thread/
oracle-instant-client/MSWin32-x86-multi-thread/MD5SUM
oracle-instant-client/MSWin32-x86-multi-thread/install.lst
oracle-instant-client/MSWin32-x86-multi-thread/oci.dll
oracle-instant-client/MSWin32-x86-multi-thread/oraociei10.dll

[download]
What you're supposed to do is 
D:\>ppm install D:\DBD-Oracle.ppd

[download]
or 
D:\>ppm
PPM interactive shell (2.1.6) - type 'help' for available commands.
PPM>
PPM>ppm install D:\DBD-Oracle.ppd

[download]
but doesn't seem to work as intended (it still tries to download files from http://ppm.activestate.com/libs/oracle-instant-client because oracle-instant-client gets deleted before ioic is finished).

So what you can do is unpack DBD-Oracle-1.17.tar.gz (ptar -zxvf DBD-Oracle-1.17.tar.gz), and cd to where ioic resides, and run perl ioic. Then run ppm install DBD-Oracle.ppd but this time when prompted by ioic Do you accept the terms of this license ? (y/n) :, chose n , so it won't try to download again.

Replies are listed 'Best First'.
Re^2: issue with dbd-oracle installation on win32
by Anonymous Monk on Jan 28, 2009 at 21:30 UTC
    I tried to follow your steps.
    downloaded zip file and extracted DBD-Oracle-1.17.tar.gz and DBD-Oracle.ppd.
    I put the ppd file in c:\Perl\install-folder\Perl and .gz in c:\Perl\install-folder\Perl\MSWin32-x86-multi-thread-5.8.
    Then I extracted all the files from DBD-Oracle-1.17.tar.gz using winzip. and then ran "perl ioic" from this folder.
    It then gave me this error 
    C:\Perl\install-folder\Perl\MSWin32-x86-multi-thread-5.8>perl ioic
Oracle url = http://ppm.activestate.com/libs/oracle-instant-client/MSW
+in32-x86-multi-thread
Oracle_url=http://ppm.activestate.com/libs/oracle-instant-client/MSWin
+32-x86-multi-thread
$VAR1 = undef;
There is no oracle client libraries currently available for your platf
+orm (MSWin32-x86-multi-thread) in http://ppm.activestate.com/libs/ora
+cle-instant-client at
 ioic line 38.

    [download]

    I have oracle client installed on the xp machine, though.
[reply]
[d/l]
      Try again, but this time don't move the files around.

      I have oracle client installed on the xp machine, though.
      Then why are you messing with ioic?

[reply]
        well, I have the oracle 10.2.03 client installed on the machine. (that's what I meant by , oracle client is installed)
        Now I am able to install the DBD::ORACLE module. Thanks for the help. But I have new set of problems.
        I am trying to run the perl script and it is throwing new set of errors.(given below) 
        
"The procedure entry point Perl_Glookhook_ptr could not be located in 
+the dynamic link library perl58.dll"

install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/O
+racle/Oracle.dll' for module DBD::Oracle: load_file:The specified pro
+cedure could not be found at C:/Perl/lib/DynaLoader.pm line 230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d  at db_access_pr.prl line 2

        [download]
        I have added Oracle's 10.0.2 bin dir to PATH variable in the machine . Also I have setup ORACLE_HOME environment variable to point to this bin directory.
[reply]
[d/l]

In Section Seekers of Perl Wisdom