This feature is available only when the server command is used. It is not available for instances created with WebAdmin.
Add the path of the OCI library to the environment variable.
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.11.1 does not exist in your OCI library, create a symbolic link with the name libclntsh.so.11.1 to libclntsh.so.xx.1 (xx is the version of the OCI library).
# ln -s libclntsh.so.xx.1 libclntsh.so.11.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.11.1 if necessary.
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