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!

how to fix OGG-01806 Virtual memory mmap allocation error: Result too large (error: 34). (IXAsyncT

User_OSGN1Sep 7 2019 — edited Sep 13 2019

The extract has run fine one day before, but today i find the tail file not update. so I stop and start the extract.

and then got the below error log. the oracle version is 12.2.0.0.1 and the ogg version is 12.3.

2019-09-08T08:29:52.038+0800  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  EXTRACT CZCE1 starting.

2019-09-08T08:29:52.054+0800  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Operating system character set identified as GBK.

2019-09-08T08:29:52.054+0800  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2019-09-08T08:29:52.101+0800  INFO    OGG-01360  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  EXTRACT is running in Integrated mode.

2019-09-08T08:29:53.429+0800  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Setting session time zone to source database time zone 'GMT'.

2019-09-08T08:29:53.616+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.

2019-09-08T08:29:53.616+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.

2019-09-08T08:29:53.616+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.

2019-09-08T08:29:53.616+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.

2019-09-08T08:29:53.616+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.632+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.

2019-09-08T08:29:53.648+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.

2019-09-08T08:29:53.648+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.

2019-09-08T08:29:53.648+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.

2019-09-08T08:29:53.648+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.

2019-09-08T08:29:53.648+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.

2019-09-08T08:29:53.648+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.

2019-09-08T08:29:53.648+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.

2019-09-08T08:29:53.663+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.

2019-09-08T08:29:53.663+0800  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  filecaching started: thread ID: 34462160.

2019-09-08T08:29:53.663+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.

2019-09-08T08:29:53.929+0800  INFO    OGG-01639  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p2520_extr.

2019-09-08T08:29:53.929+0800  INFO    OGG-01640  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: recovery start XID: 0.0.0.0.

2019-09-08T08:29:53.929+0800  INFO    OGG-01641  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: recovery start position: SeqNo: 927, RBA: 16518456, SCN: 0.59826069 (59826069), Timestamp: 2019-09-07 17:59:56.000000, Thread: 1.

2019-09-08T08:29:53.929+0800  INFO    OGG-01642  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: recovery end position: SeqNo: 927, RBA: 16518456, SCN: 0.59826069 (59826069), Timestamp: 2019-09-07 17:59:56.000000, Thread: 1.

2019-09-08T08:29:53.929+0800  INFO    OGG-01579  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: VALID BCP: CP.CZCE1.000000284.

2019-09-08T08:29:53.929+0800  INFO    OGG-01629  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: 3.

2019-09-08T08:29:54.288+0800  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Setting session time zone to source database time zone 'GMT'.

2019-09-08T08:29:54.866+0800  INFO    OGG-06604  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Database ORCL CPU info: CPU Count 40, CPU Core Count 20, CPU Socket Count 2.

2019-09-08T08:29:57.726+0800  WARNING OGG-02045  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Database does not have streams_pool_size initialization parameter configured.

2019-09-08T08:29:57.913+0800  INFO    OGG-02248  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Logmining server DDL filtering enabled.

2019-09-08T08:29:58.976+0800  INFO    OGG-02068  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Integrated capture successfully attached to logmining server OGG$CAP_CZCE1 using OGGCapture API.

2019-09-08T08:29:58.976+0800  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Source redo compatibility version is: 12.2.0.

2019-09-08T08:29:58.976+0800  INFO    OGG-02086  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Integrated Dictionary will be used.

2019-09-08T08:29:59.179+0800  WARNING OGG-02905  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Replication of OID column in object tables may diverge.

2019-09-08T08:29:59.195+0800  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  EXTRACT CZCE1 started.

2019-09-08T08:29:59.195+0800  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Recovery initialization completed for target file cz/c1000000029, at RBA 1460.

2019-09-08T08:29:59.210+0800  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Output file cz/c1 is using format RELEASE 12.3.

2019-09-08T08:29:59.210+0800  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Rolling over remote file cz/c1000000029.

2019-09-08T08:29:59.210+0800  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Recovery completed for target file cz/c1000000030, at RBA 1462.

2019-09-08T08:29:59.210+0800  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Recovery completed for all targets.

2019-09-08T08:29:59.242+0800  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Command received from REST API: GETLAG.

2019-09-08T08:29:59.742+0800  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Setting session time zone to source database time zone 'GMT'.

2019-09-08T08:30:00.101+0800  INFO    OGG-01644  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  BOUNDED RECOVERY: COMPLETE: for object pool 1: p2520_extr at SeqNo: 927, RBA: 16518456, SCN: 0.59826069 (59826069), Timestamp: 2019-09-07 17:59:56.000000, Thread: 1.

2019-09-08T08:30:00.195+0800  WARNING OGG-01434  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  ERROR: CreateFileMapping: err_code: 5  prot: 0x3  flags: 0x22  len_lo: 0  len_hi: 1048576.

2019-09-08T08:30:00.195+0800  WARNING OGG-01806  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Virtual memory mmap allocation error:  Result too large (error: 34).

2019-09-08T08:30:00.195+0800  WARNING OGG-01805  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Virtual memory allocation error: 5).

2019-09-08T08:30:00.195+0800  WARNING OGG-01266  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  cm_mmap: VMF_alloc: error: 120: co: 0000000004A802B0 obj_id: <FF><FF><FF><7F><0C><00><1B><00><EC><2B><00><00>.

2019-09-08T08:30:00.211+0800  WARNING OGG-01262  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  The call to the VMF_closeMapHdl() function from line 3057 in cm_mmap() failed with reason 'cm_mmap: VMF_alloc: error: 120: co: 0000000004A802B0 obj_id: <FF><FF><FF><7F><0C><00><1B><00><EC><2B><00><00>'.

2019-09-08T08:30:00.211+0800  WARNING OGG-01262  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  The call to the cm_mmap() function from line 1779 in cm_mf_retrieve_last_mbuf() failed with reason 'cm_mmap: VMF_alloc: error: 120: co: 0000000004A802B0 obj_id: <FF><FF><FF><7F><0C><00><1B><00><EC><2B><00><00>'.

2019-09-08T08:30:00.211+0800  WARNING OGG-01262  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  The call to the cm_mf_retrieve_last_mbuf() function from line 660 in cm_mbuf_get() failed with reason 'cm_mmap: VMF_alloc: error: 120: co: 0000000004A802B0 obj_id: <FF><FF><FF><7F><0C><00><1B><00><EC><2B><00><00>'.

2019-09-08T08:30:00.211+0800  WARNING OGG-01262  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  The call to the cm_mbuf_get() function from line 562 in cm_mbuf_item_copyin() failed with reason 'cm_mbuf_item_copyin'.

2019-09-08T08:30:01.226+0800  ERROR   OGG-06219  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Unable to extract data from the Logmining server OGG$CAP_CZCE1.

2019-09-08T08:30:01.273+0800  ERROR   OGG-02078  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  Extract encountered a fatal error in a processing thread and is abending.

2019-09-08T08:30:01.273+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, CZCE1.prm:  PROCESS ABENDING.

Comments
Post Details
Added on Sep 7 2019
3 comments
801 views