Chinaunix首页 | 论坛 | 博客
  • 博客访问: 360864
  • 博文数量: 86
  • 博客积分: 1460
  • 博客等级: 上尉
  • 技术积分: 848
  • 用 户 组: 普通用户
  • 注册时间: 2009-07-12 14:07
文章分类

全部博文(86)

文章存档

2017年(36)

2016年(17)

2015年(1)

2013年(12)

2012年(2)

2011年(1)

2010年(1)

2009年(16)

我的朋友

分类: LINUX

2016-07-04 14:22:07

之前不知道是谁添加的进程,在抽取里面添加了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>

 

阅读(6769) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~