Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dCgst-0000Tu-Qc for pgsql-admin@arkaria.postgresql.org; Mon, 22 May 2017 06:32:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dCgst-0000hK-DX for pgsql-admin@arkaria.postgresql.org; Mon, 22 May 2017 06:32:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dCgss-0000eZ-MY for pgsql-admin@postgresql.org; Mon, 22 May 2017 06:32:02 +0000 Received: from mimolette.dalibo.net ([212.85.157.144] helo=mail.dalibo.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dCgsp-0003b7-DX for pgsql-admin@postgresql.org; Mon, 22 May 2017 06:32:01 +0000 Received: from nol.local (unknown [78.192.238.147]) by mail.dalibo.com (Postfix) with ESMTPSA id 705E82C01F9; Mon, 22 May 2017 08:31:55 +0200 (CEST) Subject: Re: error installing oracle_fdw extension To: Sumeet Shukla , Peter Eisentraut Cc: Tom Lane , pgsql-admin , laurenz.albe@wien.gv.at References: <27481.1495204891@sss.pgh.pa.us> From: Julien Rouhaud Message-ID: Date: Mon, 22 May 2017 08:30:59 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Adding Laurenz On 22/05/2017 07:56, Sumeet Shukla wrote: > Thanks Tom and Peter. I tried installing the latest version > oracle_fdw-1.5.0 and now I see below error: > > -bash-4.1$ make > gcc -Wall -Wmissing-prototypes -Wpointer-arith > -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute > -Wformat-security -fno-strict-aliasing -fwrapv -g -O2 > -DMAP_HUGETLB=0x40000 -fpic > -I/u01/app/oracle/product/12.1.0.2/db_1/sdk/include > > -I/u01/app/oracle/product/12.1.0.2/db_1/oci/include > > -I/u01/app/oracle/product/12.1.0.2/db_1/rdbms/public > -I/usr/include/oracle/12.1/client > -I/usr/include/oracle/12.1/client64 -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/opt/postgresql/9.6/include/postgresql/server > -I/opt/postgresql/9.6/include/postgresql/internal -D_GNU_SOURCE > -I/opt/local/Current/include/libxml2 -I/opt/local/Current/include -c > -o oracle_utils.o oracle_utils.c > oracle_utils.c:22:17: error: oci.h: No such file or directory Did you also install Oracle SDK files in the directory pointed by $ORACLE_HOME? -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin