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

Thursday, December 7, 2017

[INS-75012] Software Location specified is already an existing oracle home and does not contain the selected oracle Goldengate install type

[INS-75012] Software Location specified is already an existing oracle home and does not contain the selected oracle Goldengate install type

Problem:- 
While installing oracle goldengate we got an error [INS-75012]  while selecting an oracle Goldengate home.

Reason :- 
The specified directory is already used by an existing deinstalled/improperly removed goldengate Home and oracle central oraInventory inventory.xml file contains the goldengate home information.


[oracle@vm2 ContentsXML]$ cat inventory.xml

Solution:- 
Invoke runInstaller to remove the oraInventory information from oracle central inventory.

Example:-
[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/app/oracle/product/11.2.0/db_1/oui/bin/

[oracle@vm2 bin]$ ./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/gghome"}
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_07-50-34PM. Please wait ...[oracle@vm2 bin]$ Oracle Universal Installer, Version 11.2.0.1.0 Production
Copyright (C) 1999, 2009, Oracle. All rights reserved.

Starting deinstall


Deinstall in progress (Thursday, December 7, 2017 7:50:45 PM IST)

End of install phases.(Thursday, December 7, 2017 7:50:45 PM IST)
End of deinstallations
Please check '/u01/app/oraInventory/logs/silentInstall2017-12-07_07-50-34PM.log' for more details.

[oracle@vm2 bin]$ 

Repeat the steps by replacing ORACLE_HOME in REMOVE_HOMES and remove the unwanted Goldengate home and try the installation again.

now inventory.xml file
[oracle@vm2 ContentsXML]$ cat inventory.xml
 

cancel the installation and Starting the goldengate configuration again by invoking runInstaller






Hope, this helps you.

Thanks and Regards,
Rajesh Kumar Govindarajan.

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. 
free counters
 
Share/Bookmark