1. Installing Oracle GoldenGate Classic Architecture
  2. Uninstalling Oracle GoldenGate Classic Architecture for Non-Oracle Databases

7 Uninstalling Oracle GoldenGate Classic Architecture for Non-Oracle Databases

Learn how to uninstall Oracle GoldenGate for non-Oracle databases.

Topics:

Removing Oracle GoldenGate Database Objects

Use the following instructions to remove database objects and stopping processes for your configuration. Some steps and commands may not apply to your configuration, however other instructions are applicable to all databases (until specified).

For SQL Server, use these steps to remove supplemental logging and any Oracle GoldenGate CDC Cleanup objects from the source database in the Oracle GoldenGate capture configuration, and to remove the Replicat checkpoint table in the apply configuration. 

On a Source System:

  1. 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.

  2. Run ggsci from the Oracle GoldenGate directory.

  3. Stop all Oracle GoldenGate processes if not already done.

    STOP EXTRACT *

  4. Stop the Manager process.

    STOP MANAGER

  5. Issue the following command to log into the source database, see SOURCEDB. 

    DBLOGIN SOURCEDB {data_source | database@host:port} USERIDALIAS alias

  6. Remove any heartbeat table entries by running the DELETE HEARTBEATTABLE command.

  7. For a SQL Server Extract configuration, remove the Oracle GoldenGate CDC cleanup job and objects if they were created.

    1. Open a command prompt and change to the Oracle GoldenGate installation folder.

    2. Run the ogg_cdc_cleanup_setup.sh/bat file as follows:
      ogg_cdc_cleanup_setup.sh/bat dropJob userid password database_name servername\instancename schema

      The userid password must be a valid SQL Server login and password for a sysadmin user. database_name servername\instancename are the source database name and instance name. If only server name is listed, then the default instance will be used to connect to the database server. schema is the schema name listed in the GLOBALS file, with the GGSCHEMA parameter.

      For example: 

      ogg_cdc_cleanup_setup.bat dropJob ggsuser ggspword db1 server1\inst1 ogg

  8. Remove supplemental logging from tables that were enabled with it. See DELETE TRANDATA. Remove supplemental logging for any filter tables used for bi-directional replication as well. You can use a wildcard to specify multiple table names. 

    DELETE TRANDATA owner.table
  9. For PostgreSQL, the registered replication slot must be deleted after removing the Extract, otherwise the database logs will continue to grow.
    DELETE EXTRACT extname
UNREGISTER EXTRACT extname

On a Target System:

  1. Stop Replicat.
    STOP REPLICAT group
  2. Issue the following command to log into the target database. See SOURCEDB.
    DBLOGIN SOURCEDB {data_source | database@host:port} USERIDALIAS alias
  3. Remove the Replicat checkpoint tables and heartbeat by running the DELETE CHECKPOINTTABLE and DELETE HEARTBEATTABLE commands.
    DELETE CHECKPOINTTABLE schema.table
    DELETE HEARTBEATTABLE

Parent topic: Uninstalling Oracle GoldenGate Classic Architecture for Non-Oracle Databases

Uninstalling Oracle GoldenGate from a Source DB2 for i System

  1. Ensure that all Oracle GoldenGate processes are stopped, and any database objects are removed, based on instructions provided in Removing Database Objects.
  2. Delete the Oracle GoldenGate library. Specify I (ignore) for any prompts about unsaved journal receivers.
    clrlib library
dltlib library

Parent topic: Uninstalling Oracle GoldenGate Classic Architecture for Non-Oracle Databases

Uninstalling Oracle GoldenGate from a Linux System

Follow these instructions to remove Oracle GoldenGate from a Linux system.

  1. Run the command shell of the operating system.
  2. Ensure all Oracle GoldenGate processes are stopped, and any database objects have been removed, based on the instructions in Removing Database Objects.
  3. Remove the Oracle GoldenGate files by removing the installation directory.

Parent topic: Uninstalling Oracle GoldenGate Classic Architecture for Non-Oracle Databases

Uninstalling Oracle GoldenGate from a Windows System

Follow these instructions to remove Oracle GoldenGate from a Windows system.

  1. Log on to the operating system 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. Ensure all Oracle GoldenGate processes are stopped, and any database objects have been removed based on instructions in Removing Database Objects.

  3. (Windows Cluster) Use the Cluster Administrator tool to take the Manager resource offline.

  4. (Windows Cluster) Right click the resource and select Delete to remove it.

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

  6. Change directories to the Oracle GoldenGate installation directory.

  7. Remove the Manager service and events using the INSTALL utility with the following syntax:
    INSTALL DELETEEVENTS DELETESERVICE

  8. (Windows Cluster) Move the cluster group to the next node in the cluster and repeat the process from step 6.

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

Parent topic: Uninstalling Oracle GoldenGate Classic Architecture for Non-Oracle Databases