Goldengate Extract Abends with "CACHESIZE TOO SMALL" upon Startup but Succeeds upon Immediate Restart (Doc ID 1517609.1)

Last updated on JULY 20, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.0 to 11.2.1.0.29 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Multiple Goldengate Extract and Datapump processes processes abend with "CACHESIZE TOO SMALL" but startup succeeds upon immediate restart. 

In addition OGG-00664 OCI Error during OCIServerAttach (status = 12549-ORA-12549: TNS:operating system resource quota exceeded) errors are also reported as per the following report file extracts


Source Context :
 SourceModule            : [ggdb.ora.sess]
 SourceID                : [/scratch.local/mmar/view_storage/mmar_14516066/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
 SourceFunction          : [oci_try]
 SourceLine              : [648]

2012-12-10 09:53:16  ERROR   OGG-00664  OCI Error during OCIServerAttach (status = 12549-ORA-12549: TNS:operating system resource quota exceeded).

or


2012-12-10 09:53:13  INFO    OGG-01815  Virtual Memory Facilities for: COM
   anon alloc: mmap(MAP_ANON)  anon free: munmap
   file alloc: mmap(MAP_SHARED)  file free: munmap
   target directories:
   /dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE:                               16M
CACHEPAGEOUTSIZE (normal):                4M
PROCESS VM AVAIL FROM OS (min):          32M
CACHESIZEMAX (strict force to disk):     20M

Source Context :
 SourceModule            : [ggapp.cachemgr]
 SourceID                : [/scratch.local/mmar/view_storage/mmar_14516066/oggcore/OpenSys/src/gglib/ggapp/cmgr_restore.c]
 SourceFunction          : [cm_vm_vals_validate]
 SourceLine              : [3202]

2012-12-10 09:53:18  ERROR   OGG-01841  CACHESIZE TOO SMALL: 16M  MINIMUM REQUIRED: 128M   VM found: 32M
Make sure there is sufficient swap space and make sure CACHEMGR CACHESIZE is not set too low, if used.
Recommended swap per EXTRACT: 128G (64bit system).

2012-12-10 09:53:18  ERROR   OGG-01668  PROCESS ABENDING

The system does not appear to be running out of swap space.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms