SQL> select CAPTURE_NAME, QUEUE_NAME, START_SCN, STATUS, FIRST_SCN from dba_capture; --也无该进程信息

SQL> select * from dba_ddl_locks where name like '%ENW_SI_H%';

SESSION_ID OWNER                                       NAME                                          TYPE                          MODE_HELD MODE_REQU

---------- ------------------------------------------------------------ ------------------------------------------------------------ ---------------------------------------- --------- ---------

      2078 OGG                                        OGG$Q_ENW_SI_H                                   10                             Share None

SQL> select sid,serial#,username,MACHINE,PROGRAM from v$session where sid=2078;

       SID    SERIAL# USERNAME                   MACHINE                                          PROGRAM

---------- ---------- ------------------------------ ---------------------------------------------------------------- ------------------------------------------------

      2078  62197                         ycnwdb01.shyj.com                                        oracle@ycnwdb01.shyj.com (Q001)

SQL> alter system kill session '2078,62197';

System altered.

GGSCI (ycwwdbtest) 139> register extract enw_si_h,database                       --KILL后注册成功

2016-08-12 11:21:30  INFO    OGG-02003  Extract ENW_SI_H successfully registered with database at SCN 13652515209691.