Like I first suspected Oracle has changed things about agin. Not much we can do about that except keep repatching the Makefile.PL (now by far the largest makefile on CPAN) and hope we do not break anything else. Never hurts to set 'LD_LIBRARY_PATH' as the Makefile will have to do less work. I memory servers me correctly it was needed for eailer oracle full intalations like 8 and early 9 then by 10 it was no longer needed but was needed again when the instant client came out. I guess it is a case of what goes around comes around. Thanks for the patch. If you have not done so open an RT ticket and put the patch there. I am sure Martin will apply it as soon as it is ready. Cheers John
> Date: Tue, 8 Nov 2011 12:55:04 +0000 > From: c...@cam.ac.uk > To: byter...@hotmail.com > CC: dbi-users@perl.org > Subject: Re: Building DBD::Oracle against Oracle full installs. > > On 07/11/11 17:56, John Scoles wrote: > > > > >> What am I doing wrong? > > > > Most likely nothing:) > > It turns out that I was doing something quite seriously wrong:( > > The make file Oracle recommend for building OCI programs, such as > DBD::Oracle, is demo-rdbms.mk (or demo-rdms32.mk - see below). These > make files should be found in the directory $ORACLE_HOM/rdbms/demo. > > In Oracle 11, these make files are not included either on the > database media or on the client media. The are on the examples > media. > > So, to get everything you need to compile and link an OCI > program, you need to install the examples. This will increase > the size of your ORACLE_HOME by >600Mb. That's life. > > Installing the examples completely fixed the problem for my > data base server, on which everything is 64-bit. > > However, it did NOT fix the problem on my client box, which is > all 32-bit. On this box, Makefile.PL gave up because it could > not find demo-rdms32.mk. This is wrong. demo-rdms32.mk is only > shipped with 64-bit Oracle distributions. It is intended only for > compiling 32-bit programs on 64-bit platforms. On a 32-bit > platform, demo-rdbms.mk should be used.See > http://download.oracle.com/docs/cd/E11882_01/server.112/e10839/prcmp_cll_int.htm#BABDGIDJ > > I will prepare a patch for Maekfile.PL to do two things: > > 1. Generate a warning for Oracle 11 non-instant ORACLE_HOMEs > which do not have rdbms/demo/demo-rdbms.mk, suggesting that > the examples should be installed. > 2. Use demo-rdbms.mk for 32-bit compilations in 32-bit > environments. > > > Are you setting the 'LD_LIBRARY_PATH' ENV value?? > > I have never found this to be necessary except with Instant Clients. > -- > Charles Jardine - Computing Service, University of Cambridge > c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679 > > >> Date: Mon, 7 Nov 2011 17:15:47 +0000 > >> From: c...@cam.ac.uk > >> To: dbi-users@perl.org > >> Subject: Building DBD::Oracle against Oracle full installs. > >> > >> Operating System: SLES 11 SP 2 on x86-64 > >> Perl: 5.14.2 > >> Oracle: 11.2.0.3.0 > >> DBD::Oracle: 1.34 > >> > >> If I try to build DBD::Oracle against a Server installation of Oracle, > >> the output of Makefile.PL includes the following strong warning message > >> mentioning this mailing list. Despite the warning message, the build > >> is successful. > >> > >>> + /usr/local/perl/5.14.2-A/bin/perl Makefile.PL > >>> Using DBI 1.616 (for perl 5.014002 on x86_64-linux-thread-multi) > >>> installed in > >>> /usr/local/perl/5.14.2-A/lib/site_perl/5.14.2/x86_64-linux-thread-multi/auto/DBI/ > >>> > >>> Configuring DBD::Oracle for perl 5.014002 on linux > >>> (x86_64-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 /oracle/base/orahome/11.2.0.3.0 > >>> DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR) > >>> Oracle version 11.2.0.3 (11.2) > >>> Found /oracle/base/orahome/11.2.0.3.0/rdbms/lib/ins_rdbms.mk > >>> Using /oracle/base/orahome/11.2.0.3.0/rdbms/lib/ins_rdbms.mk > >>> Your LD_LIBRARY_PATH env var is set to '' > >>> WARNING: Your LD_LIBRARY_PATH env var doesn't include > >>> '/oracle/base/orahome/11.2.0.3.0/lib' but probably needs to. > >>> Reading /oracle/base/orahome/11.2.0.3.0/rdbms/lib/ins_rdbms.mk > >>> Reading /oracle/base/orahome/11.2.0.3.0/rdbms/lib/env_rdbms.mk > >>> WARNING: Oracle /oracle/base/orahome/11.2.0.3.0/rdbms/lib/ins_rdbms.mk > >>> doesn't define a 'build' rule. > >>> > >>> WARNING: I will now try to guess how to build and link DBD::Oracle for > >>> you.^G > >>> This kind of guess work is very error prone and Oracle-version sensitive. > >>> It is possible that it won't be supported in future versions of > >>> DBD::Oracle. > >>> *PLEASE* notify dbi-users about exactly _why_ you had to build it this > >>> way. > >>> > >>> Found header files in /oracle/base/orahome/11.2.0.3.0/rdbms/public. > >>> > >>> client_version=11.2 > >> > >> > >> If I try to build against a full Oracle client installation, > >> I get the following fatal error. However, if I follow the advice > >> given in the error message, and add the following option to the Makefile.PL > >> > >> -m /local/oracle/client.11.2.0.3.0/rdbms/lib/ins_rdbms.mk > >> > >> the behaviour changes, and I get a warning like the one above, and a > >> successful build. > >> > >>> + /local/oracle/perl/5.14.2-A/bin/perl Makefile.PL > >>> Using DBI 1.616 (for perl 5.014002 on i686-linux-thread-multi) installed > >>> in > >>> /local/oracle/perl/5.14.2-A/lib/site_perl/5.14.2/i686-linux-thread-multi/auto/DBI/ > >>> > >>> Configuring DBD::Oracle for perl 5.014002 on linux > >>> (i686-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 /local/oracle/client.11.2.0.3.0 > >>> DEFINE _SQLPLUS_RELEASE = "1102000300" (CHAR) > >>> Oracle version 11.2.0.3 (11.2) > >>> > >>> Unable to locate an oracle.mk or other suitable *.mk > >>> file in your Oracle installation. (I looked in > >>> /local/oracle/client.11.2.0.3.0/rdbms/demo/demo_xe.mk > >>> /local/oracle/client.11.2.0.3.0/rdbms/demo/demo_rdbms32.mk under > >>> /local/oracle/client.11.2.0.3.0) > >>> > >>> The oracle.mk (or demo_rdbms.mk) file is part of the Oracle > >>> RDBMS 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 1185. > >> > >> What am I doing wrong? > >> > >> -- > >> Charles Jardine - Computing Service, University of Cambridge > >> c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679 > >
