數(shù)據(jù)庫(kù)出問(wèn)題了，onmode -k關(guān)不了，有沒有哪位高手能幫忙看下的�。�

Oo煙花火

上次在通過(guò)dbaccess刪除表空間時(shí)，被中斷了，后面怎么都不能刪表空間了，后來(lái)我決定重啟數(shù)據(jù)庫(kù)，但是輸入
onmode -k
之后一點(diǎn)反應(yīng)都沒有，持續(xù)了2天還是關(guān)不掉
輸入
onstat時(shí)顯示
IBM Informix Dynamic Server Version 11.50.FC2     -- On-Line (CKPT INP) -- Up 26 days 21:58:20 -- 522672 Kbytes
BlockedBS_DROP

不知道有沒有哪位大大能幫忙看下，萬(wàn)分感謝

liaosnet

直接使用onclean -ky 刪除好了。
或者kill -9 oninit進(jìn)程號(hào) 。。

liaosnet

BTW： 我是不怎么推薦使用sysadmin的方式刪除dbspace這樣的操作。。。

Oo煙花火

我把主機(jī)重啟了，然后
$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，現(xiàn)在整個(gè)數(shù)據(jù)庫(kù)都無(wú)法啟動(dòng)了

liaosnet

回復(fù) 4# Oo煙花火


    出現(xiàn)錯(cuò)誤的應(yīng)該就是你那個(gè)刪除了的dbspace。也許你需要 call ibm 800 獲取oncheck的安全碼來(lái)刪除損壞的dbspace.

Oo煙花火

好吧，后來(lái)討論了，反正數(shù)據(jù)也有備份，干脆就重新整好了。于是決定要把原來(lái)的數(shù)據(jù)庫(kù)刪了。輸入
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

看起來(lái)像是表空間不夠了，于是再想增加一下表空間：
$onspaces -a -d olcashdbs -0 60002 -p /prodigy/informix/cq_olcashserver/olcashdbs2 -s 60000
shared memory not initialized for INFORMIXSERVER 'ol_cash2011'

我是不是死循環(huán)了
求解%>_<%

liaosnet

回復(fù) 6# Oo煙花火


    有備份是什么樣的備份？ 若是ontape/onbar備份的，可以直接恢復(fù)。。。
若是dbexport導(dǎo)出的，需要重新初始化庫(kù)。。就是你現(xiàn)在這樣的操作。。。不過(guò)由于你的以前的數(shù)據(jù)庫(kù)的onconfig可能已經(jīng)對(duì)（PHYSFILE/LOGSIZE）進(jìn)行了更新，你需要重新配置一下這些大小，再重新初始化，最后增加相應(yīng)的空間，恢復(fù)原來(lái)的配置！
關(guān)于informix的安裝
http://blog.chinaunix.net/link.p ... %2F101115143509.pdf

Oo煙花火

謝謝liaosnet大大的回答
我是個(gè)小菜鳥，剛接觸informix不久。不知道能否告知一下
“需要重新配置一下這些大小”是到哪配置呢？

我是用dbexport導(dǎo)出的
如果是重新創(chuàng)建一個(gè)INFORMIXSERVER我知道大概流程，但是現(xiàn)有的這個(gè)要如何刪除呢？

liaosnet

回復(fù) 8# Oo煙花火


    修改onconfig文件，修改以下參數(shù)
PHYSFILE       20000  
PHYSDBS       rootdbs
LOGFILES       6        
LOGSIZE        10000

然后再重新初始化，你上面報(bào)錯(cuò)的信息就是指兩個(gè)的大小+系統(tǒng)庫(kù)的大小超出了你的rootdbs空間指定大小。。因此需要將這個(gè)設(shè)置小一些。。。。

Oo煙花火

謝謝樓上的熱心解答，上面的問(wèn)題解決了，但是我按照你的文檔，在虛擬機(jī)上安裝IDS11.7forlinux的時(shí)候又出問(wèn)題了。

[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


程序安裝到這里就跑不下去了，也不知道哪里出問(wèn)題了？