Prerequisites for Installing Oracle GoldenGate for Sybase
Learn the prerequisites for installing Oracle GoldenGate for a Sybase database.
Creating an Oracle GoldenGate for Sybase deployment requires that a supported
operating system version of the SDK FOR SAP ASE 16.0.3 and the Linux
Network Libraries (libnsl
) package be installed before
launching the Oracle GoldenGate Configuration Assistant (OGGCA).
Required Linux Packages
The Linux Network Libraries (libnsl
)package is required
prior to creating a deployment. Run the following command to install
the package:
sudo yum install libnsl
Sybase SDK FOR SAP ASE Installation
The following are basic steps for installing the SDK FOR SAP ASE 16.0.3.
-
Verify which operating systems are supported for this version of Oracle GoldenGate for Sybase by reviewing the certification matrix Certification Matrix.
-
Download the SDK FOR SAP ASE 16.0.3 available at https://me.sap.com/softwarecenter, and select the download based on the operating system where Oracle GoldenGate for Sybase is to be installed.
Note:
Do not install the SDK FOR SAP ASE 16.0 version, as this is known to cause issues for the Oracle GoldenGate Administration Service.
-
Run the following command to untar the downloaded package to a staging folder and then navigate to the extracted folder.
tar -xvf SDKASE160003PL_15-81009139.TGZ-C /path/staging cd /path/staging/ebf30977
-
Launch the
setup.bin
program and follow the prompts to select the installation folder../setup.bin
-
When choosing which Install Set to install, select Custom and at a minimum, install the Open Client>DB-Library package.
-
After the installation is complete, navigate to the Sybase SDK installation directory, as the user that will install Oracle GoldenGate.
Example:
[oracle@localhost]$ cd /opt/sap
-
Source the Sybase SDK environment variables. This sets the correct values for the
LD_LIBRARY_PATH
andSYBASE
session variables, which are required to create an Oracle GoldenGate for Sybase deployment.[oracle@locahost sap]$ . ./SYBASE.sh
-
Run the following commands to confirm that both variables are set correctly and then proceed to create the deployment.
[oracle@locahost sap]$ echo $LD_LIBRARY_PATH [oracle@locahost sap]$ echo $SYBASE
Sample Output:
[oracle@localhost sap]$ echo $LD_LIBRARY_PATH /opt/sap/OCS-16_0/lib:/opt/sap/OCS-16_0/lib3p64: /opt/sap/OCS-16_0/lib3p: [oracle@localhost sap]$ echo $SYBASE /opt/sap/
Note:
When creating the deployment, ensure that both the
LD_LIBRARY_PATH
andSYBASE
variables are listed in the Environment Variables section of Step 3, of the Oracle GoldenGate Configuration Assistant. If not, manually add any variables that are missing, using the values from your system and continue with the deployment creation.