Oracle_fdw-0.9.9 make error: oci.h: No such file or directory

Bart Klein Ikink <[email protected]> Thu, 13 Feb 2014 14:52:10 +0000
Newsgroups gmane.comp.db.postgresql.interfaces
Message-ID <[email protected]>
I try to install Oracle Foreign Data Wrapper but I get the following:

[postgres oracle_fdw-0.9.9]$ make
gcc -O2 -g -pipe -Wall 
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector 
--param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et -Wall 
-Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement 
-Wendif-labels -Wmissing-format-attribute -Wformat-security 
-fno-strict-aliasing -fwrapv -fpic -I/sdk/include -I/oci/include 
-I/rdbms/public -I/usr/include/oracle/11.2/client 
-I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/client 
-I/usr/include/oracle/11.1/client64 
-I/usr/include/oracle/10.2.0.5/client 
-I/usr/include/oracle/10.2.0.5/client64 
-I/usr/include/oracle/10.2.0.4/client 
-I/usr/include/oracle/10.2.0.4/client64 
-I/usr/include/oracle/10.2.0.3/client 
-I/usr/include/oracle/10.2.0.3/client64 -I. -I. 
-I/usr/pgsql-9.2/include/server -I/usr/pgsql-9.2/include/internal 
-I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  
-c -o oracle_utils.o oracle_utils.c
oracle_utils.c:20:17: error: oci.h: No such file or directory
...
many more errors
...

File oci.h appears to be nowhere on server but Oracle instant client is installed (apparently without oci.h).


[root]# rpm -q oracle-instantclient11.2-basic --info
Name        : oracle-instantclient11.2-basic  Relocations: (not relocatable)
Version     : 11.2.0.4.0                        Vendor: Oracle Corporation
Release     : 1                             Build Date: Sat 24 Aug 2013 07:31:17 PM CEST
Install Date: Tue 11 Feb 2014 03:38:30 PM CET      Build Host: adc4150581.us.oracle.com
Group       : Applications/File             Source RPM: oracle-instantclient11.2-basic-11.2.0.4.0-1.src.rpm
Size        : 187675499                        License: Oracle
Signature   : (none)
Packager    : Nobody <[email protected]>
URL         : http://www.oracle.com/
Summary     : Instant Client for Oracle Database 11g
Description :
Instant
 Client allows you to run your applications without installing the 
standard Oracle client or having an ORACLE_HOME. OCI, OCCI, ODBC, and 
JDBC applications work without modification, while using significantly 
less disk space than before.  No recompile, no hassle.

This is the Basic package, supporting OCI, OCCI, and JDBC-OCI with all languages.