Oracle Goldengate Uninstall

Uninstalling the GoldenGate software is, as one would expect, the reverse of installing it. The de-installation is as simple as the installation and can be done by following the example below:

1. Log on to the database server (as oracle) where the GoldenGate software is installed.

2. Change directory to the GoldenGate home:

cd /home/oracle/ggs

3. Start GGSCI:

ggsci

4. Stop all GoldenGate processes:

GGSCI (dbserver1) 1> stop EXTRACT *

Or:

GGSCI (dbserver1) 1> stop REPLICAT *Chapter 2 [ 53 ]

Then:

GGSCI (dbserver1) 2> stop MGR

Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER …

Request processed.

Manager stopped.

GGSCI (dbserver1) 3> exit

5. Change directory to the installation directory:

cd /home/oracle

6. Remove the GoldenGate files:

rm -rf ggs

7. Logon to the Oracle database as SYSDBA and drop the GoldenGate Admin user. Include the CASCADE keyword:

sqlplus / as sysdba

SQL> drop user ggs_admin cascade;

User dropped.