informix初始化的问题!

Question

我rhel5.2安装informix10.0，安装成功之后，首次在执行oninit -ivy没有成功，然后找了相关资料用ipcs 查看共享内存，再用ipcrm —M 清除当前的共享内存，再reboot ，重启再执行[informix@sxs ~]$ oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/sxs.cfg'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/home/informix/etc/.infos.onsxs"...succeeded
Linking conf file "/home/informix/etc/.conf.onsxs"...succeeded
Writing to infos file...succeeded
Checking config parameters...Invalid value of DUMPDIR '/usr/informix/tmp' in onconfig file. Setting it to default value
'/home/informix/tmp'...succeeded
15:04:58  IBM Informix Dynamic Server Started.
Allocating and attaching to shared memory...succeeded
Creating resident pool 19388 kbytes...succeeded
Allocating 10016 kbytes for buffer pool of 2K page size...succeeded
Initializing rhead structure...succeeded

Sun Dec  7 15:04:58 2008

15:04:58  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/alarmprogram.sh'
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...15:04:58  Booting Language <c> from module <>
15:04:58  Loading Module <CNULL>
15:04:58  Booting Language <builtin> from module <>
15:04:58  Loading Module <BUILTINNULL>
succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...15:05:03  DR: DRAUTO is 0 (Off)
succeeded
Forking 1 'soctcp' listener threads...succeeded
15:05:03  IBM Informix Dynamic Server Version 10.00.UC4     Software Serial Number AAA#B000000
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
15:05:04  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
15:05:04  Physical Recovery Started at Page (1:267).
15:05:04  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
15:05:04  Logical Recovery Started.
15:05:04  10 recovery worker threads will be started.
15:05:07  Logical Recovery has reached the transaction cleanup phase.
15:05:07  Logical Recovery Complete.
          0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...15:05:08  Dataskip is now OFF for all dbspaces
succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
15:05:08  Checkpoint Completed:  duration was 0 seconds.
15:05:08  Checkpoint loguniq 1, logpos 0x6018, timestamp: 0xaf

15:05:08  Maximum server connections 0
Verbose output complete: mode = 5
[informix@sxs ~]$ 15:05:08  On-Line Mode
15:05:08  Building 'sysmaster' database ...

这里都提示成功了 我马上用onstat -  查看，是ON-LINE！
大约过了5-6秒后，系统提示：
[informix@sxs ~]$ onstat -15:05:17  listener-thread: err = -930: oserr = 0: errstr = sxs: Cannot connect to database server (sxs).

15:05:17  sql_listener: ASF_LISTEN failed

15:05:17  Attempting to bring listener thread down.

15:05:17  Server stopped.

15:05:17  IBM Informix Dynamic Server Stopped.

15:05:17  mt_shm_remove: WARNING: may not have removed all/correct segments

shared memory not initialized for INFORMIXSERVER 'onsxs'

Answer 1

数据库又down掉了，再次执行oninit -v提示如下：
informix@sxs ~]$ oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/sxs.cfg'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/home/informix/etc/.infos.onsxs"...succeeded
Linking conf file "/home/informix/etc/.conf.onsxs"...succeeded
Writing to infos file...succeeded
Checking config parameters...Invalid value of DUMPDIR '/usr/informix/tmp' in onconfig file. Setting it to default value
'/home/informix/tmp'...succeeded
15:09:00  IBM Informix Dynamic Server Started.
Allocating and attaching to shared memory...15:09:00  shmget: [EEXIST][17]: key 52564801: shared memory already exists
15:09:00  mt_shm_init: can't create resident segment

FAILED
oninit: Fatal error in shared memory creation
[informix@sxs ~]$

安这个提示应该是Allocating and attaching to shared memory...15:09:00  shmget: [EEXIST][17]: key 52564801: shared memory already exists  应该是说没有分配和依赖的共享内存，共享内存已经存在，为什么会这样子呢？

再次查看共享内存
[informix@sxs ~]$ ipcs

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x52564801 196608     root      660        30359552   0                       
0x52564802 229377     root      660        32768000   0                       

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages  

共享内存是存在，但是我清除了，再reboot，这个共享内存还会存在。

如何是分配不了共享内存，那有什么办法能让informix分配到共享内存呢？

还各位帮忙看看！感激不尽呐！！！！

Answer 2

informix10.0，这个相对专业一点，大家用的都是mysql
学习一下

Answer 3

用ipcs查看共享内存信息，没有informix用户的内存信息，还请高手们帮忙解决一下啊，实在是搞不定了！谢谢啊！

Answer 4

分配不了共享内存!!!!!!!!!!!!!!!!!  要怎么解决呀??????

怎么没人回答啊????????????????

informix@sxs ~]$ oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/sxs.cfg'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/home/informix/etc/.infos.onsxs"...succeeded
Linking conf file "/home/informix/etc/.conf.onsxs"...succeeded
Writing to infos file...succeeded
Checking config parameters...Invalid value of DUMPDIR '/usr/informix/tmp' in onconfig file. Setting it to default value
'/home/informix/tmp'...succeeded
15:09:00  IBM Informix Dynamic Server Started.
Allocating and attaching to shared memory...15:09:00  shmget: [EEXIST][17]: key 52564801: shared memory already exists
15:09:00  mt_shm_init: can't create resident segment

FAILED
oninit: Fatal error in shared memory creation

Answer 5

ipcrm删除掉已经分配的SHM啊,不行吗?

Answer 6

删掉之后,重启还是不行啊!
总是只有root的共享内存,没有informix的
重启之后,数据库还没有down的时候显示如下
[informix@sxs ~]$ ipcs

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x52564801 0          root      660        30359552   11                     
0x52564802 32769      root      660        32768000   11                     

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     
0x00000000 0          root      660        8         
0x00000000 32769      root      660        1         
0x00000000 65538      root      660        1         
0x00000000 98307      root      660        1         

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages  

过了5-6秒之后数据库提示down了,再次看又变下变的了
[informix@sxs ~]$ ipcs

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x52564801 0          root      660        30359552   0                       
0x52564802 32769      root      660        32768000   0                       

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages

Answer 7

我现在觉得不是这里的问题,应该还是配置的问题!但也不知道那里出错了???
sqlhosts文件:
[informix@sxs ~]$ cat etc/sqlhosts
#**************************************************************************
#
#  Licensed Material - Property Of IBM
#
#  "Restricted Materials of IBM"
#
#  IBM Informix Dynamic Server
#  (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
#
#   Title:      sqlhosts.demo
#   Description:
#               Default sqlhosts file for running demos.
#
#**************************************************************************

demo_on     onipcshm    on_hostname     on_servername
demo_se     seipcpip    se_hostname     sqlexec
onsxs       onsoctcp    sxs             shop

.bashrc文件
[informix@sxs ~]$ cat .bashrc
# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# User specific aliases and functions
INFORMIXDIR=/home/informix                  
INFORMIXSERVER=onsxs
DBDATE=Y4MD0
ONCONFIG=sxs.cfg                                                   
export LANG=en_US.ISO8859-1  
export INFORMIXDIR INFORMIXSERVER DBDATE ONCONFIG                  
export TERMINFO=/home/informix/etc/typetab   
export TERMCAP=$INFORMIXDIR/etc/termcap      
PATH=$PATHHOME/binINFORMIXDIR/bin:.
export PATH
[informix@sxs ~]$

/etc/services 文件我只添加下面几行  不太清楚这个服务是不是随便添加的?  望高手指点
# service-name  port/protocol  [aliases ...]   [# comment]

sahop           66666/tcp
pos             88888/tcp
backcard        88001/tcp
backprice       44001/tcp
backpos         44002/tcp
backmem         48004/tcp
tranmem         44004/tcp

Answer 8

查看系统的共享内存

[informix@sxs ~]$ ipcs

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x52564801 393216     root      660        12128256   0                       
0x52564802 425985     root      660        8192000    0                       
0x52564803 458754     root      660        8388608    0                       

------ Semaphore Arrays --------
key        semid      owner      perms      nsems     

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages   

查看informix的共享内存

[informix@sxs ~]$ onstat -g seg
*** WARNING: IBM Informix Dynamic Server is no longer running. ***

*** WARNING: IBM Informix Dynamic Server is no longer running. ***

IBM Informix Dynamic Server Version 10.00.UC4     -- On-Line -- Up 00:00:19 -- 28036 Kbytes

Segment Summary:
id       key        addr     size       ovhd     class blkused  blkfree
393216   1381386241 44000000 12128256   217256   R     2958     3      
425985   1381386242 44b91000 8192000    904      V     2000     0      
458754   1381386243 45361000 8388608    904      V     410      1638   
Total:   -          -        28708864   -        -     5368     1641   

   (* segment locked in memory)

*** WARNING: IBM Informix Dynamic Server is no longer running. ***

[informix@sxs ~]$

从上面可以这两个共享内存ID是一样的，ipcs显示的应该是informix的共享内存，但owner项中为root 组，perms项中为660，证明其它组的用户没任何的权限去使用，所以当我在oninit -v后，数据库启动19秒就down了(从这里可以看出-- On-Line -- Up 00:00:19 -- 28036 Kbytes)，现在问题是能不能把共享内存所属者改为informix呢？？？？

望高手指点！！！！！在线等候！！！