1. Log on to the database server (as oracle) where the GoldenGate
software is installed.
cd /home/oracle/ggs
2. Start GGSCI:
./ggsci
3. 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
4. Change directory to the installation directory:
cd /home/oracle
5. Remove the GoldenGate files:
rm -rf ggs
6. Logon to the Oracle database as SYSDBA and drop the GoldenGate Admin
user. Include the CASCADE keyword:
oracle@host.com:/opt/oracle INT$ sqlplus
/ as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Mon Jul 1 19:19:23 2013
Copyright (c) 1982, 2010, Oracle.
All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL> drop user gguser cascade;
drop user gguser cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-20782: Oracle GoldenGate DDL Replication Error: Code :ORA-20782:
Cannot
DROP object used in Oracle GoldenGate replication while trigger is
enabled.
Consult Oracle GoldenGate documentation and/or call Oracle GoldenGate
Technical
Support if you wish to do so., error stack: ORA-06512: at line 231
ORA-06512: at line 1030
SQL> select * from dba_triggers db where db.owner='GGUSER';
no rows selected
SQL> SELECT a.obj#,
a.sys_evts, b.nameFROM trigger$ a,obj$ b
WHERE a.sys_evts> 0AND a.obj#=b.obj#AND baseobject = 0;
OBJ# SYS_EVTS NAME
---------- ---------- ------------------------------
204316 8256 EXPFIL_ALTEREXPTAB_MAINT
204314 128 EXPFIL_DROPUSR_MAINT
204464 4096 RLMGR_TRUNCATE_MAINT
357922 64 CDC_ALTER_CTABLE_BEFORE
357923 32 CDC_CREATE_CTABLE_AFTER
357924 32 CDC_CREATE_CTABLE_BEFORE
357925 128 CDC_DROP_CTABLE_BEFORE
10520 8416 NO_VM_DDL
10521 128 NO_VM_DROP_A
204315 96 EXPFIL_RESTRICT_TYPEEVOLVE
204313 128 EXPFIL_DROPOBJ_MAINT
OBJ# SYS_EVTS NAME
---------- ---------- ------------------------------
805933 524256 GGS_DDL_TRIGGER_BEFORE
203646 4224 XDB_PI_TRIG
7743 128 AW_DROP_TRG
341038 4096 AW_TRUNC_TRG
341040 8192 AW_REN_TRG
16 rows selected.
SQL> drop trigger ggs_ddl_trigger_before;
Trigger dropped.
SQL> drop user gguser cascade;
User dropped.
