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

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'

[download]

Replies are listed 'Best First'.
Re: DBD-Oracle-1.74 installation fails
by jellisii2 (Hermit) on Aug 08, 2014 at 11:38 UTC
    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.
[reply]
[d/l]

      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 :)

[reply]
Re: DBD-Oracle-1.74 installation fails (strawberryperl 5.20)
by Anonymous Monk on Aug 08, 2014 at 18:10 UTC
[reply]
Re: DBD-Oracle-1.74 installation fails
by bulrush (Scribe) on Aug 09, 2014 at 11:52 UTC
    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

    [download]

    Possibly 'cat' is not in your path. 

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

    [download]

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

    Perl 5.8.8 on Redhat Linux RHEL 5.5.56 (64-bit)
[reply]
[d/l]
[select]

      Possibly 'cat' is not in your path.

      Why would gcc need a `cat` file in the path? Because it wouldn't you know
[reply]
Re: DBD-Oracle-1.74 installation fails
by Anonymous Monk on Aug 09, 2014 at 19:48 UTC

    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?

[reply]
[reply]
        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.

        [download]

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

Back to Seekers of Perl Wisdom