712: Unable to lock data store memory segment, error 12 while load new db
785849Apr 12 2011 — edited Apr 19 2011Hi Masters
I am meeting the error "712: Unable to lock data store memory segment, error 12" while I want to load new database in memory.
ttisql bk_rdb
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=bk_rdb";
712: Unable to lock data store memory segment, error 12
The command failed.
Done.
Below is my tt's and os information. I just googled and make some adjustment in system control file, how it still can not work, can you please point me at right directions. thanks
os :
Linux igs_imdb02 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
cpu:
Intel(R) Xeon(R) CPU X5560 @ 2.80GHz x 7
memory:
free -g
total used free shared buffers cached
Mem: 15 10 5 0 0 0
-/+ buffers/cache: 10 5
Swap: 28 0 28
cat /proc/meminfo
MemTotal: 16411856 kB
MemFree: 5340968 kB
Buffers: 40736 kB
Cached: 311236 kB
SwapCached: 0 kB
Active: 195552 kB
Inactive: 295852 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 16411856 kB
LowFree: 5340968 kB
SwapTotal: 29989292 kB
SwapFree: 29989292 kB
Dirty: 28 kB
Writeback: 0 kB
AnonPages: 139468 kB
Mapped: 28528 kB
Slab: 43976 kB
PageTables: 8212 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 32952340 kB
Committed_AS: 587816 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 278164 kB
VmallocChunk: 34359459099 kB
HugePages_Total: 5120
HugePages_Free: 5120
HugePages_Rsvd: 0
Hugepagesize: 2048 kB
/etc/security/limits.conf have below entries
* soft memlock 23545248
* hard memlock 23545248
DSN attributes
[BK_RDB]
Driver=/ora/TimesTen/tt1121/lib/libtten.so
DataStore=/ora/TimesTen/tt1121/dbs
DatabaseCharacterSet=US7ASCII
TempSize=1024
PermSize=12783
MemoryLock=4
ttversion
TimesTen Release 11.2.1.8.0 (64 bit Linux/x86_64) (tt1121:53388) 2011-02-02T02:20:46Z
Instance admin: tt
Instance home directory: /ora/TimesTen/tt1121
Group owner: ttadmin
Daemon home directory: /ora/TimesTen/tt1121/info
PL/SQL enabled.
Edited by: user1997872 on Apr 12, 2011 2:47 AM