In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Thursday, December 7, 2017

Steps to uninstall oracle Goldengate in Linux

Steps to uninstall/deinstall oracle Goldengate in Linux machine

1. stop the goldengate manager and extract/replicat processes
2. invoke the deinstall.sh scipt
3. drop the goldengate user in oracle database.

Example:-


[oracle@vm2 gghome1]$ ./ggsci


Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jul 21 2017 20:31:38
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.



GGSCI (vm2.localdomain) 1> 
GGSCI (vm2.localdomain) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      02:44:26    

GGSCI (vm2.localdomain) 1> stop *
GGSCI (vm2.localdomain) 1> stop mgr


[oracle@vm2 ~]$ . oraenv
ORACLE_SID = [targetdb] ? 
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@vm2 ~]$ cd /u01/gghome1/
[oracle@vm2 gghome1]$ ls
[oracle@vm2 gghome1]$ cd deinstall/
[oracle@vm2 deinstall]$ ./deinstall.sh 

ALERT: Ensure all the processes running from the current Oracle Home are shutdown prior to running this software uninstallation script.

Proceed with removing Oracle GoldenGate home: /u01/gghome1 (yes/no)? [no] 
yes
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 5199 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-12-07_06-07-41PM. Please wait ...
Oracle Universal Installer, Version 12.2.0.1.4 Production
Copyright (C) 1999, 2016, Oracle. All rights reserved.

Starting deinstall


Deinstall in progress (Thursday, December 7, 2017 6:11:53 PM IST)
............................................................... 100% Done.

Deinstall successful

End of install phases.(Thursday, December 7, 2017 6:12:55 PM IST)
End of deinstallations
Please check '/u01/app/oraInventory/logs/silentInstall2017-12-07_06-07-41PM.log' for more details.
[oracle@vm2 deinstall]$ 
[oracle@vm2 deinstall]$ 


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 305
ORA-06512: at line 1267


SQL> select * from dba_triggers where owner='GGUSER';

no rows selected

SQL> r
  1  select a.obj#, a.sys_evts, b.name from trigger$ a, obj$ b
  2* where a.sys_evts>0  and a.obj#=b.obj# and baseobject=0

      OBJ#   SYS_EVTS NAME
---------- ---------- ------------------------------
      8785   128 AW_DROP_TRG
     12783 8192 AW_REN_TRG
     12781 4096 AW_TRUNC_TRG
     54484    64 CDC_ALTER_CTABLE_BEFORE
     54485    32 CDC_CREATE_CTABLE_AFTER
     54486    32 CDC_CREATE_CTABLE_BEFORE
     54487   128 CDC_DROP_CTABLE_BEFORE
     56590 4224 XDB_PI_TRIG
     64167     2 OLAPISHUTDOWNTRIGGER
     64166     1 OLAPISTARTUPTRIGGER
     13476 8416 NO_VM_DDL

      OBJ#   SYS_EVTS NAME
---------- ---------- ------------------------------
     13477   128 NO_VM_DROP_A
     55387 8256 EXPFIL_ALTEREXPTAB_MAINT
     55384   128 EXPFIL_DROPOBJ_MAINT
     55385   128 EXPFIL_DROPUSR_MAINT
     55386    96 EXPFIL_RESTRICT_TYPEEVOLVE
     57367 4096 RLMGR_TRUNCATE_MAINT
     66005   128 SDO_NETWORK_DROP_USER
     62264   128 SDO_DROP_USER
     65930     524256 SDO_GEOR_ADDL_TRIGGER
     65929     524256 SDO_GEOR_BDDL_TRIGGER
     65928     4 SDO_GEOR_ERR_TRIGGER

      OBJ#   SYS_EVTS NAME
---------- ---------- ------------------------------
     62532    32 SDO_ST_SYN_CREATE
     62368   128 SDO_TOPO_DROP_FTBL
     69475     1 MGMT_STARTUP
     73477     524256 GGS_DDL_TRIGGER_BEFORE

26 rows selected.

SQL> drop trigger GGS_DDL_TRIGGER_BEFORE;

Trigger dropped.

SQL> drop user gguser cascade;
drop user gguser 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


SQL> 
SQL> conn / as sysdba
Connected.
SQL> drop user gguser cascade;

User dropped.

SQL> 

hope, this helps you.

Thanks and Regards,
Rajesh Kumar Govindarajan. 

No comments:

free counters
 
Share/Bookmark