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.

For detailed instructions and requirements, refer to the SAP documentation. 1. Verify which operating systems are supported for this version of Oracle GoldenGate for Sybase by reviewing the certification matrix Certification Matrix.

  1. 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.

  1. 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

  2. Launch the setup.bin program and follow the prompts to select the installation folder.

    ./setup.bin

  3. When choosing which Install Set to install, select Custom and at a minimum, install the Open Client>DB-Library package.

  4. 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

  5. Source the Sybase SDK environment variables. This sets the correct values for the LD_LIBRARY_PATH and SYBASE session variables, which are required to create an Oracle GoldenGate for Sybase deployment.

    [oracle@locahost sap]$ . ./SYBASE.sh

  6. 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 and SYBASE 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.