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!

EXTRACT ERROR OGG-00662 Oracle GoldenGate Capture for Oracle, xxx.prm: OCI Error ORA-00600

User_OSGN1Jul 17 2020 — edited Jul 18 2020

Hi,All

I got the below error yestoday.

Is the any one can give a help?

2020-07-18T08:04:07.434+0800  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  EXTRACT CZCE1 starting.

2020-07-18T08:04:07.445+0800  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Operating system character set identified as GBK.

2020-07-18T08:04:07.445+0800  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2020-07-18T08:04:07.457+0800  INFO    OGG-01360  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  EXTRACT is running in Integrated mode.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_FEE_TYP mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_FEE_TYP_COD mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_FEE_COD mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_FEE_MOD mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_FEE_ELE mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_FEE_ELE_LOV mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_FEE_MOD_ELE mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.FEE_TOTAL mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_PROTOCOL_RAT mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.FEE_BILL_HDR mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.FEE_DET mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_BIS.C_PROTOCOL mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.SHIP_VOYAGE mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.PORT_CNTR mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.TRUCK_CNTR_BAK mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.SHIP_CNTR mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.IN_OUT_CY mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.C_CLIENT_COD mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.SHIP_WORK_RECORD mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.C_SHIP_LINE mapping.

2020-07-18T08:04:07.713+0800  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Default source catalog name orclpdb will be used for source table name LAZ_MIS.C_SHIP_LINE_W mapping.

2020-07-18T08:04:07.780+0800  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Virtual Memory Facilities for: BR

                                  anon alloc: MapViewOfFile  anon free: UnmapViewOfFile

                                  file alloc: MapViewOfFile  file free: UnmapViewOfFile

                                  target directories:

                                  D:\installed\ogg\dp\var\run\BR\CZCE1.

2020-07-18T08:04:07.782+0800  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  filecaching started: thread ID: 373805553888.

2020-07-18T08:04:07.782+0800  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Virtual Memory Facilities for: COM

                                  anon alloc: MapViewOfFile  anon free: UnmapViewOfFile

                                  file alloc: MapViewOfFile  file free: UnmapViewOfFile

                                  target directories:

                                  D:\installed\ogg\dp\var\temp.

2020-07-18T08:04:08.076+0800  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p580_extr.

2020-07-18T08:04:08.076+0800  INFO    OGG-01640  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: recovery start XID: 64819921.10.16.148293.

2020-07-18T08:04:08.076+0800  INFO    OGG-01641  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: recovery start position: SeqNo: 7688, RBA: 128118800, SCN: 6.3796549658 (29566353434), Timestamp: 2020-07-17 19:33:45.000000.

2020-07-18T08:04:08.076+0800  INFO    OGG-01642  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: recovery end position: SeqNo: 7688, RBA: 128121360, SCN: 6.3796549659 (29566353435), Timestamp: 2020-07-17 19:33:45.000000, Thread: 1.

2020-07-18T08:04:08.076+0800  INFO    OGG-01643  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: CANCELED: for object pool 1: p580_extr.

2020-07-18T08:04:08.076+0800  INFO    OGG-01579  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: VALID BCP: CP.CZCE1.000000468.

2020-07-18T08:04:08.140+0800  INFO    OGG-01629  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.

2020-07-18T08:04:08.144+0800  INFO    OGG-25340  Oracle GoldenGate Capture for Oracle, CZCE1.prm: 

                              Database Version:

                              Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

                              PL/SQL Release 12.2.0.1.0 - Production

                              CORE 12.2.0.1.0 Production

                              TNS for 64-bit Windows: Version 12.2.0.1.0 - Production

                              NLSRTL Version 12.2.0.1.0 - Production.

2020-07-18T08:04:08.147+0800  INFO    OGG-25341  Oracle GoldenGate Capture for Oracle, CZCE1.prm: 

                              Database Language and Character Set:

                              NLS_LANGUAGE     = "AMERICAN"

                              NLS_TERRITORY    = "AMERICA"

                              NLS_CHARACTERSET = "ZHS16GBK".

2020-07-18T08:04:08.425+0800  INFO    OGG-06604  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Database ORCL CPU info: CPU Count 20, CPU Core Count 20, CPU Socket Count 20.

2020-07-18T08:04:08.425+0800  INFO    OGG-06618  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Database ORCL Platform: Microsoft Windows x86 64-bit.

2020-07-18T08:04:09.021+0800  INFO    OGG-02248  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Logmining server DDL filtering enabled.

2020-07-18T08:04:10.463+0800  INFO    OGG-02068  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Integrated capture successfully attached to logmining server OGG$CAP_CZCE1 using OGGCapture API.

2020-07-18T08:04:10.463+0800  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Source redo compatibility version is: 12.2.0.

2020-07-18T08:04:10.463+0800  INFO    OGG-02086  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Integrated Dictionary will be used.

2020-07-18T08:04:10.549+0800  WARNING OGG-02905  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Replication of OID column in object tables may diverge.

2020-07-18T08:04:10.549+0800  INFO    OGG-02776  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Native data capture is enabled for Oracle NUMBER data type.

2020-07-18T08:04:10.549+0800  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  The previous message, 'INFO OGG-02776', repeated 1 times.

2020-07-18T08:04:10.549+0800  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  EXTRACT CZCE1 started.

2020-07-18T08:04:10.549+0800  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Recovery initialization completed for target file cz/cd/c1000000061, at RBA 1457.

2020-07-18T08:04:10.549+0800  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Output file cz/cd/c1 is using format RELEASE 19.1.

2020-07-18T08:04:10.549+0800  INFO    OGG-02922  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  File cz/cd/c1000000061, with format RELEASE 12.3/18.1, does not match default format specification of RELEASE 19.1. Extract is going to write new trail file in the format RELEASE 12.3/18.1 to keep compatibility.

2020-07-18T08:04:10.549+0800  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Rolling over remote file cz/cd/c1000000061.

2020-07-18T08:04:10.557+0800  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Recovery completed for target file cz/cd/c1000000062, at RBA 1457.

2020-07-18T08:04:10.558+0800  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Recovery completed for all targets.

2020-07-18T08:04:12.097+0800  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Command received from REST API: GETLAG.

2020-07-18T08:04:14.079+0800  ERROR   OGG-00662  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  OCI Error ORA-00600: Internal error code, parameter: [600], [], [], [], [], [], [], [], [], [], [], []

                               (status = 600).

2020-07-18T08:04:14.205+0800  ERROR   OGG-02078  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Extract encountered a fatal error in a processing thread and is abending.

2020-07-18T08:04:14.216+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  PROCESS ABENDING.

Comments
Post Details
Added on Jul 17 2020
1 comment
1,434 views