Add the path of the OCI library to the environment variable. The available version of the OCI library is 12.1 or later.
Add the installation path of the OCI library to the LD_LIBRARY_PATH environment variable.
As superuser, run the following command:
$ su - Password:****** # cp -r /opt/fsepv<x>server64/OSS/oracle_fdw/* /opt/fsepv<x>server64
If a file named libclntsh.so.12.1 does not exist in your OCI library, create a symbolic link with the name libclntsh.so. 12.1 to libclntsh.so.xx.1 (xx is the version of the OCI library).
# ln -s libclntsh.so.12.2 libclntsh.so.12.1
Restart Fujitsu Enterprise Postgres.
Execute CREATE EXTENSION for the database that will use this feature.
Use the psql command to connect to the "postgres" database.
postgres=# CREATE EXTENSION oracle_fdw; CREATE EXTENSION
Information
If the OCI library is not installed on the server, install it using the Oracle client or Oracle Instant Client.
Refer to the relevant Oracle manual for information on the installation procedure.
If the version of the OCI library is updated, change the path of the OCI library in the LD_LIBRARY_PATH environment variable to the updated path. Also, re-create the symbolic link named libclntsh.so.12.1 if necessary.
Note
This feature cannot be used on instances created in WebAdmin. It can only be used via server commands.
Execute DROP EXTENSION for the database that will use this feature.
Use the psql command to connect to the "postgres" database.
postgres=# DROP EXTENSION oracle_fdw CASCADE; DROP EXTENSION
As superuser, run the following command:
$ su -
Password:******
# rm -rf /opt/fsepv<x>server64/filesCopiedDuringSetupInformation
The files copied during setup can be checked below.
# find /opt/fsepv<x>server64/OSS/oracle_fdw