首页 > 代码库 > 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的方法
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。