[ERROR] shared memory not initialized for INFORMIXSERVER 'online'
系统为：SCO OpenServer V5.0.6 数据库安装模式。新安装的Informix Dynamic Server Version 7.31.UC4。
新安装的informix 无法启动：
shared memory not initialized for INFORMIXSERVER 'online'
使用oninit 启动没有任何信息。
使用onstat -看得的信息：
shared memory not initialized for INFORMIXSERVER 'online'
使用oninit -v 的信息为：
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/informix/etc/.infos.online" ... "/usr/informix/etc/.conf.online" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 398 kbytes...succeeded
Creating buffer pool 402 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...succeeded
Initializing Dictionary Cache and Stored Procedure Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Forking main_loop thread...succeeded
Initialzing DR structures...succeeded
Forking 1 'tlitcp' listener threads...
online.log信息为：
12:55:01Requested shared memory segment size rounded from 8000KB to 8192KB
Tue Mar 27 12:55:01 2007
12:55:01Event alarms enabled.ALARMPROG = '/usr/informix/etc/log_full.sh'
12:55:06DR: DRAUTO is 0 (Off)
12:55:06listener-thread: err = -930: oserr = 0: errstr = onhostname: Cannot connect to database server (onhostname).
12:55:06Attempting to bring listener thread down.
12:55:06Server stopped.
请问高手，这个是怎么回事落，数据库没有启动。
要怎么修改？
[ 本帖最后由 fuhongyao 于 2007-3-27 12:59 编辑 ] $ onstat -
shared memory not initialized for INFORMIXSERVER 'online'
$ onmode -ky
shared memory not initialized for INFORMIXSERVER 'online' 估计还是哪个地方的设置问题
相关参数：
SEMMAP8192
SEMMNI8192
SEMMNS8192
SEMMSL150
SEMMNU100
SHMMAX2147483647 Server Number Server Name
Server Aliases
Dbspace Temp [ ]
Deadlock Timeout SecsNumber of Page Cleaners [ 1]
Forced Residency Stack Size (K)
Non Res. SegSize (K) [ 8000] Optical Cache Size (K) [ 0]
Dbspace Down Option
Preserve Log For Log Backup
Heterogeneous Commit Transaction Timeout [ 300]
Physical Log Buffer Size[ 32] K Long TX HWM
Logical Log Buffer Size [ 32] K Long TX HWM Exclusive
Max # of Logical Logs [ 6] Index Page Fill Factor
Max # of Locks [ 2000] Add SegSize (K) [ 8192]
Max # of Buffers [ 200] Total Memory (K) [ 0]
Resident Shared Memory size [ 796] Kbytes Page Size [ 2] Kbytes 检查INFORMIX环境变量
检查/etc/hosts文件 检查/etc/services文件
检查etc/sqlhosts文件 检查/etc/onconfig文件 下面三个都加了
/etc/hosts
etc/sqlhosts
/etc/services
倒是看看这个
./etc/onconfig文件。
这个./etc/onconfig文件就是onmonitor的配置文件啊，是informix配置修改的不是手工修改的。
[ 本帖最后由 fuhongyao 于 2007-3-27 14:51 编辑 ] # Shared Memory Parameters
LOCKS 2000 # Maximum number of locks
BUFFERS 200 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 6 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x10000000# Shared memory base address
SHMVIRTSIZE8000 # 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
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
[ 本帖最后由 fuhongyao 于 2007-3-27 14:55 编辑 ] 谢谢5楼的提醒，确实是这里面的问题。 现在好了。
是/etc/hosts 和 etc/sqlhosts 不一致的问题。
页:
[1]