We have a web server running Oracle Enterprise Linux (OEL v6.8) which includes the Oracle HTTP Server (OHS; a customized version of Apache). The OS has Perl v5.10.1 installed. The database version we will connect to is Oracle v12.1.0.2.0. Yes, I know these are all old but it's a legacy app and it's what I have to work with.
I'm trying to build the DBD::Oracle module and it fails. Here is some of what it says:
Installing on a linux, Ver#3.8
Using Oracle in /mnt/ora_home/app/oracle/product/12.1.0.2/client_1
DEFINE _SQLPLUS_RELEASE = "1201000200" (CHAR)
Oracle Version 12.1.0.2 (12.1)
Looks like an Instant Client installation, okay
Your LD_LIBRARY_PATH env var is set to '/mnt/ora_home/app/oracle/product/12.1.0.2/client_1'
*********************************************************
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
For Instant Client that means the SDK package.
I'll keep going, but the compile will probably fail.
See the appropriate troubleshooting guide for your OS for more information.
*********************************************************
So I went to this Oracle site and downloaded the devl rpm package (description is SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client). But when I attempt to install it (as root), it fails with:
Error: Package: oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64 (/oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64)
Requires: oracle-instantclient12.1-basic >= 12.1.0.2.0
So, the module build process seems to detect an Instant Client installation, but the rpm install process does not.
Any suggestions on how to get the header files installed so that I can build the DBD::Oracle module? Do I need a different install file for them? Am I missing something simple?