Installing Oracle GoldenGate for Sybase

Oracle GoldenGate for Sybase provides real-time, log-based change data capture and allows users to replicate data from supported Sybase ASE databases, to Sybase ASE or other major databases including Oracle Database, HP NonStop, IBM DB2, SQL Server, MySQL etc.

Many companies use Oracle GoldenGate for Sybase to perform zero-downtime data migrations, in addition to enabling high availability, and real-time data integration for transactional and analytical systems.

Though documented in the Oracle GoldenGate for Sybase Installation Guide, there are still many questions on how to install Oracle GoldenGate for Sybase. In this blog, I want to walk you through the setup steps and discuss the tip and tricks in the installation process.

You can find below the steps for installing Oracle GoldenGate for Sybase on LINUX:

Step 1: Download Oracle GoldenGate for Sybase

You can download Oracle GoldenGate from Oracle eDelivery or support.oracle.com. This example downloads the 11.2.1.0.1 for Sybase 15.5 from Oracle eDelivery. The following is a screenshot of the eDelivery download page:


Tip:

Why I got the "cannot execute binary file” error when running ggsci?
If you get the 'cannot execute error', most of the times this is due to the version mismatch with your server. Make sure that you download the right Oracle GoldenGate build, for example 32 bit version or 64 bit version, based on your database and OS server version.

Step 2: Unzip the Oracle GoldenGate zip File.

Unzip the downloaded file with the following commands:

unzip V32422-01.zip
tar xvf ggs_Linux_x86_sybase15_5_32bit.tar

Check the shared library path:

env |grep LD_LIBRARY_PATH
LD_LIBRARY_PATH=/home/sybase/ASE-15_0/lib:/home/sybase/DataAccess/ODBC/lib:
/home/sybase/OCS-15_0/lib:/home/sybase/OCS-15_0/lib3p:/home/sybase/ASE-15_0/lib:
/home/sybase/DataAccess/ODBC/lib:/home/sybase/OCS-15_0/lib:
/home/sybase/OCS-15_0/lib3p:

Add the OGG installation path to the path (PATH) and shared library path (LD_LIBRARY_PATH) environment variables:

export PATH=/home/ogg_for_sybase:$PATH
export LD_LIBRARY_PATH=/home/ogg_for_sybase:$LD_LIBRARY_PATH

Step 3: Create Oracle GoldenGate

Run the ggsci command in the folder where Oracle GoldenGate files are unzipped:

./ggsci
GGSCI> create subdirs
Parameter files                /home/ogg_for_sybase/dirprm: already exists
Report files                   /home/ogg_for_sybase/dirrpt: created
Checkpoint files               /home/ogg_for_sybase/dirchk: created
Process status files           /home/ogg_for_sybase/dirpcs: created
SQL script files               /home/ogg_for_sybase/dirsql: created
Database definitions files     /home/ogg_for_sybase/dirdef: created
Extract data files             /home/ogg_for_sybase/dirdat: created
Temporary files                /home/ogg_for_sybase/dirtmp: created
Stdout files                   /home/ogg_for_sybase/dirout: created
GGSCI>Exit

Step 4: Create Database User in Sybase for Replication.

In the Sybase database, create a database user for Oracle GoldenGate, and grant the sa_role and the replication_role to that user:

Isql –Usa –P –SASE1

1> sp_addlogin ogguser,ogguser
2> go
Password correctly set.
Account unlocked.
New login created.
(return status = 0)
1> sp_adduser ogguser
2> go
New user added.
(return status = 0)
1> sp_role 'grant', replication_role, ogguser
2> go
Authorization updated.
(return status = 0)

1> sp_role 'grant', sa_role, ogguser
2> go
Authorization updated.
(return status = 0)

Step 5: Start GGSCI

export DSQUERY=ASE1
>./ggsci
GGSCI> edit param mgr 
port 15002
GGSCI> start mgr 
GGSCI> info mgr
Manager is running (IP port syslab.us.oracle.com.15002)

Tip:

Why do I get the "unrecognized parameter (SOURCEDB)" error?
Make sure you set the DSQUERY environment variable, you can also include the source DB server in the dblogin command shown as follows:

dblogin sourcedb sydatabase@ASE1 userid ogguser password ogguser

 
          

With these few steps, you then complete the steps for installing Oracle GoldenGate for Sybase.

As a reminder, you can refer to Oracle GoldenGate Sybase Installation and Setup Guide for more information.

In the next blog, I will discuss how to setup Oracle GoldenGate to perform a one-way replication from Sybase ASE database to Oracle Database.  Please let me know if you have any questions or comments on the tips I provided above.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
23
24
25
26
27
28
29
30
   
       
Today