Database Connection Fails With Cannot create data store shared-memory segment, error 22 (Doc ID 1504153.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

TimesTen connection fails with error TT836:  

836: Cannot create data store shared-memory segment, error 22
703: Subdaemon connect to data store failed with error TT836
The command failed.

On Linux and Unix, Error 22 means EINVAL - "Invalid Argument"

What that actually means in this case is that there is not enough memory to create the TimesTen shared memory segment as described in KM article, 1384897.1 - HOWTO : Resolve TimesTen Error TT14000: TimesTen daemon internal error: Error 22 creating shared (OS reports invalid shared segment size) .

User compared existing database sizing attributes, PermSize + TempSize +  LogBufMB + ~20MB database overhead, and notices it is sized appropriately for the current kernel.shmmax and/or huge page settings (if they configured TimesTen to use huge pages).

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