5 Uninstalling Oracle GoldenGate

This chapter contains platform-specific instructions for removing Oracle GoldenGate from a system.

It contains the following sections:

Warning:

These procedures assume that you no longer need the data in the Oracle GoldenGate trails, and that you no longer need to preserve the current Oracle GoldenGate environment. To preserve your current environment and data, make a backup of the Oracle GoldenGate directory and all subdirectories before starting this procedure.

5.1 Uninstalling Oracle GoldenGate from Linux or UNIX (includes USS)

Follow these instructions to remove Oracle GoldenGate from an IBM z/OS source or target system, or from a Linux or UNIX system that is being used for remote delivery to DB2 on z/OS.

On all Systems:

  1. Run the command shell.

  2. (Suggested) Log on as the system administrator or as a user with permission to issue Oracle GoldenGate commands and delete files and directories from the operating system.

  3. Change directories to the Oracle GoldenGate installation directory.

  4. Run GGSCI.

  5. Stop all Oracle GoldenGate processes.

  6. Stop the Manager process.

On a Source System:

Log into the database with the DBLOGIN command, and then run the DELETE TRANDATA command to alter the tables to DATA CAPTURE NONE.

On any System Where a Replicat Checkpoint Table Exists:

Log into the database with the DBLOGIN command, and then remove the Replicat checkpoint table by running the DELETE CHECKPOINTTABLE command.

On all systems:

  1. Make certain all processes are stopped (including GGSCI).

  2. Remove the Oracle GoldenGate files by removing the installation directory.

5.2 Removing Oracle GoldenGate from Windows Cluster

Follow these instructions to remove Oracle GoldenGate from a Windows cluster that is being used for remote delivery to DB2 on an IBM z/OS system.

  1. Working from the node in the cluster that owns the cluster group that contains the Manager resource, run GGSCI and then stop any Extract and Replicat processes that are still running.

  2. Use the Cluster Administrator tool to take the Manager resource offline.

  3. Right click the resource and select Delete to remove it.

  4. Click Start then Run and type cmd in the Run dialog box to open the command console.

  5. Change directories to the Oracle GoldenGate installation directory.

  6. Run the INSTALL utility with the following syntax to stop Oracle GoldenGate events from being reported to the Windows Event Manager and to remove the Manager service.

    install deleteevents deleteservice
    
  7. Move the cluster group to the next node in the cluster, and repeat from step 4.

  8. Follow the instructions in Section 5.3, "Uninstalling Oracle GoldenGate from Windows (Non-Cluster)".

5.3 Uninstalling Oracle GoldenGate from Windows (Non-Cluster)

Follow these instructions to remove Oracle GoldenGate from a Windows system that is being used for remote delivery to DB2 on an IBM z/OS system.

On all Systems:

  1. (Recommended) Log on as the system administrator or as a user with permission to issue Oracle GoldenGate commands and to delete files and directories from the operating system.

  2. From the Oracle GoldenGate installation folder, run GGSCI.

  3. Stop all Oracle GoldenGate processes.

  4. Stop the Manager program or service.

  5. Click Start then Run and type cmd in the Run dialog box to open the command console.

  6. Change directories to the Oracle GoldenGate installation directory.

  7. Run the INSTALL utility with the following syntax to stop Oracle GoldenGate events from being reported to the Windows Event Manager and to remove the Manager service.

    install deleteevents deleteservice
    

On a Source System:

Log into the database with the DBLOGIN command, and then run the DELETE TRANDATA command to alter the tables to DATA CAPTURE NONE.

On any System Where a Replicat Checkpoint Table Exists:

Log into the database with the DBLOGIN command, and then remove the Replicat checkpoint table by running the DELETE CHECKPOINTTABLE command.

On all Systems:

Make certain all processes are stopped (including GGSCI) and then remove the Oracle GoldenGate files by removing the installation directory.