Front page | perl.dbi.users |
Postings from April 2012
On 26/04/2012 19:53, John Adams wrote: > Hi, Martin, > > > > On Thu, Apr 26, 2012 at 1:39 PM, Martin J. Evans > <martin.evans@easysoft.com> wrote: > >> When I build against Oracle Instant Client I download the instant client >> from Oracle, unzip it in /home/martin. Then I set >> LD_LIBRARY_PATH=/home/martin/instantclient_11_2 and do >> >> perl Makefile.PL >> make >> >> Do you really want to use instant client or build directly against your >> oracle install - you seem, to me, to be mixing the two. There are issues >> building against a full Oracle install right now as I believe they (Oracle) >> have put the files required in different packages but I've never had any >> issues with InstantClient. > I'm actually not on the RDBMS server proper, but on an application > server running WebLogic. Whatever bits and pieces of Oracle are > installed on this machine, I'm not sure. Our division of labor makes > that a DBA task rather than a sysadmin task, which is also why I'm > installing with the rpms rather than unzipping into someplace > sensible, like /opt/oracle/instantclient_11_1 (which is what I do on > machines I control). On this machine, /opt/oracle is a DBA > responsibility. (As always, the human problems are more difficult that > the technical problems.) > > Now, on reading what you wrote, I got to thinking, and tried changing > LD_LIBRARY_PATH from this: > > /usr/java/jdk1.6.0_27/jre/lib/amd64/native_threads:/usr/java/jdk1.6.0_27/jre/lib/amd64/server:/usr/java/jdk1.6.0_27/jre/lib/amd64:/opt/oracle/Middleware/prod/lib:/usr/lib/oracle/11.1/client64/lib > > to this: > > /usr/lib/oracle/11.1/client64/lib/usr/java/jdk1.6.0_27/jre/lib/amd64/native_threads:/usr/java/jdk1.6.0_27/jre/lib/amd64/server:/usr/java/jdk1.6.0_27/jre/lib/amd64:/opt/oracle/Middleware/prod/lib > > What that bought me was that Makefile.PL could no longer find sqlplus. > Possibly that's no use, but it's where my thought processes took me. You are out of the problem area I've had to deal with. If you use Instant Client installed from Oracle it installs everything into one directory. It seems your in a position where instant client is distributed around multiple dirs. I've no idea why you got: /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE/reentr.h:612: error: field ‘_crypt_struct’ has incomplete type but I am suspicious there might be modules built with different compilers. Check where the Perl module DBI came from and rebuild it if necessary. However, I may be way out and don't have time to dig deeper right now. Hopefully, someone else will wake up and know what to do. MartinThread Previous | Thread Next