All,
I have a Debian Linux machine which runs the following:
Perl 5.005_03
DBI 1.25
[hopefully] DBD::Oracle 1.12
I need to write scripts which will access an Oracle 8i service which is
hosted on Windows NT 4. My problem is that I am unable to build DBD::Oracle
since it seems to require Oracle development libraries to compile. I read
over the README.* files (README.clients, README.win32, etc.) and saw a few
cases where client machines such as Irix and Solaris were attempting to
access externally hosted Oracle services, but all of those examples had
Oracle hosted on non-Windows platforms.
Some of the required header files in the $ORACLE_HOME\RDBMS\Demo and
$ORACLE_HOME\oci were copied from the NT box to the Linux machine, and an
impromptu $ORACLE_HOME created under /home/o to satisfy some of the
makefile's needs. Currently the Makefile is demanding an "oracle.mk" file,
which does not exist at all under any of the Win32 installations of Oracle
8i we have here. I ran the Oracle client installation on a Windows box and
choose the "Programmer" installation, which installs Pro*C and several other
libraries, but there are no oracle.mk files being installed.
When building the makefile for DBD::Oracle, I get the following error:
# perl Makefile.PL
Using DBI 1.25 installed in /usr/local/lib/site_perl/i386-linux/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /home/o
Found header files in rdbms/demo.
You don't seem to have many Oracle libraries installed. If the
build fails you probably need to install more Oracle software.
Unable to locate an oracle.mk, proc.mk or other suitable *.mk
file in your Oracle installation. (I looked in
/home/o/rdbms/lib/oracle.mk /home/o/rdbms/demo/oracle.mk
/home/o/rdbms/d
emo/demo_rdbms.mk /home/o/otrace/demo/atmoci.mk
/home/o/precomp/demo/proc/proc.m
k /home/o/precomp/demo/proc/demo_proc.mk /home/o/proc/lib/proc.mk
/home/o/proc16
/lib/proc16.mk)
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.)
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 for more information and some alternatives.
at Makefile.PL line 727.
My big question is, am I pursuing the proper course of action if I am to use
Perl from Linux to access Oracle on NT? Or is there something else I could
do to accomplish this?
Any help from anyone would be appreciated.
Cheers,
Garrett Ellis
