When you run the make command when installing Oracle_fdw, you may encounter the error as follows. The reason for this error is that the directory for ORACLE_HOME is not specified.
To solve this error, we need to set the ORACLE_HOME with the same path as the LD_LIBRARY_PATH. You can follow the steps below to do this.
We set the same path for Oracle_Home.
After setting the ORACLE_HOME path, we run the make command again.
As you can see below, the make command worked successfully.