Uninstall Oracle GOLDENGATE on LINUX

  1. Log on to the database server (as oracle) where the GoldenGate software is installed.

cd /home/oracle/ggs

  1. Start GGSCI:

./ggsci

  1. 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

  1. Change directory to the installation directory:

cd /home/oracle

  1. Remove the GoldenGate files:

rm -rf ggs

  1. 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.

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: