oracle_utils.c:22:17: fatal error: oci.h: No such file or directory

[cwhitsbm]

Hello,

I seem to go round and round with this FDW every time I install it with a different problem every time.

This time it is this error:
oracle_utils.c:22:17: fatal error: oci.h: No such file or directory

I have installed:
oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
postgresql-server-dev-9.6

I do not seem to have a /opt/include directory anywhere on the system.

My paths are as follows:
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/usr/lib/oracle/12.2/client64/bin:/usr/oracle/12.2/client64/lib"
ORACLE_HOME="/usr/lib/oracle/12.2/client64"
LD_LIBRARY_PATH="/usr/lib/oracle/12.2/client64/lib/"

I am completely lost and don't know what is broken. Any help you can provide would be great.

[cwhitsbm]

I tried doing an apt-file search oci.h and while there were other filenames that contained oci.h there was nothing specifically that was just "oci.h"

[cwhitsbm]

Just to add in case there are any other questions, I have also installed:

Postgres9.6
postgresql-contrib
libpq-dev
postgresql-server-dev-9.6

[laurenz]

This is a duplicate of #153.
Oracle 12.2 is being released today, so the paths to the new RPM locations are not in the Makefile of older releases.

You can either download the latest development version of oracle_fdw, e.g. from here that contains commit 96e022c, or you can ad the following to Makefile yourself:

To PG_CPPFLAGS add -I/usr/include/oracle/12.2/client64, and to SHLIB_LINK add -L/usr/lib/oracle/12.2/client64/lib.

[cwhitsbm]

My problem appears to be that I don’t have the oci.h file. What application is support to install it?

[laurenz]

If you don't have oci.h, you didn't install oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm.

Use rpm -ql <packagename> to figure out where the stuff is installed.

[cwhitsbm]

Do you know if there could be an issue with the order in which I installed the packages? Unless I just made a typo and entered the wrong package name which I certainly don’t discount. I ran it a second time and all it did was extract a .deb package. So I assume that meant it ran the first time. Thank you for the help. I will give this another shot.

[laurenz]

The order of installation is irrelevant.
Did you try

find /usr/include/oracle -name oci.h

[cwhitsbm]

I reinstalled everything and am now able to find that file in /usr/include/oracle/12.2/client64/oci.h. Reinstalled the FDW and everything is fine. Thank you so much!

[cwhitsbm]

While I did get the FDW for 12.2 to install correctly, however we are getting another 12.1 error trying to create an extension. sbmdw20=# create extension oracle_fdw; ERROR: could not load library "/usr/lib/postgresql/9.6/lib/oracle_fdw.so": libclntsh.so.12.1: cannot open shared object file: No such file or directory sbmdw20=# create extension postgres_fdw; Is this something in the FDW code that needs to be resolved or in a file we can modify perhaps?

[laurenz]

You probably don't have libclntsh.so.12.1 on your shared library path.
Add the path to /etc/ld.so.conf and run ldconfig as root.

Make sure that you don't have more than one Oracle client in the shared library path.

[cwhitsbm]

Well I am using the Oracle 12.2 client so I would be required to have more than one path, no? Would this 12.1 file even be there if I installed 12.2?

[laurenz]

Why more than one path? I don't understand.
Can you give me more detail?