数据库出问题了，onmode -k关不了，有没有哪位高手能帮忙看下的！！

Oo烟花火

上次在通过dbaccess删除表空间时，被中断了，后面怎么都不能删表空间了，后来我决定重启数据库，但是输入
onmode -k
之后一点反应都没有，持续了2天还是关不掉
输入
onstat时显示
IBM Informix Dynamic Server Version 11.50.FC2     -- On-Line (CKPT INP) -- Up 26 days 21:58:20 -- 522672 Kbytes
BlockedBS_DROP

不知道有没有哪位大大能帮忙看下，万分感谢

liaosnet

直接使用onclean -ky 删除好了。
或者kill -9 oninit进程号 。。

liaosnet

BTW： 我是不怎么推荐使用sysadmin的方式删除dbspace这样的操作。。。

Oo烟花火

我把主机重启了，然后
$oninit -v               
Checking group membership to determine server run mode...succeeded
Reading configuration file '/informix/etc/onconfig.ol_cash2011'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/informix/etc/.infos.ol_cash2011"...succeeded
Linking conf file "/informix/etc/.conf.ol_cash2011"...succeeded
Checking config parameters...succeeded
Writing to infos file...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 14708 kbytes...succeeded
Allocating 200016 kbytes for buffer pool of 4K page size...succeeded
Initializing rhead structure...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine 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
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...oninit: Cannot open chunk '/jfdata/cqdb/cqacct_dbspace'. errno = 2
succeeded
Opening mirror chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Initializing DBSPACETEMP list...succeeded

WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.

不知道还能怎么解决吗？我上次就是删的cqacct_dbspace，现在整个数据库都无法启动了

liaosnet

回复 4# Oo烟花火


    出现错误的应该就是你那个删除了的dbspace。也许你需要 call ibm 800 获取oncheck的安全码来删除损坏的dbspace.

Oo烟花火

好吧，后来讨论了，反正数据也有备份，干脆就重新整好了。于是决定要把原来的数据库删了。输入
oninit -i

This action will initialize IBM Informix Dynamic Server;
any existing IBM Informix Dynamic Server databases will NOT be accessible -
Do you wish to continue (y/n)? y

WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.

查看日志得：
09:48:55  IBM Informix Dynamic Server Started.

Wed Feb  8 09:48:56 2012

09:48:56  Warning: ONCONFIG dump directory (DUMPDIR) '/informix/tmp' has insecure permissions
09:48:56  Event alarms enabled.  ALARMPROG = '/informix/etc/alarmprogram.sh'
09:48:56  Booting Language <c> from module <>
09:48:56  Loading Module <CNULL>
09:48:56  Booting Language <builtin> from module <>
09:48:56  Loading Module <BUILTINNULL>
09:48:56  VP pid=7995816 priority fixed at 60, former = 63
09:49:01  DR: DRAUTO is 0 (Off)
09:49:01  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
09:49:01  AIX MP latch code enabled
09:49:01  Fast poll pollset enabled.
09:49:02  IBM Informix Dynamic Server Version 11.50.FC2     Software Serial Number AAA#B000000
09:49:02  oninit: Not enough room in ROOT DBspace.
        Requested 971564K, ONCONFIG value 'ROOTSIZE' 200000K.

09:49:02  IBM Informix Dynamic Server Stopped.

09:49:02  mt_shm_remove: WARNING: may not have removed all/correct segments
09:49:28  Checkpoint Completed:  duration was 0 seconds.
09:49:28  Wed Feb  8 - loguniq 86, logpos 0x401018, timestamp: 0x67cf9c46 Interval: 5897

09:49:28  Maximum server connections 19
09:49:28  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 5, Llog used 4

09:54:28  Checkpoint Completed:  duration was 0 seconds.
09:54:28  Wed Feb  8 - loguniq 86, logpos 0x409018, timestamp: 0x67cf9cde Interval: 5898

09:54:28  Maximum server connections 19
09:54:28  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 28, Llog used 8

看起来像是表空间不够了，于是再想增加一下表空间：
$onspaces -a -d olcashdbs -0 60002 -p /prodigy/informix/cq_olcashserver/olcashdbs2 -s 60000
shared memory not initialized for INFORMIXSERVER 'ol_cash2011'

我是不是死循环了
求解%>_<%

liaosnet

回复 6# Oo烟花火


    有备份是什么样的备份？ 若是ontape/onbar备份的，可以直接恢复。。。
若是dbexport导出的，需要重新初始化库。。就是你现在这样的操作。。。不过由于你的以前的数据库的onconfig可能已经对（PHYSFILE/LOGSIZE）进行了更新，你需要重新配置一下这些大小，再重新初始化，最后增加相应的空间，恢复原来的配置！
关于informix的安装
http://blog.chinaunix.net/link.p ... %2F101115143509.pdf

Oo烟花火

谢谢liaosnet大大的回答
我是个小菜鸟，刚接触informix不久。不知道能否告知一下
“需要重新配置一下这些大小”是到哪配置呢？

我是用dbexport导出的
如果是重新创建一个INFORMIXSERVER我知道大概流程，但是现有的这个要如何删除呢？

liaosnet

回复 8# Oo烟花火


    修改onconfig文件，修改以下参数
PHYSFILE       20000  
PHYSDBS       rootdbs
LOGFILES       6        
LOGSIZE        10000

然后再重新初始化，你上面报错的信息就是指两个的大小+系统库的大小超出了你的rootdbs空间指定大小。。因此需要将这个设置小一些。。。。

Oo烟花火

谢谢楼上的热心解答，上面的问题解决了，但是我按照你的文档，在虚拟机上安装IDS11.7forlinux的时候又出问题了。

[root@bogon setup]# ./ids_install
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
        Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

./ids_install: line 2526: /tmp/install.dir.5159/Linux/resource/jre/jre/bin/java: cannot execute binary file
./ids_install: line 2526: /tmp/install.dir.5159/Linux/resource/jre/jre/bin/java: Success


程序安装到这里就跑不下去了，也不知道哪里出问题了？