Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I am trying to install DBD-oracle after installing activestate perl 5.8.4 and dbi 1.6 and dbd-odbc 1.15 in XP pro desktop. Now when I install dbd-oracle 1.17 I am getting this error 
C:\Perl>ppm install DBD-Oracle.ppd
====================
Install 'DBD-Oracle' version 1.17 in ActivePerl 5.8.4.810.
====================
Can't locate ./ioic in @INC (@INC contains: C:/Perl/lib C:/Perl/site/l
+ib .) at install_script line 1.
Can't remove directory C:\TEMP/DBD-Oracle-1-3228-1233069831: Permissio
+n denied at C:/Perl/site/lib/PPM/Repository.pm line 247
Error: system() returned non-zero value (512): 'C:\Perl\bin\perl.exe i
+nstall_script'

[download]
the ppd file is attached below 

<?xml version="1.0" encoding="utf-8"?>
<SOFTPKG NAME="DBD-Oracle" VERSION="1,17,0,0">
  <TITLE>DBD-Oracle</TITLE>
  <ABSTRACT>Oracle database driver for the DBI module</ABSTRACT>
  <AUTHOR>Tim Bunce (dbi-users@perl.org)</AUTHOR>
  <IMPLEMENTATION>
    <DEPENDENCY NAME="DBI" VERSION="0,0,0,0" />
    <ARCHITECTURE NAME="MSWin32-x86-multi-thread-5.8" />
    <OS NAME="MSWin32" />
    <INSTALL EXEC="PPM_PERL">require("./ioic")</INSTALL>
    <CODEBASE HREF="DBD-Oracle-1.17.tar.gz" />
  </IMPLEMENTATION>
  <IMPLEMENTATION>
    <DEPENDENCY NAME="DBI" VERSION="0,0,0,0" />
    <ARCHITECTURE NAME="i686-linux-thread-multi-5.8" />
    <OS NAME="Linux" />
    <INSTALL EXEC="PPM_PERL">require("./ioic")</INSTALL>
    <CODEBASE HREF="DBD-Oracle-1.17.tar.gz" />
  </IMPLEMENTATION>
</SOFTPKG>

[download]
This I downloaded from cpan. I removed the linux part and ran only the win32 part in the above file.
I don't have internet access from this machine , so have to install in standalone mode.
Any suggestions??

Replies are listed 'Best First'.
Re: issue with dbd-oracle installation on win32
by Anonymous Monk on Jan 28, 2009 at 09:30 UTC
    Read more... (2 kB)
    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.

[reply]
[d/l]
[select]
      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]

Back to Seekers of Perl Wisdom