Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDxeC-0006u2-Tx for pgsql-interfaces@arkaria.postgresql.org; Thu, 13 Feb 2014 14:52:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WDxeC-0000MU-9k for pgsql-interfaces@arkaria.postgresql.org; Thu, 13 Feb 2014 14:52:16 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDxeB-0000ML-82 for pgsql-interfaces@postgresql.org; Thu, 13 Feb 2014 14:52:15 +0000 Received: from dub0-omc2-s14.dub0.hotmail.com ([157.55.1.153]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDxe7-0006uQ-PD for pgsql-interfaces@postgresql.org; Thu, 13 Feb 2014 14:52:14 +0000 Received: from DUB130-W69 ([157.55.1.136]) by dub0-omc2-s14.dub0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 13 Feb 2014 06:52:10 -0800 X-TMN: [y9mpFCrHXD1i3TGPTFR4bBqNjFulUYH+] X-Originating-Email: [bart_klein_ikink@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_4b0b40f9-a7ba-44b0-b5d3-60e1915564a2_" From: Bart Klein Ikink To: "pgsql-interfaces@postgresql.org" Subject: Oracle_fdw-0.9.9 make error: oci.h: No such file or directory Date: Thu, 13 Feb 2014 14:52:10 +0000 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 13 Feb 2014 14:52:10.0300 (UTC) FILETIME=[2C418FC0:01CF28CB] X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-interfaces Precedence: bulk Sender: pgsql-interfaces-owner@postgresql.org --_4b0b40f9-a7ba-44b0-b5d3-60e1915564a2_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =0A= -Wp=2C-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protector =0A= --param=3Dssp-buffer-size=3D4 -m64 -mtune=3Dgeneric -I/usr/include/et -Wall= =0A= -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement =0A= -Wendif-labels -Wmissing-format-attribute -Wformat-security =0A= -fno-strict-aliasing -fwrapv -fpic -I/sdk/include -I/oci/include =0A= -I/rdbms/public -I/usr/include/oracle/11.2/client =0A= -I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/client =0A= -I/usr/include/oracle/11.1/client64 =0A= -I/usr/include/oracle/10.2.0.5/client =0A= -I/usr/include/oracle/10.2.0.5/client64 =0A= -I/usr/include/oracle/10.2.0.4/client =0A= -I/usr/include/oracle/10.2.0.4/client64 =0A= -I/usr/include/oracle/10.2.0.3/client =0A= -I/usr/include/oracle/10.2.0.3/client64 -I. -I. =0A= -I/usr/pgsql-9.2/include/server -I/usr/pgsql-9.2/include/internal =0A= -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include =0A= -c -o oracle_utils.o oracle_utils.c oracle_utils.c:20:17: error: oci.h: No such file or directory ... many more errors ... =0A= File oci.h appears to be nowhere on server but Oracle instant client is ins= talled (apparently without oci.h). =0A= [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.u= s.oracle.com Group : Applications/File Source RPM: oracle-instantclien= t11.2-basic-11.2.0.4.0-1.src.rpm Size : 187675499 License: Oracle Signature : (none) Packager : Nobody URL : http://www.oracle.com/ Summary : Instant Client for Oracle Database 11g Description : Instant=0A= Client allows you to run your applications without installing the =0A= standard Oracle client or having an ORACLE_HOME. OCI=2C OCCI=2C ODBC=2C and= =0A= JDBC applications work without modification=2C while using significantly = =0A= less disk space than before. No recompile=2C no hassle. =0A= This is the Basic package=2C supporting OCI=2C OCCI=2C and JDBC-OCI with al= l languages.=0A= =0A= =0A= =0A= = --_4b0b40f9-a7ba-44b0-b5d3-60e1915564a2_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I try to install Oracle Foreign = Data Wrapper but I get the following:

[postgres oracle_fdw-0.9.9]$ m= ake
gcc -O2 -g -pipe -Wall =0A= -Wp=2C-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protector =0A= --param=3Dssp-buffer-size=3D4 -m64 -mtune=3Dgeneric -I/usr/include/et -Wall= =0A= -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement =0A= -Wendif-labels -Wmissing-format-attribute -Wformat-security =0A= -fno-strict-aliasing -fwrapv -fpic -I/sdk/include -I/oci/include =0A= -I/rdbms/public -I/usr/include/oracle/11.2/client =0A= -I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/client =0A= -I/usr/include/oracle/11.1/client64 =0A= -I/usr/include/oracle/10.2.0.5/client =0A= -I/usr/include/oracle/10.2.0.5/client64 =0A= -I/usr/include/oracle/10.2.0.4/client =0A= -I/usr/include/oracle/10.2.0.4/client64 =0A= -I/usr/include/oracle/10.2.0.3/client =0A= -I/usr/include/oracle/10.2.0.3/client64 -I. -I. =0A= -I/usr/pgsql-9.2/include/server -I/usr/pgsql-9.2/include/internal =0A= -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 =3B -I/usr/inclu= de =3B =0A= -c -o oracle_utils.o oracle_utils.c
oracle_utils.c:20:17: error: oci.h: = No such file or directory
...
many more errors
...
=0A= File oci.h appears to be nowhere on server but Oracle instant client is ins= talled (apparently without oci.h).

=0A= [root]# rpm -q oracle-instantclient11.2-basic --info
Name =3B = =3B =3B =3B =3B =3B =3B : oracle-instantclient11.2-basi= c =3B Relocations: (not relocatable)
Version =3B =3B =3B=  =3B : 11.2.0.4.0 =3B =3B =3B =3B =3B =3B = =3B =3B =3B =3B =3B =3B =3B =3B =3B =3B=  =3B =3B =3B =3B =3B =3B =3B Vendor: Oracle Cor= poration
Release =3B =3B =3B =3B : 1 =3B =3B&nbs= p=3B =3B =3B =3B =3B =3B =3B =3B =3B = =3B =3B =3B =3B =3B =3B =3B =3B =3B =3B=  =3B =3B =3B =3B =3B =3B =3B Build Date: Sat 24= Aug 2013 07:31:17 PM CEST
Install Date: Tue 11 Feb 2014 03:38:30 PM CET=  =3B =3B =3B =3B =3B Build Host: adc4150581.us.oracle.c= om
Group =3B =3B =3B =3B =3B =3B : Applications/= File =3B =3B =3B =3B =3B =3B =3B =3B = =3B =3B =3B =3B Source RPM: oracle-instantclient11.2-basic-11.2= .0.4.0-1.src.rpm
Size =3B =3B =3B =3B =3B =3B&nb= sp=3B : 187675499 =3B =3B =3B =3B =3B =3B =3B&n= bsp=3B =3B =3B =3B =3B =3B =3B =3B =3B = =3B =3B =3B =3B =3B =3B =3B License: Oracle
Sign= ature =3B =3B : (none)
Packager =3B =3B =3B : Nobody= <=3Bnobody@oracle.com>=3B
= URL =3B =3B =3B =3B =3B =3B =3B =3B : http://www.oracle.com/<= br>Summary =3B =3B =3B =3B : Instant Client for Oracle Data= base 11g
Description :
Instant=0A= Client allows you to run your applications without installing the =0A= standard Oracle client or having an ORACLE_HOME. OCI=2C OCCI=2C ODBC=2C and= =0A= JDBC applications work without modification=2C while using significantly = =0A= less disk space than before. =3B No recompile=2C no hassle.
=0A= This is the Basic package=2C supporting OCI=2C OCCI=2C and JDBC-OCI with al= l languages.=0A= =0A= =0A=

=0A=
= --_4b0b40f9-a7ba-44b0-b5d3-60e1915564a2_--