Installing ora2pg in windows 10

[matul3jan]

I am trying to install Ora2Pg version 20 (lattest release) on windows 10.

Installed StrawberryPerl as well as ActivePerl.

1. Run perl Makefile.PL.
2. Run gmake: Error: to undefined at C:/Perl64/site/lib/ExtUtils/Install.pm line 141. makefile:938: recipe for target 'pm_to_blib' failed gmake: *** [pm_to_blib] Error 255

Please help!

[lio5]

Hello ronakjain03, I have the same error, with StrawberryPerl 5.32.0.1 and ActivePerl 5.28. Did you succeed to solve this issue ? If yes, what did you do ? Thanks

[matul3jan]

Nope, i did not find any solution.

[darold]

I don't know solution other that use Linux. Ora2Pg used to be supported on Windows but it look like installing on Windows 10 is much more complicated. I think I will completely remove the support for Windows plate-form and provide a Docker solution as a replacement.

[edelanoe]

Hi Darold,

We are using ora2pg 20 on windows 10 with success. Even if installing is subject to some errors, we have 80% successful installs in the end. I guess the 20% remaining are on PCs where security features are too strong. One of our envs has come from windows 7, migrated to windows 10, and still works. Our latest env has been installed on windows 10 from scratch. I'm currently collecting how this was successful. In the meanwhile, could you please reopen this issue (841) or any linked issue, enable mutual help on windows installs ? This would be greatly appreciated. Rgds, Eric

[darold]

Hi Eric, where gmake for Windows 10 can be found?

[edelanoe]

I have found it inside Strawberry Perl

[darold]

Ok, good to know. Saying that I'm not able to give a solution for the original error.

[edelanoe]

I think the original error comes from the particular stack installed on ronakjain03's PC. Let me give some stacks that have worked on our Windows 10's with ora2pg 20.0: strawberry-perl-5.24.1.1-64bit.msi ActivePerl-5.24.0.2400-MSWin32-x64-300558.exe One of the following Oracle Instant Client packs: Oracle InstantClient version 12.1.0.2 "basic" 64 bit Oracle InstantClient version 19.8.0.0 "basic package" 64 bit updating perl module DBD::Oracle using CPAN or ActivePerl ppm -> on cmd command line: "cpanm DBD::Oracle " -> on PowerShell: "perl -MCPAN -e 'install DBD::Oracle' " AND, most important: put the home of your Oracle InstantClient at the beginning of PATH env variable. for instance, "C:\app\client\oracle\product\12.2.0\instantclient_12_1"

[FL45H97]

Hello guys! I can serve with some details. Basically "cpanm DBD::Oracle" fails because it uses the dmake command which is deprecated since strawberry perl 5.26.

First install strawberry perl 5.24. (Use the default install directory) (Following this is tutorial is partly useful.) Just don't forget to set your ORACLE_HOME to the instantclient folder.

I've found this useful tutorial

You should clone their repository first, then run the install script

Please also check the documentation for configuration files, commands etc.

Hope it helps!

[Diginomicon]

I have recently installed ora2pg on Windows 10 and Windows Server 2016 servers, I found it was only necessary to install Strawberry Perl (64-bit version 5.32) in order to get the DBI::Oracle and DBI::Pg drivers pre-compiled and ready to use. The systems had the Oracle Client 12.1 installed on them and have worked without any further actions required to successfully connect to an Oracle 12c database and an Azure hosted PostgreSQL database. ActivePerl was not installed on any of the systems as it was not necessary.