卸載、刪除GoldenGate的方法

Linux、UNIX上卸載GoldenGate的方法：

方案一 

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: GGSCI (dbserver1) 2> stop MGR Manager process is required by other GGS processes. Are you sure you 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. 方案二 

1、停服務： 

stop *   stop mgr 

2、刪除目錄：
 

rm -rf ggate 

3、刪除使用者：
 

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    

解決辦法：

 

1、查出gate01使用者的表：   conn gate01/gate01   select table_name from tabs;   TABLE_NAME   ------------------------------   GGS_DDL_PRIMARY_KEYS   GGS_STICK     2、查詢對應sid,serial#:   select sid, serial#  from v$session where sid =  (select sid  from v$lock