Connecting to an Oracle database v15
To enable Oracle connectivity, download Oracle's freely available OCI drivers from their website.
Creating a symbolic link
For Linux, if the Oracle instant client that you downloaded doesn't include the libclntsh.so
library, you must create a symbolic link named libclntsh.so
that points to the downloaded version. Navigate to the instant client directory and execute the following command:
Where version
is the version number of the libclntsh.so
library. For example:
Setting the environment variable
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.
Setting the oracle_home configuration parameter
Alternatively, you can 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 provides the correct path to the Oracle client, that is, the OCI
library.
To set the oracle_home
configuration parameter in the postgresql.conf
file, edit the file and add the following line:
In place of <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.
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.