请问如何配置share memory？
系统配置： 1G内存、120G硬盘操作系统： LinuxAS4.0
我用onstat - 查看数据库版本的时候提示：
Incorrectly built binary which accesses errno or H_errno directly. Needs to be fixed.
shared memory not initialized for INFORMIXSERVER 'test'
安装程序包名为： Linux-IDS.9.40.tc1e1.cpico
在初始化数据库时提示：
$ oninit -iky
oninit: Fatal error in shared memory creation
$
onconfig.std配置文件中#shared memory部分:
# Shared Memory Parameters
LOCKS 40000 # Maximum number of locks
NUMAIOVPS # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 256 # Logical log buffer size (Kbytes)
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0xa000000 # Shared memory base address
SHMVIRTSIZE 32678 # initial virtual shared memory segment size
SHMADD 65536 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new logical log when necessary. (ON)
# 1 : notify DBA to add new logical logs when necessary. (ON)
# 0 : cannot add logical log on the fly. (OFF)
#
# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
# because the server can add new logical logs during long transaction rollback.
# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
# can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of logical
# log space, i.e. 50/60 or lower.
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
请各位前辈指点，谢谢
[ 本帖最后由 scorpioer 于 2008-3-4 09:13 编辑 ] 原帖由 scorpioer 于 2008-3-3 17:53 发表 http://bbs.chinaunix.net/images/common/back.gif
系统配置： 1G内存、120G硬盘
在初始化数据库时提示：$ oninit -iky
oninit: Fatal error in shared memory creation
$
onconfig.std配置文件中#shared memory部分:
# Shared Memory Parameters
LOC ...
写明机型.数据库版本~~
SHMBASE 0xa000000 # Shared memory base address
此参数先改回默认配置试一下.
SHMVIRTSIZE 32678 # initial virtual shared memory segment size
此参数改回8000
SHMADD 65536 # Size of new shared memory segments (Kbytes)
此参数改回8192
修改内存部分参数为默认值尝试~~然后根据内存需要进行更改. 我改了shared memory参数：
# Shared Memory Parameters
LOCKS 40000 # Maximum number of locks
NUMAIOVPS # Number of IO vps
BUFFERS 262144
PHYSBUFF 52428 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0xa000000 # Shared memory base address
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
重新执行初始化，报错如下。。。。。
$ oninit -iky
For disk space initialization, the value specified in the ONCONFIG file for
PHYSDBS (phydbs) should be equal to that of ROOTDBS (rootdbs). 原帖由 scorpioer 于 2008-3-4 09:56 发表 http://bbs.chinaunix.net/images/common/back.gif
我改了shared memory参数：
# Shared Memory Parameters
LOCKS 40000 # Maximum number of locks
NUMAIOVPS # Number of IO vps
BUFFERS 262144
PHY ...
For disk space initialization, the value specified in the ONCONFIG file for
PHYSDBS (phydbs) should be equal to that of ROOTDBS (rootdbs).
初始化时请将 PHYDBS设置为rootdbs 初始化过去了，但接下来又报了错。。
$ oninit -iky
$ oninit -v
Checking group membership to determine server run modesucceeded
Reading configuration file '/home/informix/etc/onconfig.dgtx'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/home/informix/etc/.infos.dgtest" ... "/home/informix/etc/.conf.dgtest" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...FAILED
oninit: Fatal error in shared memory creation
$ 原帖由 scorpioer 于 2008-3-4 10:15 发表 http://bbs.chinaunix.net/images/common/back.gif
初始化过去了，但接下来又报了错。。
$ oninit -iky
$ oninit -v
Checking group membership to determine server run modesucceeded
Reading configuration file '/home/informix/etc/onconfig.dgtx' ...
额....oninit -iky?马上oninit -v ??
oninit -k 是什么意思??不明白. 哦 错了 是ivy ,报错ing...
$ oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/home/informix/etc/onconfig.dgtx'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/home/informix/etc/.infos.dgtest" ... "/home/informix/etc/.conf.dgtest" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...FAILED
oninit: Fatal error in shared memory creation
$
[ 本帖最后由 scorpioer 于 2008-3-4 11:12 编辑 ] 原帖由 scorpioer 于 2008-3-4 11:09 发表 http://bbs.chinaunix.net/images/common/back.gif
哦 错了 是ivy ,报错ing...
$ oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/home/informix/etc/onconfig.dgtx'...succeeded
Creating...
看下日志.........$INFORMIXDIR/online.log 下面是今天的日志，请帮忙看看。。
++++++++++++++++++++++++++++++++++++++++++
Tue Mar 11 10:38:01 2008
10:38:01Event alarms enabled.ALARMPROG = '/home/informix/etc/alarmprogram.sh'
10:38:01Booting Language <c> from module <>
10:38:01Loading Module <CNULL>
10:38:01Booting Language <builtin> from module <>
10:38:01Loading Module <BUILTINNULL>
10:38:06Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AAA#B000000
10:38:06Dynamically allocated new virtual shared memory segment (size 32768KB)
10:38:09Informix Dynamic Server Initialized -- Complete Disk Initialized.
10:38:09Checkpoint Completed:duration was 0 seconds.
10:38:09Checkpoint loguniq 1, logpos 0xcc, timestamp: 81
10:38:09Maximum server connections 0
10:38:09Dataskip is now OFF for all dbspaces
10:38:09Quiescent Mode
10:38:23(8) connection rejected - no calls allowed for sqlexec
10:38:23listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:38:48(9) connection rejected - no calls allowed for sqlexec
10:38:48listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:39:28(10) connection rejected - no calls allowed for sqlexec
10:39:28listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:39:53(11) connection rejected - no calls allowed for sqlexec
10:39:53listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:39:53(12) connection rejected - no calls allowed for sqlexec
10:39:53listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:40:15(13) connection rejected - no calls allowed for sqlexec
10:40:15listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:40:22(14) connection rejected - no calls allowed for sqlexec
10:40:22listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:40:46(15) connection rejected - no calls allowed for sqlexec
10:40:46listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
10:41:39Informix Dynamic Server Started.
10:41:39shmget: : key 52564801: shared memory already exists
10:41:39mt_shm_init: can't create resident segment
10:41:42Informix Dynamic Server Started.
10:41:42shmget: : key 52564801: shared memory already exists
10:41:42mt_shm_init: can't create resident segment
10:41:45Informix Dynamic Server Started.
10:41:45shmget: : key 52564801: shared memory already exists
10:41:45mt_shm_init: can't create resident segment
10:41:47Informix Dynamic Server Started.
10:41:47shmget: : key 52564801: shared memory already exists
10:41:47mt_shm_init: can't create resident segment
10:41:50Informix Dynamic Server Started.
10:41:50shmget: : key 52564801: shared memory already exists
10:41:50mt_shm_init: can't create resident segment
10:41:52Informix Dynamic Server Started.
10:41:52shmget: : key 52564801: shared memory already exists
10:41:52mt_shm_init: can't create resident segment
10:41:57Informix Dynamic Server Started.
10:41:57shmget: : key 52564801: shared memory already exists
10:41:57mt_shm_init: can't create resident segment
10:43:38Checkpoint Completed:duration was 0 seconds.
10:43:38Checkpoint loguniq 1, logpos 0x1018, timestamp: 91
10:43:38Maximum server connections 0 .............
10:38:09Quiescent Mode
已经提示到了静模式下了..........:em16: .............
页:
[1]
2