分类: 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>