Uninstalling Oracle GoldenGate

Stop the processes on source and target

dblogin userid gguser password gguser

STOP ER *

STOP MANAGER

Remove DDL env

Disconnect all sessions that ever issued DDL, including those of Oracle GoldenGate processes,

Go to GG home and login to DB as sysdba

Run below scripts –

@ddl_disable

@ddl_remove 

@marker_remove 

Remove database objects

Source:

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

dblogin userid gguser password gguser

DELETE SCHEMATRANDATA us01

Disable table-level supplemental logging (for all tables relicated)

DELETE TRANDATA us01.t1

(Classic capture configuration)  Disable log retention and remove the underlying Oracle Streams capture process

UNREGISTER EXTRACT ext1 LOGRETENTION

GGSCI (ggsource.localdomain) 7> d

dbms_goldengate_auth.revoke_admin_privilege(‘gguser’);

run deinstall

OGG_home/deinstall/deinstall.sh