register extract后报错OGG-01755 OCI ERROR 4021

 

 

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26655292/viewspace-2123379/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26655292/viewspace-2123379/