Perl DBD::Oracle Install Issues
786624Jul 21 2010 — edited Jul 21 2010Greetings,
I have a 11.2.0 Oracle database server running on a Linux RHEL 4 box which is all working fine and I can connect locally and externally. I am now trying to install the Oracle Perl modules and running into some problems. I have the DBI modules installed and working, but when running them Makefile.PL script I get the following error:
Multiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ at Makefile.PL line 37
Using DBI 1.612 (for perl 5.008005 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.008005 on linux (i386-linux-thread-multi)
+Remember to actually READ the README file! Especially if you have any problems.+
Installing on a linux, Ver#2.6
Using Oracle in /home/oracle/product/11.2.0
+DEFINE SQLPLUSRELEASE = "1102000100" (CHAR)+
Oracle version 11.2.0.1 (11.2)
Unable to locate an oracle.mk, proc.mk or other suitable *.mk
file in your Oracle installation. (I looked in
+/home/oracle/product/11.2.0/rdbms/demo/demo_rdbms32.mk /home/oracle/product/11.2.0/precomp/demo/proc/proc.mk /home/oracle/product/11.2.0/precomp/demo/proc/demo_proc.mk /home/oracle/product/11.2.0/proc/lib/proc.mk /home/oracle/product/11.2.0/proc16/lib/proc16.mk /usr/share/oracle/11.2/client/demo.mk /usr/share/oracle/11.2/client64/demo.mk under /home/oracle/product/11.2.0)+
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.
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 the appropriate README file for your OS for more information and some alternatives.
at Makefile.PL line 1095.
I tried to find the "oracle.mk" and "proc.mk" files in the $ORACLE_HOME path, but can't find it there or any sub-folders. Do I need to install the instant-client to get the Perl modules to work? Won't this cause issues with the current server install?
Any idea how I can use the Server version (i.e. no client) to install the Perl modules?
Thanks,
Marcel