15 dblink_ora

Table of Contents Previous Next


15 dblink_ora

dblink_ora provides an OCI-based database link that allows you SELECT, INSERT, UPDATE or DELETE data stored on an Oracle system from within Advanced Server.
Before creating a link to an Oracle server, you must tell Advanced Server where to find the OCI driver. You can either set the LD_LIBRARY_PATH environment variable (or PATH on Windows) to the lib directory of the Oracle client installation or set the value of the oracle_home configuration parameter in the postgresql.conf file. The value specified in the oracle_home configuration parameter will override the LD_LIBRARY_PATH (or PATH) environment variable.
If you use the LD_LIBRARY_PATH (or PATH) environment variable, you must ensure that the variable is properly set each time you start Advanced Server.
If the Oracle instant client that you've downloaded does not 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_number is the version number of the libclntsh.so library. For example:
To set the oracle_home configuration parameter in the postgresql.conf file, edit the file, adding the following line:
oracle_home = 'lib_directory'
Where lib_directory is the name of the directory that contains libclntsh.so (on Linux) or oci.dll (on Windows).
After setting the oracle_home configuration parameter, you must restart the server for the changes to take effect.

15 dblink_ora

Table of Contents Previous Next