15 Uninstalling Oracle GoldenGate with Oracle Database
Topics:
- Stopping Processes
- Removing the DDL Environment
- Removing Database Objects
- Uninstalling Oracle GoldenGate Using Oracle Universal Installer
- Uninstalling Oracle GoldenGate Manually
Parent topic: Uninstalling Oracle GoldenGate
Stopping Processes
This procedure stops the Extract and Replication processes. Leave Manager running until directed to stop it.
On all Systems:
Parent topic: Uninstalling Oracle GoldenGate with Oracle Database
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.
Parent topic: Uninstalling Oracle GoldenGate with Oracle Database
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:
-
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.
-
Run
ggsci
from your Oracle GoldenGate directory. -
Stop all Oracle GoldenGate processes.
STOP ER *
-
Stop the Manager process.
STOP MANAGER
-
In GGSCI, log into the database with the
DBLOGIN
(or theMININGDBLOGIN
command if you need to remove a database logmining server from a downstream mining database).[MINING]DBLOGIN
requires privileges granted in thedbms_goldengate_auth.grant_admin_privilege
procedure.[MINING]DBLOGIN USERIDALIAS
alias
-
In GGSCI, run any or all of the following commands, depending on your configuration.
-
Disable schema-level supplemental logging (wildcards are 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.
DBLOGIN
requires privileges shown in Log Retention Options.UNREGISTER EXTRACT
group
LOGRETENTION -
(Integrated capture configuration) Remove the database logmining server from an Oracle mining database.
DELETE EXTRACT
group
UNREGISTER EXTRACTgroup
DATABASE
-
-
Run the following Oracle procedure to remove the privileges from the Oracle GoldenGate administration users for both classic and integrated processes.
dbms_goldengate_auth.revoke_admin_privilege('ggadm')
On a Target System:
Parent topic: Uninstalling Oracle GoldenGate with Oracle Database
Uninstalling Oracle GoldenGate Using Oracle Universal Installer
Follow these instructions to uninstall Oracle GoldenGate through an interactive session of Oracle Universal Installer (OUI).
WARNING:
Before removing Oracle GoldenGate through OUI, follow the instructions in Removing the DDL Environment (if using trigger-based DDL capture) and 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:
Parent topic: Uninstalling Oracle GoldenGate with Oracle Database
Uninstalling Oracle GoldenGate Manually
Follow these instructions to remove the Oracle GoldenGate environment from the system manually through the operating system.
- Manually Removing Oracle GoldenGate Windows Components
- Manually Removing the Oracle GoldenGate Files
Parent topic: Uninstalling Oracle GoldenGate with Oracle Database
Manually Removing Oracle GoldenGate Windows Components
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.
Parent topic: Uninstalling Oracle GoldenGate Manually
Manually Removing the Oracle GoldenGate Files
Perform these steps on all systems to remove the Oracle GoldenGate installation directory.
Parent topic: Uninstalling Oracle GoldenGate Manually