DBD-Oracle-1.74 installation fails

[Digioso]

Hi Monks, I have a Windows system with Windows Server 2008 R2, a xampp-1.8.3-3 webserver and an Oracle 11gR2 Client.
I also installed MingW, downloaded dmake and the Basic GNU Utilities.

Currently I am using MySQL for the database of my application but I want to switch to an Oracle database on a remote system. Therefore I'm trying to install the DBD::Oracle Module .

My main problem is that the server does not have any internet connectivity so I cannot use cpan to download and install it automatically.

Following the instructions step 1 (perl Makefile.PL LINKTYPE=static) works fine. Step2 (just use make or in my case dmake) also works fine. But step 3 (make perl or in make case dmake perl) fails with the below error.
I checked whether the file C:\Users\adm-janssen\Desktop\DBD-Oracle-1.74\blib\arch\auto\DBD\Oracle\extralibs.all exists or not and I can see it where it is supposed to be. So... why do I get this error? Thanks a lot. :)

C:\Users\adm-janssen\Desktop\DBD-Oracle-1.74>dmake.exe perl
...
...
lots of output
...
...

C:\xampp\perl\lib/CORE/libperl.a `cat blib\arch\auto\DBD\Oracle/extral
+ibs.all` -
lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32 -ladvapi32
+ -lshell32
 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lwinmm -lversion
+ -lodbc32
-lodbccp32 -lcomctl32
gcc: error: `cat: No such file or directory
gcc: error: blib\arch\auto\DBD\Oracle/extralibs.all`: No such file or 
+directory
dmake:  Error code 129, while making 'perl'
dmake.exe:  Error code 255, while making 'perl'

[jellisii2]

I'd postulate one of two things: Either the system doesn't know where cat is, or the path for the file it's trying to access may be borked due to the mixed directory separators.

[Anonymous Monk]

I'd postulate one of two things: Either the system doesn't know where cat is, or the path for the file it's trying to access may be borked due to the mixed directory separators.

I'd say there should be no `cat` nowhere nohow, so all the missing details that are missing are important :)

[Anonymous Monk]

FWIW, http://strawberryperl.com 5.20 comes with DBD::Oracle

[bulrush]

On Linux you have to be su to install packages, or use sudo. Does your Windows user have admin privileges?

gcc: error: `cat: No such file or directory

Possibly 'cat' is not in your path.

gcc: error: blib\arch\auto\DBD\Oracle/extralibs.all`: No such file or 
++directory

Possibly the extralibs.all file is not in your path.

[Anonymous Monk]

Possibly 'cat' is not in your path.

Why would gcc need a `cat` file in the path? Because it wouldn't you know

[Anonymous Monk]

It would appear that a wrong shell is invoked, one that does not recognize the backtick syntax. Try passing SHELL=bash.exe to dmake, see if that makes a difference?

[Anonymous Monk]

It would appear that a wrong shell is invoked, one that does not recognize the backtick syntax. Try passing SHELL=bash.exe to dmake, see if that makes a difference?

Um, no , where would bash.exe come from?

Just set some %vars% and give Makefile.PL someargs like you're supposed to ... see DBD::Oracle::Troubleshooting::Win32 http://search.cpan.org/dist/DBD-Oracle/Makefile.PL

[Digioso]

Thanks for the answers all.
I am trying to compile on Windows Server 2008 R2. No Linux, no sudo, no cat, no bash or any other Linux/Unix commands/shells.

And yes, I have administrative rights on that server and I am using the Administrator command prompt.

I overwrote the existing Perl installation with Strawberry 5.20 to have a current release. But it doesn't have a compiled DBD-Oracle either. It would be weird if it did. Because... how would some other guy know where my Oracle client has been installed?

I installed .net 1.1 and all the other stuff from the links above. After downloading some libraries from the internet or copying them from the server (eg OCI.dll) to the Perl/bin directory I now seem to be having a compiled Oracle.dll file. But...

install_driver(Oracle) failed: Can't load 'C:/xampp/perl/site/lib/auto
+/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:%1 is not a
+ valid Win32 application at C:/xampp/perl/lib/DynaLoader.pm line 190.
 at (eval 8) line 3.
Compilation failed in require at (eval 8) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d
 at C:/xampp/libs/DB.pm line 34.


Looks like the file is corrupt... dmake test failed as well. nmake doesn't work because I'm on Windows x64 and there's no x64 nmake unless you install Visual Studio.
The file C:/xampp/perl/site/lib/auto/DBD/Oracle/Oracle.dll does exist. xampp Perl (and my installed Strawberry Perl) are 32bit anyway.