oninit初始化informix数据库报错!

Question

错误提示:cannot chunk database online_db eror 2
请问应该怎么解决呢? 谢谢!

Answer 1

把你的onconfig贴出来,你没有指定rootdbs吧.

(这个贴子应到informix版)

Answer 2

onconfig 内容如下:

# Root Dbspace Configuration

ROOTNAME        rootdbs                        # Root dbspace name
ROOTPATH        /home/informix/online_db  # Path for device containing root dbspace
ROOTOFFSET        0                       # Offset of root dbspace into device (Kbytes)
ROOTSIZE        200000                     # 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        10000                # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        6                # Number of logical log files
LOGSIZE                5000                # Logical log size (Kbytes)

# Diagnostics

MSGPATH                /home/informix/online.log   # System message log file path
CONSOLE                /dev/tty1                   # System console message path

# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
ALARMPROGRAM    /home/informix/etc/log_full.sh # Alarm program path
TBLSPACE_STATS  1                # Maintain tblspace statistics

# System Archive Tape Device

TAPEDEV                /dev/null        # Tape device path       
TAPEBLK                32                # 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        32                # Log tape block size (Kbytes)
LTAPESIZE        10240                # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB                       # Informix Dynamic Server staging area

# System Configuration

SERVERNUM        0                # Unique id corresponding to a OnLine instance
DBSERVERNAME         xwork                # Name of default database server
DBSERVERALIASES                        # List of alternate dbservernames
NETTYPE        ipcshm,1,10,CPU                        # 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)

Answer 3

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /online/rootdbs # Path for device containing root dbspace
ROOTOFFSET      200             # Offset of root dbspace into device (Kbytes)
ROOTSIZE        20480000         # Size of root dbspace (Kbytes)
看看onconfig.***中的这些配置参数
启动时用oninit -iv 看看出错信息在哪里

Answer 4

/home/informix/online_db存在吗?
chmod 660 online_db

Answer 5

原帖由 "diablocom" 发表：
/home/informix/online_db存在吗?
chmod 660 online_db

online_db 是存在的,我已经把onconfig贴出来了, ROOTNAME rootdbs  # Root dbspace name 这里的rootdbs需要怎么改动吗?

Answer 6

我刚才用chmod 660 online_db(原先我用chmod 755 online_db)  后再次oninit 现在出现的错误是  fatal error in shareing memory!
是怎么回事呢?

Answer 7

贴上部分online.log 如下:
Thu Nov 13 14:29:48 2003   
                                                                                                                                         
14:29:48  Event alarms enabled.  ALARMPROG = '/home/informix/etc/log_full.sh'
14:29:48  Booting Language <c>; from module <>;
14:29:48  Loading Module <CNULL>;
14:29:48  Booting Language <builtin>; from module <>;
14:29:48  Loading Module <BUILTINNULL>;
14:29:53  Informix Dynamic Server Version 9.40.UC1E1   Software Serial Number AAA#B000000
14:29:53  Dynamically allocated new virtual shared memory segment (size 8192KB)
14:30:12  Informix Dynamic Server Initialized -- Complete Disk Initialized.
14:30:12  Checkpoint Completed:  duration was 0 seconds.
14:30:12  Checkpoint loguniq 1, logpos 0xcc, timestamp: 81
                                                                                                                                               
14:30:12  Maximum server connections 0
14:30:12  Dataskip is now OFF for all dbspaces
14:30:12  On-Line Mode
14:30:12  Building 'sysmaster' database ...
14:30:17  Booting Language <spl>; from module <>;
14:30:17  Loading Module <SPLNULL>;
14:30:18  Unloading Module <SPLNULL>;
14:30:21  Loading Module <SPLNULL>;
14:30:25  Unloading Module <SPLNULL>;
14:30:28  'sysmaster' database built successfully.
14:30:29  'sysutils' database built successfully.
14:35:41  Checkpoint Completed:  duration was 0 seconds.
14:35:41  Checkpoint loguniq 1, logpos 0x967018, timestamp: 46214

14:35:41  Maximum server connections 1
14:40:41  Checkpoint Completed:  duration was 0 seconds.
14:40:41  Checkpoint loguniq 1, logpos 0x968018, timestamp: 46221

14:40:41  Maximum server connections 1

14:40:44  Informix Dynamic Server Started.
14:40:44  shmget: [EEXIST][17]: key 52564801: shared memory already exists
14:40:44  mt_shm_init: can't create resident segment

请各位帮帮忙!

Answer 8

你是用oninit -i 重起数据库的？
oninit -i是第一次启动并初始化数据库的命令，你直接用oninit试试。

Answer 9

原帖由 "clum" 发表：
52564801: shared memory already exists
14:40:44  mt_shm_init: can't create resident segment

请各位帮帮忙!

恭喜,你只差一步了.

两个办法
1,reboot 后 oninit -yv

2.ipcs,然后杀掉所有的共享内存后oninit -yv

千万别oninit -i

(请版主将次贴移到informix)