9 Installing Oracle GoldenGate for Sybase Databases

Learn about the requirements and how to install Oracle GoldenGate for Sybase databases.

Install Oracle GoldenGate for your Sybase system, see Installing for all Platforms.

• Setting Library Paths for Dynamic Builds on UNIX
  
• Operating System Privileges
  
• Console Character Set
  

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 9-1 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 Table 9-2:

Table 9-2 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.

Operating System Privileges

The following are the privileges in the operating system that are required to install Oracle GoldenGate and to run the processes.

• To install on Windows, the person who installs Oracle GoldenGate must log in as Administrator.

• To install on UNIX, the person who installs Oracle GoldenGate must have read and write privileges on the Oracle GoldenGate installation directory.

• The Oracle GoldenGate Extract, Replicat, and Manager processes must operate as an operating system user that has privileges to read, write, and delete files and subdirectories in the Oracle GoldenGate directory. In addition, the Manager process requires privileges to control the other Oracle GoldenGate processes.

• The Extract process must operate as an operating system user that has read access to the transaction log files, both online and archived. If you install the Manager process as a Windows service during the installation steps in this documentation, you must install as Administrator for the correct permissions to be assigned. If you cannot install Manager as a service, assign read access to the Extract process manually, and then always run Manager and Extract as Administrator.

• Dedicate the Extract, Replicat, and Manager operating system users to Oracle GoldenGate. Sensitive information might be available to anyone who runs an Oracle GoldenGate process.

Console Character Set

The operating system and the command console must have the same character sets. Mismatches occur on Microsoft Windows systems, where the operating system is set to one character set, but the DOS command prompt uses a different, older DOS character set. Oracle GoldenGate uses the character set of the operating system to send information to GGSCI command output; therefore a non-matching console character set causes characters not to display correctly. You can set the character set of the console before opening a GGSCI session by using the following DOS command:

chcp OS_character_set

If the characters do not display correctly after setting the code page, try changing the console font to Lucida Console, which has an extended character set.