oracle_home v16
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.
Note
The oracle_home
configuration parameter must provide the correct path to the Oracle client, i.e., OCI
library.
Setting the configuration parameter
To set the oracle_home
configuration parameter in the postgresql.conf
file, add the following line:
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 orpg_ctl
services. - On Windows, from the Windows Services console.