Ways to uninstall and delete Goldengate

How to uninstall goldengate on Linux, Unix:

Programme I

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 * THEN:GG SCI (dbserver1) 2> stop MGR Manager process is required from other GGS processes. Are you sure your 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. Programme II

1, stop service:

Stop * Stop Mgr

2, delete the directory:

RM-RF ggate

3, delete the user:

sql> drop user gate01 cascade;   drop user gate01 cascade  *   error at line 1:   ORA-00604:  error occurred at recursive sql level 2   ORA-20782: GoldenGate  DDL Replication Error: Code :ORA-20782: Cannot DROP  object used  in goldengate replication while trigger is enabled. consult   goldengate documentation and/or call goldengate technical support if  You wish   to do so., error stack: ora-06512: at line 226   ora-06512: at line 951       Sql> drop trigger ggs_ddl_ Trigger_before;     trigger dropped.     sql> drop user gate01 cascade;   drop user gate01 cascade  *   Error at line 1:   ora-00604: error occurred at recursive sql  Level 1   Ora-14452: attempt to create, alter or drop an index  on temporary table already   In use    

Solution:

1, detect the GATE01 user's table: Conn GATE01/GATE01 select table_name from tabs; TABLE_NAME------------------------------Ggs_ddl_primary_keys ggs_stick 2, query corresponding sid,serial#: SELECT SID, Serial # from v$session where sid = (select Sid from V$lock