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

From: Bart Klein Ikink <bart_klein_ikink(at)hotmail(dot)com>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Oracle_fdw-0.9.9 make error: oci.h: No such file or directory
Date: 2014-02-13 14:52:10
Message-ID: DUB130-W694CF895B6AC4192B4D2AAC19D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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 <nobody(at)oracle(dot)com>
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.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2014-02-13 14:59:32 Re: Oracle_fdw-0.9.9 make error: oci.h: No such file or directory
Previous Message Simon Riggs 2014-02-05 15:46:53 Re: DBD::Pg 3.0.0, Perl driver for PostgreSQL, released