Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#goldengate
1 comment
1,137 views