DBD::Oracle and RHEL Instant Client rpms

[Bruce Johnson]

Has anyone else had trouble installing DBD::Oracle with the latest 12.1 instant 
client? 

I installed the Basic and Development IC rpm’s and the DBD installer complained 
it couldn’t determine what version I had, then complained it couldn’t find 
demo.mk. I finally got it to work by manually telling it what version and the 
path to the .mk file (which hadn’t changed from previous versions: 
/usr/share/oracle//client64…)

The various env values were set correctly, and the files were installed in the 
usual place, the only difference between this time and the last time I set up a 
RHEL system was I used the latest 12.1 instant client files rather than 11.2.

[root@kalendaetest DBD-Oracle-1.74-EIJTlU]# set |grep ora
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
ORACLE_HOME=/usr/lib/oracle/12.1/client64
PATH=/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/lib/oracle/12.1/client64/bin
TNS_ADMIN=/usr/lib/oracle/12.1/client64/admin

It worked, eventually, just wondering if others have run into the issue...

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

Institutions do not have opinions, merely customs

Re: DBD::Oracle and RHEL Instant Client rpms

[Bruce Johnson]

> On Oct 20, 2015, at 2:22 PM, Martin J. Evans  wrote:
> 
> 
> I don't use an RPM based system. I download instantclient basic, devel and 
> sqlplus zips and unzip them then point DBD::Oracle at them by setting 
> LD_LIBRARY_PATH.
> 
> Did you download the sqlplus RPM (assuming there is one) as DBD::Oracle uses 
> sqlplus during the install to work out what version of the Oracle client you 
> have?

No I didn’t, since I don’t need it on this system, and figured I’d save some 
time/disk space. Probably a bad idea on my part. 

The server is working fine though, I was just a bit puzzled. I”ll have to go 
look back and see if I did install SQLPlus on the other systems. The problem is 
I set up a new server just once in a blue moon, not all the time, and forget 
all the bits and bobs I need.

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

Institutions do not have opinions, merely customs

Re: DBD::Oracle and RHEL Instant Client rpms

[Martin J. Evans]

On 20/10/2015 19:53, Bruce  Johnson wrote:

Has anyone else had trouble installing DBD::Oracle with the latest 12.1 instant 
client?

I installed the Basic and Development IC rpm’s and the DBD installer complained it 
couldn’t determine what version I had, then complained it couldn’t find demo.mk. I 
finally got it to work by manually telling it what version and the path to the .mk 
file (which hadn’t changed from previous versions: 
/usr/share/oracle//client64…)

The various env values were set correctly, and the files were installed in the 
usual place, the only difference between this time and the last time I set up a 
RHEL system was I used the latest 12.1 instant client files rather than 11.2.

[root@kalendaetest DBD-Oracle-1.74-EIJTlU]# set |grep ora
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
ORACLE_HOME=/usr/lib/oracle/12.1/client64
PATH=/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/lib/oracle/12.1/client64/bin
TNS_ADMIN=/usr/lib/oracle/12.1/client64/admin

It worked, eventually, just wondering if others have run into the issue...



I don't use an RPM based system. I download instantclient basic, devel 
and sqlplus zips and unzip them then point DBD::Oracle at them by 
setting LD_LIBRARY_PATH.


Did you download the sqlplus RPM (assuming there is one) as DBD::Oracle 
uses sqlplus during the install to work out what version of the Oracle 
client you have?


Martin
--
Martin J. Evans
Wetherby, UK