12 dblink_ora

Table of Contents Previous Next


12 dblink_ora

dblink_ora provides an OCI-based database link that allows you to SELECT, INSERT, UPDATE or DELETE data stored on an Oracle system from within Advanced Server.
For Linux, 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:
ln -s libclntsh.so.version libclntsh.so
Where version is the version number of the libclntsh.so library. For example:
Set the LD_LIBRARY_PATH environment variable on Linux (or PATH on Windows) to the lib directory of the Oracle client installation directory.
For Windows only, you can instead 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 Windows PATH environment variable.
The LD_LIBRARY_PATH environment variable on Linux (PATH environment variable or oracle_home configuration parameter on Windows) must be set properly each time you start Advanced Server.
When using a Linux service script to start Advanced Server, be sure LD_LIBRARY_PATH has been set within the service script so it is in effect when the script invokes the pg_ctl utility to start Advanced Server.
For Windows only: To set the oracle_home configuration parameter in the postgresql.conf file, edit the file, adding the following line:
oracle_home = 'lib_directory '
After setting the oracle_home configuration parameter, you must restart the server for the changes to take effect. Restart the server from the Windows Services console.

12 dblink_ora

Table of Contents Previous Next