Setting Library Paths for Dynamic Builds on UNIX

Oracle GoldenGate uses shared libraries. When you install Oracle GoldenGate on a UNIX system, the following must be done before you run GGSCI or any other Oracle GoldenGate process . If you will be running an Oracle GoldenGate program from outside the Oracle GoldenGate installation directory on a UNIX system:

  • (Optional) Add the Oracle GoldenGate installation directory to the PATH environment variable.

  • (Required) Add the Oracle GoldenGate installation directory to the shared-libraries environment variable.

When Oracle GoldenGate connects remotely to the database server through SQL*Net, the following are required:
  • Replicat: The Oracle client library and the Oracle GoldenGate build must have the same Oracle version, bit type (64-bit or IA64), and operating system version.

  • Extract: The Oracle client library and the Oracle GoldenGate build must have the same Oracle version, bit type (64-bit or IA64), and operating system version. In addition, both operating systems must be the same endian.

For example, given an Oracle GoldenGate installation directory of /users/ogg, the second command in the following example requires these variables to be set:

Table 2-4 Command Requiring Library Variable

Command Requires GG libraries in environment variable?

$ users/ogg > ./ggsci

No

$ users > ./ogg/ggsci

Yes

To Set the Variables in Korn Shell:

PATH=installation_directory:$PATH
export PATH
shared_libraries_variable=absolute_path_of_installation_directory:$shared_libraries_variable
export shared_libraries_variable

To Set the Variables in Bourne Shell:

export PATH=installation_directory:$PATH
export shared_libraries_variable=absolute_path_of_installation_directory:$shared_libraries_variable

To Set the Variables in C Shell:

setenv PATH installation_directory:$PATH
setenv shared_libraries_variable absolute_path_of_installation_directory:$shared_libraries_variable

Where: shared_libraries_variable is one of the variables shown in **INTERNAL XREF ERROR**:

Table 2-5 UNIX/Linux Library Path Variables per Platform

Platform(1) Environment variable

IBM AIX

IBM z/OS

LIBPATH

HP-UX

SHLIB_PATH

Sun Solaris

LINUX

LD_LIBRARY_PATHFoot 2

Footnote 1 A specific platform may or may not be supported by Oracle GoldenGate for your database.

Footnote 2

In 64-bit environments with 32-bit Oracle databases, Oracle GoldenGate requires the LD_LIBRARY_PATH to include the 32-bit Oracle libraries.

Example

export LD_LIBRARY_PATH=/ggs/12.0:$LD_LIBRARY_PATH

Note:

To view the libraries that are required by an Oracle GoldenGate process, use the ldd goldengate_process shell command before starting the process. This command also shows an error message for any that are missing.