Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to register one extract,but the other twos are ok.

user1089277Dec 22 2013 — edited Dec 23 2013

Enviroment:

OS:Windows Server 2003 64bit

GG:

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.6 16211226 OGGCORE_11.2.1.0.6_PLATFORMS_130418.1829

Windows x64 (optimized), Oracle 11g on Apr 19 2013 17:38:40

There are three extract on the same server.Now I'd like to register for the three extracts.The other twos are ok,but there is a one extract,meet the below error message:

2013-12-22 21:43:50  ERROR   OGG-01755  Cannot register or unregister EXTRACT E_

ZF_K because of the following SQL error: OCI Error ORA-00001: unique constraint

(SYSTEM.LOGMNR_SESSION_UK1) violated

ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 453

ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 289

ORA-06512: at line 1 (status = 1). See Extract user privileges in the Oracle Gol

denGate for Oracle Installation and Setup Guide.

What should I do?And I also want to know the detailed cause of this error.Thanks in acvance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2014
Added on Dec 22 2013
1 comment
2,173 views