4 Replies Latest reply: Sep 12, 2013 9:25 AM by Jspalmer-Oracle RSS

    852: Unable to lock data store memory segment, error 12

    William64

      I'm getting this error when making a DB connections.  I'm not using huge pages.  Running RedHat.  I have 6 different DSN over different sizes and it happens on all 6.  I've only installed our base db with minimum configured and have not setup replication yet.

       

      msclab51# SYS

       

      Copyright (c) 1996-2011, Oracle.  All rights reserved.

      Type ? or "help" for help, type "exit" to quit ttIsql.

       

       

       

      connect "dsn=SystemConfigurationCS;AutoCreate=0";

       

      Warning   852: Unable to lock data store memory segment, error 12 ...continuing with connection...

       

      Connection successful: DSN=SystemConfigurationCS;TTC_SERVER=msclab51;TTC_SERVER_DSN=SystemConfigurationDir;UID=santera;DATASTORE=/Santera/db/SystemConfiguration;DATABASECHARACTERSET=TIMESTEN8;CONNECTIONCHARACTERSET=TIMESTEN8;AUTOCREATE=0;PREALLOCATE=1;MEMORYLOCK=3;PERMSIZE=100;TEMPSIZE=50;PERMWARNTHRESHOLD=80;TEMPWARNTHRESHOLD=80;CONNECTIONS=200;CKPTFREQUENCY=300;TYPEMODE=1;

      (Default setting AutoCommit=1)

       

       

       

      msclab51# uname -a

      Linux msclab51 2.6.32-220.el6.x86_64 #1 SMP Wed Nov 9 08:03:13 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

      msclab51#

       

       

      msclab51# ulimit -l

      unlimited

       

       

      msclab51# cat /proc/meminfo

      MemTotal:        8187860 kB

      MemFree:         2430780 kB

      Buffers:           98680 kB

      Cached:          5304932 kB

      SwapCached:            0 kB

      Active:           419140 kB

      Inactive:        5054472 kB

      Active(anon):      70164 kB

      Inactive(anon):      276 kB

      Active(file):     348976 kB

      Inactive(file):  5054196 kB

      Unevictable:           0 kB

      Mlocked:               0 kB

      SwapTotal:       8388600 kB

      SwapFree:        8388600 kB

      Dirty:                68 kB

      Writeback:             0 kB

      AnonPages:         69892 kB

      Mapped:            21860 kB

      Shmem:               456 kB

      Slab:             165184 kB

      SReclaimable:     127816 kB

      SUnreclaim:        37368 kB

      KernelStack:        2472 kB

      PageTables:         4712 kB

      NFS_Unstable:          0 kB

      Bounce:                0 kB

      WritebackTmp:          0 kB

      CommitLimit:    12482528 kB

      Committed_AS:     488152 kB

      VmallocTotal:   34359738367 kB

      VmallocUsed:      296080 kB

      VmallocChunk:   34359431676 kB

      HardwareCorrupted:     0 kB

      AnonHugePages:     20480 kB

      HugePages_Total:       0

      HugePages_Free:        0

      HugePages_Rsvd:        0

      HugePages_Surp:        0

      Hugepagesize:       2048 kB

      DirectMap4k:        8192 kB

      DirectMap2M:     8376320 kB

      msclab51#

       

       

       

      msclab51# cat /etc/TimesTen/instance_info

      #SUM 42161     1

      Product=TimesTen11.2.1.9

      InstallDir=/opt/SANTone/msc/active/TimesTen/tt1121

      InstanceAdministrator=ttadmin

      DaemonHome=/var/TimesTen/tt1121

      BitLevel=32

      Component=Client/Server and DataManager

      TT_PORT=16000

       

       

       

      #####################################################################

      1. Data source for SystemConfiguration (direct)

      #####################################################################

      Driver=/opt/SANTone/msc/active/TimesTen/lib/libtten.so

      DataStore=/Santera/db/SystemConfiguration

      AutoCreate=0

      DurableCommits=0

      ExclAccess=0

      LockLevel=0

      PermWarnThreshold=80

      TempWarnThreshold=80

      PermSize=100

      TempSize=50

      ThreadSafe=1

      WaitForConnect=1

      Preallocate=1

      MemoryLock=3

      SMPOptLevel=1

      Connections=200

      CkptFrequency=300

      DatabaseCharacterSet=TIMESTEN8

      TypeMode=1

       

      #####################################################################

      1. Data source for CallProcessing (direct)

      #####################################################################

      Driver=/opt/SANTone/msc/active/TimesTen/lib/libtten.so

      DataStore=/Santera/db/CallProcessing

      AutoCreate=0

      DurableCommits=0

      ExclAccess=0

      LockLevel=0

      PermWarnThreshold=80

      TempWarnThreshold=80

      PermSize=100

      TempSize=50

      ThreadSafe=1

      WaitForConnect=1

      Preallocate=1

      MemoryLock=3

      SMPOptLevel=1

      Connections=64

      CkptFrequency=300

      DatabaseCharacterSet=TIMESTEN8

      TypeMode=1

       

      #####################################################################

      1. Data source for SS7Configuration (direct)

      #####################################################################

      Driver=/opt/SANTone/msc/active/TimesTen/lib/libtten.so

      DataStore=/Santera/db/SS7Configuration

      AutoCreate=0

      DurableCommits=0

      ExclAccess=0

      LockLevel=0

      PermWarnThreshold=80

      TempWarnThreshold=80

      PermSize=64

      TempSize=32

      ThreadSafe=1

      WaitForConnect=1

      Preallocate=1

      MemoryLock=3

      SMPOptLevel=1

      Connections=100

      CkptFrequency=300

      DatabaseCharacterSet=TIMESTEN8

      TypeMode=1

       

      #####################################################################

      1. Data source for Subscriber (direct)

      #####################################################################

      Driver=/opt/SANTone/msc/active/TimesTen/lib/libtten.so

      DataStore=/Santera/db/Subscriber

      AutoCreate=0

      DurableCommits=0

      ExclAccess=0

      LockLevel=0

      PermWarnThreshold=80

      TempWarnThreshold=80

      PermSize=200

      TempSize=35

      ThreadSafe=1

      WaitForConnect=1

      Preallocate=1

      MemoryLock=3

      SMPOptLevel=1

      Connections=64

      CkptFrequency=300

      DatabaseCharacterSet=TIMESTEN8

      TypeMode=1

       

      #####################################################################

      1. Data source for DynamicDB (direct)

      #####################################################################

      Driver=/opt/SANTone/msc/active/TimesTen/lib/libtten.so

      DataStore=/Santera/db/DynamicDB

      AutoCreate=0

      DurableCommits=0

      ExclAccess=0

      LockLevel=0

      PermWarnThreshold=80

      TempWarnThreshold=80

      PermSize=64

      TempSize=32

      ThreadSafe=1

      WaitForConnect=1

      Preallocate=1

      MemoryLock=3

      SMPOptLevel=1

      Connections=64

      CkptFrequency=300

      DatabaseCharacterSet=TIMESTEN8

      TypeMode=1

       

      #####################################################################

      1. Data source for EmsData (direct)

      #####################################################################

      Driver=/opt/SANTone/msc/active/TimesTen/lib/libtten.so

      DataStore=/Santera/db/EmsData

      AutoCreate=0

      DurableCommits=0

      ExclAccess=0

      LockLevel=0

      PermWarnThreshold=80

      TempWarnThreshold=80

      PermSize=200

      TempSize=75

      ThreadSafe=1

      WaitForConnect=1

      Preallocate=1

      MemoryLock=3

      SMPOptLevel=1

      Connections=64

      CkptFrequency=300

      DatabaseCharacterSet=TIMESTEN8

      TypeMode=1