Обсуждение: Oracle_fdw-0.9.9 make error: oci.h: No such file or directory
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@oracle.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.
[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@oracle.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.
On Thu, Feb 13, 2014 at 02:52:10PM +0000, Bart Klein Ikink wrote: > 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. Have you considered you might need the standard Oracle client, as mentioned above in your email? -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +