oracle ogg删除进程,删除ogg 无法删除的进程

之前不知道是谁添加的进程,在抽取里面添加了R进程,参数文件已经被删除了,但是info all  还是能看到进程在,无法删除

报错 表或者视图不存在   10046  发现执行下面的sql,但是数据库里面就根本没有这个表

SELECT count(*) FROM dba_goldengate_inbound WHERE server_name = :1 and rownum = 1

GGSCI (orcl1.dba.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     D_DW     00:00:00      00:00:04

EXTRACT     RUNNING     E_TEST       00:00:00      00:00:08

REPLICAT    ABENDED     R_TEST2      00:00:00      71:54:20

GGSCI (orcl1.dba.com) 2> dblogin userid goldengate  password oracle

Successfully logged into database.

GGSCI (orcl1.dba.com as ) 3> delete R_TEST2

2016-07-04 21:43:32  ERROR   OGG-02538  Cannot unregister REPLICAT R_TEST2 because of the following SQL error: OCI Error ORA-00942: table or view does not exist (status = 942). See Replicat user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

GGSCI (orcl1.dba.com as ) 4> add replicat R_TEST2

ERROR: REPLICAT R_TEST2 already exists.

GGSCI (orcl1.dba.com as ) 5> delete R_TEST2 !

2016-07-04 21:44:47  ERROR   OGG-02538  Cannot unregister REPLICAT R_TEST2 because of the following SQL error: OCI Error ORA-00942: table or view does not exist (status = 942). See Replicat user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

Deleted REPLICAT R_TEST2.

GGSCI (orcl1.dba.com as ) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     D_DW     00:00:00      00:00:03

EXTRACT     RUNNING     E_TEST       00:00:00      00:00:03

GGSCI (orcl1.dba.com as ) 7>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值