4 Uninstalling Oracle GoldenGate

This chapter contains procedures for removing Oracle GoldenGate from the host system. It contains these sections:

Section 4.1, "Stopping Processes"
Section 4.2, "Removing Oracle GoldenGate Windows Components"
Section 4.3, "Removing the Checkpoint Table"
Section 4.4, "Manually Removing the Oracle GoldenGate Files"

This procedure assumes 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.

4.1 Stopping Processes

This procedure stops the Oracle GoldenGate processes. Leave Manager running until directed to stop it.

On all systems:

Run the command shell.
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.
Change directories to the Oracle GoldenGate installation directory.
Run GGSCI.
Stop all Oracle GoldenGate Replicat processes.
```
STOP REPLICAT *
```
Stop the Manager process.
```
STOP MANAGER
```

4.2 Removing Oracle GoldenGate Windows Components

(Valid for Windows installations) This procedure does the following: removes Oracle GoldenGate as a Windows cluster resource from a source or target Windows system, stops Oracle GoldenGate events from being reported to the Windows Event Manager, and removes the Manager service. Perform these steps on source and target systems.

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.
(Cluster) Working from the node in the cluster that owns the cluster group that contains the Manager resource, run GGSCI and make certain that all Replicat processes are stopped. Stop any that are running.
```
STATUS REPLICAT *
STOP REPLICAT *
```
(Cluster) Use the Cluster Administrator tool to take the Manager resource offline.
(Cluster) Right click the resource and select Delete to remove it.
Click Start then Run, and then type cmd in the Run dialog box to open the command console.
Change directories to the Oracle GoldenGate installation directory.
Run the INSTALL utility with the following syntax.
```
install deleteevents deleteservice
```
(Cluster) Move the cluster group to the next node in the cluster, and repeat from step 5.

4.3 Removing the Checkpoint Table

Perform these steps to remove the checkpoint table that is stored in the target database and used by Replicat to store its processing checkpoints.

Stop Replicat.
```
STOP REPLICAT group  
```

Log into the database with the DBLOGIN command.

DBLOGIN SOURCEDB database, USERIDALIAS alias

Delete the Replicat group.
```
DELETE REPLICAT group  
```
Delete the Replicat checkpoint table.
```
DELETE CHECKPOINTTABLE schema.table
```

4.4 Manually Removing the Oracle GoldenGate Files

Perform these steps on all systems to remove the Oracle GoldenGate installation directory.

In GGSCI, verify that all processes are stopped. Stop any that are running.
```
STATUS MANAGER
STATUS ER *
STOP MANAGER
STOP ER *
```
Exit GGSCI.
```
EXIT
```
Remove the Oracle GoldenGate installation directory.