shared memory not initialized for INFORMIXSERVER 'online'寻求解决方法！！！
$ oninit -ivyThis action will initialize Informix Dynamic Server;
any existing Informix Dynamic Server databases will NOT be accessible -
Do you wish to continue (y/n)? y
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig.dev'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/informix/etc/.infos.online" ... "/usr/informix/etc/.co
nf.online" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 400 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 'ipcshm' listener threads...succeeded
Forking 1 'tlitcp' listener threads...$
$ onstat
shared memory not initialized for INFORMIXSERVER 'online'
下面我把sqlhosts、onconfig.dev、services和hosts内容贴出来，哪个好心人帮我看看，到底是哪里出错了。我折腾了好久都没有看出什么错来，谢谢哈！ /usr/Informix/etc/sqlhosts
online onipcshm scosysv sqlexec
online_tcp ontlitcp online online_service
/usr/Informix/etc/onconfig.dev部分内容
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /usr/informix/chunk/chunk1
# Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 2000000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 1000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 500 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /usr/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS1
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME online # Name of default database server
DBSERVERALIASES online_tcp # List of alternate dbservernames
NETTYPE ipcshm,1,20,CPU # Configure poll thread(s) for nettype
NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR0 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# 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
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
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)
/etc/services添加了下面一行
online_service8000/tcp
/etc/hosts
SCCS IDENTIFICATION
127.0.0.1 scosysv
172.18.4.132 scosysv 都没有人要回答吗:emn58: 回复 3# 冉然5_1
再看看online.log？感觉是TCP/IP配置问题。
SQLHOST配置里：
online_tcp ontlitcp online online_service
改为
online_tcp onsoctcp scosysv online_service 06:51:19Requested shared memory segment size rounded from 8000KB to 8192KB
Fri Sep 30 06:51:21 2011
06:51:21Event alarms enabled.ALARMPROG = '/usr/informix/etc/log_full.sh'
06:51:27DR: DRAUTO is 0 (Off)
06:51:27Requested shared memory segment size rounded from 280KB to 4096KB
06:51:28listener-thread: err = -930: oserr = 0: errstr = online: Cannot connec
t to database server (online).
06:51:28Attempting to bring listener thread down.
06:51:28Server stopped. 如果改成online_tcp onsoctcp scosysv online_service
初始化会报错
$ oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/informix/etc/onconfig.dev'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/informix/etc/.infos.online" ... "/usr/informix/etc/.co
nf.online" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 400 kbytes...succeeded
Creating buffer pool 402 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA'
flags; asfcode = '25507'.
FAILED 回复 4# 3sane
改成online_tcpontlitcp scosysv online_service后虽然还是有报错，可是后来莫名其妙的可以了，非常感谢你！ 系统版本？数据库版本？
把日志完整贴下吧 回复 1# 冉然5_1
you must tell us: os, ids version, and online.log ~ 兄弟，sqlhosts错了
按列
第一列（informix servername ）第二列（客户端tcp协议）第三列（主机名） 第四列（端口号或者端口名）
你的第三列配置错了
应该是scosysv
页:
[1]