Linux下解除安裝GoldenGate

1 開啟終端，進入GoldenGate安裝目錄

$ cd /u01/ogg

2 進入GoldenGate環境

$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

GGSCI (localhost) 1>

3 停止所有的管理、抽取、複製程式

GGSCI (localhost) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

EXTRACT STOPPED EXT_L 00:00:00 00:23:49

REPLICAT STOPPED REP_L 00:00:00 00:23:52

GGSCI (localhost) 2>

上圖表示三個程式都已經停止了。

假如有程式還處於running狀態，則可用stop命令來停止。

例子：stop ext_l，stop rep_l, stop mgr

4 退出GoldenGate環境

GGSCI (localhost) 2> exit

[oracle@localhost ogg]$

5 執行SQL*Plus，並用具有SYSDBA許可權的使用者登入

[oracle@localhost ogg]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期三 7月 29 11:28:14 2015

連線到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

6 斷開產生過DDL的所有會話，包括GoldenGate程式、SQL*Plus、業務應用、以及其他任何使用Oracle的軟體。否則資料庫可能會報ORA-04021的錯誤

7 執行ddl_disabl.sql指令碼來禁用DDL觸發器

SQL> @ddl_disable

觸發器已更改

SQL>

8 執行ddl_remove.sql指令碼來移除GoldenGate DDL觸發器、DDL歷史和標記表以及其他相關的物件。這個指令碼會生成一個ddl_remove_spool.txt檔案，記錄了指令碼的輸出，還有一個ddl_remove_set.txt檔案，記錄了當前的使用者環境設定，以防debug之用。

SQL> @ddl_remove

DDL replication removal script.

WARNING: this script removes all DDL replication objects and data.

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

NOTE: The schema must be created prior to running this script.

Enter Oracle GoldenGate schema name:ogg

Working, please wait ...

Spooling to file ddl_remove_spool.txt

Script complete.

SQL>

9 執行marker_remove.sql指令碼來移除GoldenGate marker支援系統。這個指令碼生成一個marker_remove_spool.txt和marker_remove_set.txt檔案，作用和上面的相同

SQL> @ddl_remove

DDL replication removal script.

WARNING: this script removes all DDL replication objects and data.

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

NOTE: The schema must be created prior to running this script.

Enter Oracle GoldenGate schema name:ogg

Working, please wait ...

Spooling to file ddl_remove_spool.txt

Script complete.

SQL> @marker_remove

Marker removal script.

WARNING: this script removes all marker objects and data.

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

NOTE: The schema must be created prior to running this script.

Enter Oracle GoldenGate schema name:ogg

PL/SQL 過程已成功完成。

序列已刪除。

表已刪除。

Script complete.

SQL>

10 刪除GoldenGate使用者

SQL> drop user ogg cascade;

使用者已刪除。

SQL>

11 刪除ogg目錄

SQL> exit

[oracle@localhost ogg]$ cd ..

[oracle@localhost u01]$ remove -rf ogg

Linux下解除安裝GoldenGate

Linux下解除安裝GoldenGate

相關文章