初始化informix

sweetbee

提示：shared memory not initialized for INFORMIXSERVER 'obts'

online.log:
11:29:1 Requested shared memory segment size rounded from 8000KB to 8192KB

Thu Feb 16 11:29:10 2006

11:29:10 Event alarms enabled. ALARMPROG= '/usr/informix/etc/log_full.sh'
11:29:16 DR: DRAUTO IS 0 (Off)
11:29:16 Requested shared memory segment size rounded from 588KB TO 4096KB
11:29:16 Informix Dynamic Server Version 7.31.UC7 Software Serial Number AAC
#J900749
11:29:16 Informix Dynamic Server Initialized -- Shared Memory Initialized.
11:29:16 Physical Recovery Started.
11:29:16 Physical Recovery Complete: 0 Pages Restored.
11:29:16 Logical Recovery Started.
11:29:20 Logical Recovery Complete.
           0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:29:21 Dataskip is now OFF for all dbspaces
11:29:21 On-Line Mode
11:29:21 Building 'sysmaster' database ...
11:29:21 Checkpoint Completed: duration was 0 seconds.
11:29:30 listener-thread: err = -931: oserr = 0: errstr = sqlexec:\324\332/etc/services \316\304\274\376\326
\320\325\322\262\273\265\275 sqlexec service/tcp\267\376\316\361.

11:29:30 Attempting to bring listener thread down.

11:29:30 Server stopped.

11:29:30 Informix Dynamic Server Stopped.
11:29:30 mt_shm_remove: WARNING: may not have removed all/correct segments

11:29:1 Requested shared memory segment size rounded from 8000KB to 8192KB

Thu Feb 16 11:30:48 2006

11:30:48 Event alarms enabled. ALARMPROG= '/usr/informix/etc/log_full.sh'
11:30:53 DR: DRAUTO IS 0 (Off)
11:30:53 Requested shared memory segment size rounded from 588KB TO 4096KB
11:30:53 Informix Dynamic Server Version 7.31.UC7 Software Serial Number AAC
#J900749
11:30:54 Informix Dynamic Server Initialized -- Shared Memory Initialized.
11:30:54 Physical Recovery Started.
11:30:54 Physical Recovery Complete: 0 Pages Restored.
11:30:54 Logical Recovery Started.
11:30:57 Logical Recovery Complete.
           0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:30:58 Dataskip is now OFF for all dbspaces
11:30:58On-Line Mode
11:30:58 Building 'sysmaster' database ...
11:30:58 Checkpoint Completed: duration was 0 seconds.
11:31:01 'sysmaster' database built successfully.
11:31:01 'sysmaster' database built successfully.
11:31:20 Checkpoint Completed: duration was 0 seconds.
11:31:21 Informix Dynamic Server Stopped.
11:35:03 Requested shared memory segment size rounded from 8000KB to 8192KB

Thu Feb 16 11:35:03 2006

11:35:03 Event alarms enabled. ALARMPROG= '/usr/informix/etc/log_full.sh'
11:35:08 DR: DRAUTO IS 0 (Off)
11:35:08 Requested shared memory segment size rounded from 588KB TO 4096KB
11:35:08 Informix Dynamic Server Version 7.31.UC7 Software Serial Number AAC
#J900749
11:35:09 Informix Dynamic Server Initialized -- Shared Memory Initialized.
11:35:09 Physical Recovery Started.
11:35:09 Physical Recovery Complete: 0 Pages Restored.
11:35:09 Logical Recovery Started.
11:35:12 Logical Recovery Complete.
           0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:35:13 Dataskip is now OFF for all dbspaces
11:35:13 On-Line Mode
11:35:13 Checkpoint Completed: duration was 0 seconds.
11:37:19 Checkpoint Completed: duration was 0 seconds.
11:37:21 Logical Log 1 Complete.
11:37:23 Logical Log 2 Complete.
11:37:26 Logical Log 3 Complete.
11:37:28 Logical Log 4 Complete.
11:37:31 Logical Log 5 Complete.
11:37:33 Checkpoint Completed: duration was 2 seconds.


不知道online.log的信息贴得够不够？好多啊！
因为是新手，很多不熟悉，希望各位给出详细的解答，麻烦大家了。先谢过了！
是基于UNIX   5.07   系统下安装的INFORMIX   7.31

liaosnet

11:31:01 'sysmaster' database built successfully.

到这里应该已经算是成功了.不过7.3的系统里应该建2个系统库才是~~你需要dbaccess进去看一下是否有两个系统库

sweetbee

不好意思，在online.log里11:31:01 'sysmaster' database built successfully.的下一条信息是11:31:01 'sysutils' database built successfully.

不过不好意思，我dbaccess进去后可以操作数据库界面，但不知道该怎样判断它有没有两个系统库。我自己建立的workdbs、logdbs、tmpdbs也都可以访问。

非常感谢LS，我上一个informix问题也是你帮我解决的，因为我是刚注册还没有积分用，所以上次是用同事的帐号来问问题。看到你觉得非常的高兴

sweetbee

我定义SHMMAX：204800000
LOCKS=100000，BUFFERS=100000
我的内存有512MB的

sweetbee

servicesnline_service 8000/tcp #informix

sqlhost: picc onipcshm obts sqlexec
              tcp ontlitcp obts online_service
或者
sqlhost: picc onipcshm 192.168.0.9 sqlexec
              tcp ontlitcp 192.168.0.9 online_service

都试过了，参数检查了好多次

liaosnet

原帖由 sweetbee 于 2007-11-28 17:49 发表
servicesnline_service 8000/tcp #informix

sqlhost: picc onipcshm obts sqlexec
              tcp ontlitcp obts online_service
或者
sqlhost: picc onipcshm 192.168.0.9 sqlexec
               ...

还没看明白你具体要问什么问题....
从日志上看(包括你的回复),你这个数据库已经正常初始化了.
至于参数配置.SHMMAX 20480000 已经超过了你的物理内存.这个配置是无意义的.
其他的配置都合规划.
按照你的配置将会使用这条SQLHOSTS  tcp ontlitcp obts online_service
不过建议的是 "tcp" 改成 $INFORMIXSERVER

sweetbee

我的问题是：初始化informix时提示shared memory not initialized for INFORMIXSERVER 'obts'。

步骤为：配置完onconfig.picc文件，执行oninit -iy完成后，执行onstat 命令查看online是否正常启动，就会出现上面哪个提示。

我把SHMMAX改为134217728了，也按照你说的把tcp改为$INFORMIXSERVER
但执行初始化后查看还是出现shared memory not initialized for INFORMIXSERVER 'obts'提示

sweetbee

网上有好多在初始化informix的时候出现跟我一样的错误，都能解决，但可惜都没有把解决办法说出来。

liaosnet

原帖由 sweetbee 于 2007-11-29 11:27 发表
我的问题是：初始化informix时提示shared memory not initialized for INFORMIXSERVER 'obts'。

步骤为：配置完onconfig.picc文件，执行oninit -iy完成后，执行onstat 命令查看online是否正常启动，就会出现 ...

你核对下你的环境env|grep INFORMIXSERVER 是不是 obts 是不是跟onconfig.picc里的.DBSERVERNAME/DBSERVERALIASES 相同...

环境里的INFORMIXSERVER跟onconfig文件里的DBSERVERNAME/DBSERVERALIASES跟sqlhosts文件里的第一项名字要相同 .

sweetbee

谢谢！
我的环境env|grep INFORMIXSERVER 是 obts ，也把名字都改成一样了。

执行oninit -iy时提示：oninit:Fatal error in shared memory initialization.