compile problem for DBD::Oracle

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

Does anybody know why I am getting this strange error during compiling the dbd::oracle pacakge. DBI I have already built and installed, which works fine.

Also I did the compilation in a different machine which worked fine over there.

% pwd  <br>          
/export/appl/myperl/Perl-5.8.8/downloads/DBD-Oracle-1.19<br>
% <br>
% perl Makefile.PL<br>
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi) instal
+led in /export/appl/myperl/Perl-5.8.8/exlib/sun4-solaris-thread-multi
+/auto/DBI/
<br><br>
Configuring DBD::Oracle for perl 5.008008 on solaris (sun4-solaris-thr
+ead-multi)<br><br>

Remember to actually *READ* the README file! Especially if you have an
+y problems.<br>

Using Oracle in /export/apps/oracli/DSM/9.2.0<br>
DEFINE _SQLPLUS_RELEASE = "902000500" (CHAR)<br>
Oracle version 9.2.0.5 (9.2)<br><br>

        Unable to locate an oracle.mk, proc.mk or other suitable *.mk<
+br>
        file in your Oracle installation.  <br>(I looked in
        /export/apps/oracli/DSM/9.2.0/rdbms/demo/demo_xe.mk /export/ap
+ps/oracli/DSM/9.2.0/rdbms/lib/oracle.mk /export/apps/oracli/DSM/9.2.0
+/rdbms/demo/oracle.mk /export/apps/oracli/DSM/9.2.0/rdbms/demo/demo_r
+dbms.mk /export/apps/oracli/DSM/9.2.0/precomp/demo/proc/proc.mk /expo
+rt/apps/oracli/DSM/9.2.0/precomp/demo/proc/demo_proc.mk /export/apps/
+oracli/DSM/9.2.0/proc/lib/proc.mk /export/apps/oracli/DSM/9.2.0/proc1
+6/lib/proc16.mk under /export/apps/oracli/DSM/9.2.0)<br><br>

        The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
        RDBMS product. The proc.mk (or demo_proc.mk) file is part of
        the Oracle Pro*C product.  You need to build DBD::Oracle on a
        system which has one of these Oracle components installed.
        (Other *.mk files such as the env_*.mk files will not work.)
        Alternatively you can use Oracle Instant Client.<br><br>

        In the unlikely event that a suitable *.mk file is installed
        somewhere non-standard you can specify where it is using the -
+m option:
                perl Makefile.PL -m /path/to/your.mk

        See README.clients.txt for more information and some alternati
+ves.<br>

     at Makefile.PL line 1074.
[download]

Comment on compile problem for DBD::Oracle Download Code

Replies are listed 'Best First'.
Re: compile problem for DBD::Oracle by planetscape (Chancellor) on Mar 06, 2007 at 16:39 UTC
Some ideas: Is Oracle installed on this machine? Can you locate "oracle.mk, proc.mk or other suitable *.mk file" manually? Have you read README.clients.txt? HTH, planetscape	[reply]
Re: compile problem for DBD::Oracle by marto (Cardinal) on Mar 06, 2007 at 16:47 UTC
yelekeri, Do you have an Oracle client installed and can you tell us what is in the environment variables ORACLE_HOME and LD_LIBRARY_PATH? Thanks Martin	[reply]
Re^2: compile problem for DBD::Oracle by yelekeri (Novice) on Mar 06, 2007 at 18:09 UTC
Oracle client is installed on the machine 9.2.0, and I am able to access the database using SQLPLUS. Here are my variables for the same : ORACLE_HOME /export/apps/oracli/DSM/9.2.0 LB_LIBRARY_PATH /export/apps/oracli/DSM/9.2.0/lib32 Also I couldn't locate "oracle.mk" anywhere in the oracle install dir. I never expected it because even in the "working" machine, I don't see oracle.mk file.	[reply]
Re^3: compile problem for DBD::Oracle by Anonymous Monk on Mar 07, 2007 at 07:36 UTC
Have you read README.clients.txt	[reply]
Re^4: compile problem for DBD::Oracle by Anonymous Monk on Jun 03, 2008 at 23:01 UTC