oracle_home v15

Before creating a link to an Oracle server, you must direct EDB Postgres Advanced Server to the correct Oracle home directory. Set the LD_LIBRARY_PATH environment variable on Linux (or PATH on Windows) to the lib directory of the Oracle client installation directory.

Alternatively, you can also set the value of the oracle_home configuration parameter in the postgresql.conf file. The value specified in the oracle_home configuration parameter overrides the LD_LIBRARY_PATH environment variable in Linux and PATH environment variable in Windows.

Setting the configuration parameter

To set the oracle_home configuration parameter in the postgresql.conf file, add the following line:

oracle_home = 'lib_directory'

Substitute the name of the oracle_home path to the Oracle client installation directory that contains libclntsh.so in Linux and oci.dll in Windows for lib_directory.

Restarting the server

After setting the oracle_home configuration parameter, you must restart the server for the changes to take effect. Restart the server:

• On Linux, using the systemctl command or pg_ctl services.
• On Windows, from the Windows Services console.