首页 > 代码库 > Linux&UNIX上卸载GoldenGate的方法

Linux&UNIX上卸载GoldenGate的方法

1. Log on to the database server (as oracle) where the GoldenGate software is installed.[root@oracle ~]# su - oracle[oracle@oracle ~]$ 2.Change directory to the GoldenGate home:[oracle@oracle GG]$ pwd/u01/GG[oracle@oracle GG]$3. Start GGSCI  and  Stop all GoldenGate processes:GGSCI (oracle.11g) 3> stop REPLICAT *     //如果是源库则 stop EXTRACT *REPLICAT RORA_T1 is already stopped.GGSCI (oracle.11g) 4> stop MGrManager is already stopped.GGSCI (oracle.11g) 5> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     STOPPED                                           REPLICAT    STOPPED     RORA_T1     00:00:00      00:13:06    GGSCI (oracle.11g) 6> exit                //退出ggsci4. Remove the GoldenGate files:[oracle@oracle u01]$ rm -rf GG[oracle@oracle u01]$ 5. Logon to the Oracle database as SYSDBA and drop the GoldenGate Adminuser. Include the CASCADE keyword:[oracle@oracle u01]$ sqlplus /nologSQL> conn /as sysdbaConnected.SQL> Drop user GGT CASCADE;                       Drop user GGT CASCADE*ERROR at line 1:ORA-01940: cannot drop a user that is currently connectedSQL>---删除连接SQL> select sid,serial#,status  from v$session where username=‘GGT‘;       SID    SERIAL# STATUS---------- ---------- --------         1        103 ACTIVE        43        425 ACTIVESQL> alter system kill session ‘1,103‘;System altered.SQL> alter system kill session ‘43,425‘;System altered.SQL>SQL> select sid,serial#,status  from v$session where username=‘GGT‘;       SID    SERIAL# STATUS---------- ---------- --------         1        103 KILLED        43        425 KILLEDSQL>--继续删除用户SQL> Drop user GGT CASCADE;User dropped.SQL> 

 

Linux&UNIX上卸载GoldenGate的方法