?
Solved

Install DBD-Oracle on windows

Posted on 2010-01-09
12
Medium Priority
?
1,158 Views
Last Modified: 2013-12-11
Helllo,
I am trying to install Perl DBD-Oracle locally on my xp professional.
It has to be done locally because of firewall restrictions at my work place.
i followed the insructions on
http://www.experts-exchange.com/Programming/Languages/Scripting/Perl/Q_23145154.html?sfQueryTermInfo=1+dbd+instal+oracl+window
but could not make it work.
can any one provide me with the correct actions that needs to be done?
   where can i get the files from?
  what should i rename them to?
  should I un-zip them manually?
  what is the command that I need to run?
Many thanks for your help
Tamir
0
Comment
Question by:tamirmilo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 4
12 Comments
 
LVL 39

Expert Comment

by:Adam314
ID: 26274624
What version of perl?  I'll assume 5.8, because the post you refer is for 5.8.  If you have a different version, the steps would be the same, just download the appropriate files.
What distribution?  I'll assume ActiveState because of the tags.

Download this file, save it to C:\temp
    http://trouchelle.com/ppm/DBD-Oracle.ppd

Download this file, save it to C:\temp\MSWin32-x86-multi-thread-5.8
    http://trouchelle.com/ppm/MSWin32-x86-multi-thread-5.8/DBD-Oracle-1.19.zip

Start a command prompt.  Go to the C:\temp directory
    cd /d c:\temp

Install the module:
    ppm install DBD-Oracle.ppd
0
 

Author Comment

by:tamirmilo
ID: 26274645
Hi Adam,
On my laptop I have 5.6.1 , at work 5.8 and could not make it work on both. I will try now your solution.
Thank you.
0
 

Author Comment

by:tamirmilo
ID: 26274667
I have donwnloaded the xml and placed it at c:\temp\DBD-Oracle.xml
Download  DBD-Oracle-1.19  into c:|MSWin32-x86-multi-thread-5.8\DBD-Oracle-1.19

Run the command from c:\temp

Installing package 'DBD-Oracle.ppd'...
Error installing package 'DBD-Oracle.ppd': Could not locate a PPD file for package DBD-Oracle.ppd

What is wrong? many thanks
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:tamirmilo
ID: 26275133
Hi Again,
I have installed perl 5.10.1. Distribution - Active state instead of the old one.
I have saves file "DBD-Oracle.ppd" correctly.. as you requested with the name of c:temp\DBD-Oracle.ppd

Get the message:
ppm installed failed: The PPD does not provide  code to install for this platform.
Can you assist with that one as well?
Many thanks!
Tamir

0
 
LVL 39

Accepted Solution

by:
Adam314 earned 2000 total points
ID: 26275282
The file must be named "DBD-Oracle.ppd" not "DBD-Oracle.xml".  Make that change first.

Next, the zip file needs to be in C:\temp\MSWin32-x86-multi-thread-5.8\DBD-Oracle-1.19.zip, not C:\MSWin32-x86-multi-thread-5.8\DBD-Oracle-1.19.zip.
0
 
LVL 39

Expert Comment

by:Adam314
ID: 26275305
This file is for perl 5.8, not perl 5.10.  If you want to use perl 5.10, you will have to find an already compiled version of DBD::Oracle, or compile it yourself (much more difficult).  It will be easier to continue with perl 5.8.
0
 

Author Comment

by:tamirmilo
ID: 26275380
Hi,
Sorry for not being accurate.
Do you know a URL which I can I download the right version ?
Tamir
0
 
LVL 39

Expert Comment

by:Adam314
ID: 26275906
No.  The only I could find was for perl 5.8.
0
 

Author Comment

by:tamirmilo
ID: 26276631
Hi, I ment if you can please send me link to perl 5.8 and then I will use it along side the DBD-Oracle that you have send me initially.
Thx Adam
0
 

Author Comment

by:tamirmilo
ID: 26276740
Thank you
0
 

Author Closing Comment

by:tamirmilo
ID: 31674995
Thank you
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question