17 Uninstalling Oracle GoldenGate

This chapter contains instructions for removing Oracle GoldenGate processes and files from the local system.

This chapter includes the following sections:

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.

Note:

Follow these sections in the order they are presented.

17.1 Stopping Processes

This procedure stops the Extract and Replication processes. Leave Manager running until directed to stop it.

On all Systems:

  1. Run the command shell.

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

    STOP ER *
    
  6. Stop the Manager process.

    STOP MANAGER
    

17.2 Removing the DDL Environment

(Valid when the DDL trigger is being used to support DDL replication.) This procedure removes all of the Oracle GoldenGate DDL objects from the DDL schema 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.

    STOP ER *
    
  4. Log in to SQL*Plus as a user that has SYSDBA privileges.

  5. Disconnect all sessions that ever issued DDL, including those of Oracle GoldenGate processes, SQL*Plus, business applications, and any other software that uses Oracle. Otherwise the database might generate an ORA-04021 error.

  6. Run the ddl_disable script to disable the DDL trigger.

  7. Run the ddl_remove script to remove the Oracle GoldenGate DDL trigger, the DDL history and marker tables, and other associated objects. This script produces a ddl_remove_spool.txt file that logs the script output and a ddl_remove_set.txt file that logs environment settings in case they are needed for debugging.

  8. Run the marker_remove script to remove the Oracle GoldenGate marker support system. This script produces a marker_remove_spool.txt file that logs the script output and a marker_remove_set.txt file that logs environment settings in case they are needed for debugging.

17.3 Removing Database Objects

Follow these instructions to remove Oracle GoldenGate objects that are configured within an Oracle database. Specific steps and commands may not apply to your 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.

    STOP ER *
    
  4. Stop the Manager process.

    STOP MANAGER
    
  5. In GGSCI, log into the database with the DBLOGIN (or the MININGDBLOGIN command if you need to remove a database logmining server from a downstream mining database). [MINING]DBLOGIN requires privileges granted in the dbms_goldengate_auth.grant_admin_privilege procedure.

    [MINING]DBLOGIN USERIDALIAS alias
    
  6. In GGSCI, run any or all of the following commands, depending on your configuration. See Reference for Oracle GoldenGate for Windows and UNIX.

    • Disable schema-level supplemental logging (wildcards not allowed):

      DELETE SCHEMATRANDATA schema [NOSCHEDULINGCOLS | ALLCOLS]
      
    • Disable table-level supplemental logging.

      DELETE TRANDATA [container.]schema.table  [NOSCHEDULINGCOLS | ALLCOLS]
      
    • (Bidirectional configuration) Remove the Oracle trace table.

      DELETE TRACETABLE [container.]schema.table
      
    • (Classic capture configuration) Disable log retention and remove the underlying Oracle Streams capture process. DBLOGIN requires privileges shown in Table 11-3 on .

      UNREGISTER EXTRACT group LOGRETENTION
       
      
    • (Integrated capture configuration) Remove the database logmining server from an Oracle mining database.

      DELETE EXTRACT group
      UNREGISTER EXTRACT group DATABASE 
      
  7. Run the following Oracle procedure to remove the privileges from the Oracle GoldenGate admin users for both classic and integrated processes.

    dbms_goldengate_auth.revoke_admin_privilege('ggadm')
    

On a Target System:

  1. Stop Replicat.

    STOP REPLICAT group  
    
  2. Log into the database with the DBLOGIN command.

    DBLOGIN USERIDALIAS alias
    
  3. (Integrated Replicat) Delete the Replicat group. This command also deletes the inbound server from the target database.

    DELETE REPLICAT group  
    
  4. (Nonintegrated Replicat) Remove the Replicat checkpoint table by running the DELETE CHECKPOINTTABLE command.

    DELETE CHECKPOINTTABLE [container.]schema.table
    

17.4 Uninstalling Oracle GoldenGate Using Oracle Universal Installer

Follow these instructions to uninstall Oracle GoldenGate through an interactive session of Oracle Universal Installer (OUI).

CAUTION:

Before removing Oracle GoldenGate through OUI, follow the instructions in Section 17.2, "Removing the DDL Environment" (if using trigger-based DDL capture) and Section 17.3, "Removing Database Objects." These procedures require the use of Oracle GoldenGate commands and scripts, which are removed by the OUI uninstaller.

The following items are removed in this process.

  • The Oracle GoldenGate home directory in the Oracle central inventory.

  • The Oracle GoldenGate installation directory.

  • The Oracle GoldenGate Manager service, if installed on Windows.

  • The Oracle GoldenGate Windows Registry entries

To remove Oracle GoldenGate from the 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.

    STOP ER *
    
  4. Stop the Manager process.

    STOP MANAGER
    
  5. Run the following script from the Oracle GoldenGate installation directory.

    UNIX and Linux:

    OGG_home/deinstall/deinstall.sh
    

    Windows:

    OGG_home/deinstall/deinstall.bat
    

17.5 Uninstalling Oracle GoldenGate Manually

Follow these instructions to remove the Oracle GoldenGate environment from the system manually through the operating system.

17.5.1 Manually 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.

  1. 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. (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 Extract and Replicat processes are stopped. Stop any that are running.

    STATUS ER *
    STOP ER *
    
  3. (Cluster) Use the Cluster Administrator tool to take the Manager resource offline.

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

  5. Click Start then 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. Run the INSTALL utility with the following syntax.

    install deleteevents deleteservice
    
  8. (Cluster) Move the cluster group to the next node in the cluster, and repeat from .

17.5.2 Manually Removing the Oracle GoldenGate Files

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

  1. In GGSCI, verify that all processes are stopped. Stop any that are running.

    STATUS MANAGER
    STATUS ER *
    STOP MANAGER
    STOP ER *
    
  2. Exit GGSCI.

    EXIT
    
  3. Remove the Oracle GoldenGate installation directory.