DBD::Oracle installation

2013-12-05 Thread Furst, Carl
What libs from oracle are exactly required to install this..

We just installed the client libs, including sql plus on Centos and it seems 
that Makefile.pl is having trouble finding the version:

WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous results.
You can use perl Makefile.PL -V X.Y.Z to specify a your client version.

Now if I had to specify that manually is that the sqlplus version?? How is it 
determining that version?? We have 12.4 installed.

Thanks,
Carl Furst



Re: DBD::Oracle installation

2013-12-05 Thread Furst, Carl
Thanks! We got it going with an oracle client rpm, sqlplus and demo.mk
probably from SDK packages. Seems to be working.

However, I'm wondering why this information is not in the INSTALL file at
least? Would be a good hint so people know what they would need to get
going.

Thanks,
Carl Furst





On 12/5/13 6:57 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote:


On Dec 5, 2013, at 4:06 PM, Furst, Carl carl.fu...@mlb.com wrote:

 What libs from oracle are exactly required to install this..
 
 We just installed the client libs, including sql plus on Centos and it
seems that Makefile.pl is having trouble finding the version:
 
 WARNING: I could not determine Oracle client version so I'll just
 default to version 8.0.0.0. Some features of DBD::Oracle may not work.
 Oracle version based logic in Makefile.PL may produce erroneous results.
 You can use perl Makefile.PL -V X.Y.Z to specify a your client
version.
 
 Now if I had to specify that manually is that the sqlplus version?? How
is it determining that version?? We have 12.4 installed.
 
 Thanks,
 Carl Furst

If you’re using the Instant Client, you need to install the Basic Client
and the SDK packages; most likely it’s breaking because of the missing
SDK stuff or your environment variables aren’t set. These cause 99% of
the problems I’ve ever had getting DBD::Oracle running.


http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Then set up the $ORACLE_HOME, $TNS_ADMIN and $LD_LIBRARY_PATH environment
variables:


ORACLE_HOME=/usr/lib/oracle/11.2/client64
TNS_ADMIN=/usr/lib/oracle/11.2/client64/admin
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

This is on a RHEL server, but it’s in the same place on a CentOS server.

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs