GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

golden gate extract abend with 29701-ORA-29701

edited Jun 15, 2018 5:01AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi All,

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.1.160517 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160711.1401

HP/UX, IA64, 64bit (optimized), Oracle 12c on Jul 11 2016 16:36:47

Database: 12.1.0.2

OS: HP-UX 11.31

issue on golden gate extract process

    /ggate/product/ggs/dirtmp.

2018-06-06 14:42:12  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, ext2.prm:  Source redo compatibility version is: 12.1.0.2.

2018-06-06 14:42:12  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, ext2.prm:  Positioning to begin time Jun 6, 2018 2:40:02 PM.

2018-06-06 14:42:12  ERROR   OGG-00665  Oracle GoldenGate Capture for Oracle, ext2.prm:  OCI Error executing single row select (status = 29701-ORA-29701: unable to connect to Cluster Synchronization Service), SQL<SELECT member,        DECODE(status, 'CURRENT', 1, 0),        DECODE(archived, 'YES', 1, 0)   FROM (select lf.member,        l.status,        1.archived        from v$logfile lf, v$log l        WHERE lf.group# = l.group# AND        l.thread# = :ora_thread AND        l.sequence# = :ora_seq_no AND        (lf.status NOT IN        ('INVALID','INCOMPLETE','STALE') OR        lf.status is null)        order by lf.member DESC )        where rownum = 1>.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center