Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article we will be discussing how to remove GoldenGate in Oracle.
The GoldenGate application is automatically removed by following the steps below.
1. LOGIN with the GOLDENGATE user and start the GoldenGate application.
1 2 3 | # su - goldengate $ /nfs_alan/mvp_vmx/ggsci |
2. Processes are STOPPED.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | GGSCI (mvpvmx1.hhuyanlab.local) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING RSCOTT 00:00:00 00:00:03 GGSCI (mvpvmx1.hhuyanlab.local) 3> stop rscott Sending STOP request to REPLICAT RSCOTT ... Request processed. GGSCI (mvpvmx1.hhuyanlab.local) 4> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT STOPPED RSCOTT 00:00:00 00:00:02 |
3. MGR Process is STOPPED.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | GGSCI (mvpvmx1.hhuyanlab.local) 5> 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 (mvpvmx1.hhuyanlab.local) 6> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED REPLICAT STOPPED RSCOTT 00:00:00 00:00:13 |
4. The Goldengate application is closed and the following script is run.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | GGSCI (mvpvmx1.hhuyanlab.local) 7> exit $ /nfs_alan/mvp_vmx/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: /nfs_alan/mvp_vmx (yes/no)? [no] yes Starting Oracle Universal Installer… Checking swap space: must be greater than 500 MB. Actual 16386 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-07-25_05-08-44PM. Please wait ...Oracle Universal Installer, Version 11.2.0.3.0 Production Copyright (C) 1999, 2011, Oracle. All rights reserved. Starting deinstall Deinstall in progress (Monday, July 25, 2016 5:08:52 PM EEST) ............................................................... 100% Done. Deinstall successful End of install phases.(Monday, July 25, 2016 5:09:18 PM EEST) End of deinstallations Please check '/u01/app/oraInventory/logs/silentInstall2016-07-25_05-08-44PM.log' for more details. |
5. When we go to the location where the application is installed, the result will be seen as follows.
6. Now we can delete all the files in this location.
1 2 3 4 5 6 7 8 9 10 | [goldengate@mvpvmx1 mvp_vmx]$ ll total 12 drwxr-x--- 2 goldengate oinstall 4096 Jul 25 17:09 dirdat drwxr-x--- 2 goldengate oinstall 4096 Jul 25 17:09 dirrpt drwxr-xr-x 3 goldengate oinstall 4096 Jul 25 17:08 oui [goldengate@mvpvmx1 mvp_vmx]$ rm -rf * [goldengate@mvpvmx1 mvp_vmx]$ ll total 0 |
