5 Oracle GoldenGate Programs

This chapter describes the programs issued directly from the native command line of the Linux, UNIX, or Windows platforms.

The following environment variables need to be set up from the bash prompt to be able to use command line utilities such as defgen:

• OGG_HOME: Full path of the Oracle GoldenGate installation. Example:

  export OGG_HOME=/u01/ogg

• OGG_VAR_HOME: Path of the deployment's var directory. Example:

  export OGG_VAR_HOME=/u02/ogg/deployments/ora/var

• ODBCSYSINI: Valid for SQL Server. Provide the path to the included Microsoft driver supplied by Oracle GoldenGate. This path is the msodbc folder of the Oracle GoldenGate installation. Example:

  export ODBCSYSINI=$OGG_HOME/msodbc

• ODBCINST: Valid for PostgreSQL. Provide the path of the included Oracle GoldenGate driver's odbcinst.ini file located in the datadirect folder of the Oracle GoldenGate installation. Example:

  export ODBCINST=$OGG_HOME/datadirect/odbcinst.ini

• ODBCINI: When using a DSN for connectivity to databases such as PostgreSQL or SQL Server, set this variable to the full path of the odbc.ini file that contains the DSN entry. Example:

  export ODBCINI=/u02/ogg/deployments/mssql/odbc.ini