y331044508 发表于 2011-04-26 17:43

初始化报错oninit: Fatal error in shared memory initialization

$ oninit -iv

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
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/app/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 10582 kbytes...succeeded
Allocating 100016 kbytes for buffer pool of 2K page size...succeeded
Creating infos file "/home/informix/app/etc/.infos.demo_on"...succeeded
Linking conf file "/home/informix/app/etc/.conf.demo_on"...succeeded
Initializing rhead structure...succeeded
Writing to infos file...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 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
oninit: Fatal error in shared memory initialization

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


查看online.log日志
Sun Apr 24 06:24:02 2011

06:24:02Event alarms enabled.ALARMPROG = '/home/informix/app/etc/alarmprogram.sh'
06:24:02Booting Language <c> from module <>
06:24:02Loading Module <CNULL>
06:24:02Booting Language <builtin> from module <>
06:24:02Loading Module <BUILTINNULL>
06:24:08DR: DRAUTO is 0 (Off)
06:24:08DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
06:24:08IBM Informix Dynamic Server Version 11.70.UC1DE Software Serial Number AAA#B000000
06:24:08DISK INITIALIZATION ABORTED: potential instance overwrite detected.
To disable this check, set FULL_DISK_INIT to 1 in your config file and retry.

06:24:08oninit: Fatal error in shared memory initialization

06:24:08IBM Informix Dynamic Server Stopped.

06:24:08mt_shm_remove: WARNING: may not have removed all/correct segments


配置文件内容onconfig
ROOTNAME rootdbs
ROOTPATH /home/informix/app/ol_informix1170/dbspaces/online_root
ROOTOFFSET 0
ROOTSIZE 200000
MIRROR 0
MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
MIRROROFFSET 0

PHYSFILE 50000
PLOG_OVERFLOW_PATH$INFORMIXDIR/tmp
PHYSBUFF 128

LOGFILES 6
LOGSIZE 10000
DYNAMIC_LOGS 2
LOGBUFF 64

LTXHWM 70
LTXEHWM 80

MSGPATH /home/informix/app/online.log
CONSOLE $INFORMIXDIR/tmp/online.con

TBLTBLFIRST 0
TBLTBLNEXT 0
TBLSPACE_STATS 1

DBSPACETEMP
SBSPACETEMP

SBSPACENAME
SYSSBSPACENAME
ONDBSPACEDOWN 2

SERVERNUM 0
DBSERVERNAME demo_on
DBSERVERALIASES
FULL_DISK_INIT 0

NETTYPE ipcshm,1,50,CPU
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1
NS_CACHE host=900,service=900,user=900,group=900

MULTIPROCESSOR 0
VPCLASS cpu,num=1,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0

#VPCLASS aio,num=1
CLEANERS 8
AUTO_AIOVPS 1
DIRECT_IO 0

LOCKS 20000
DEF_TABLE_LOCKMODE page
RESIDENT 0
SHMBASE 0x44000000L
SHMVIRTSIZE 32656
SHMADD 8192
EXTSHMADD 8192
SHMTOTAL 0
SHMVIRT_ALLOCSEG 0,3
SHMNOACCESS

CKPTINTVL 300
AUTO_CKPTS 1
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600

CONVERSION_GUARD 2
RESTORE_POINT_DIR $INFORMIXDIR/tmp

TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0

TAPEDEV /dev/tapedev
TAPEBLK 32
TAPESIZE 0

LTAPEDEV /dev/null
LTAPEBLK 32
LTAPESIZE 0

BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log
BAR_DEBUG 0
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE ON
BAR_PROGRESS_FREQ 0
BAR_BSALIB_PATH
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0
BAR_CKPTSEC_TIMEOUT 15

ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

DD_HASHSIZE 31
DD_HASHMAX10

DS_HASHSIZE 31
DS_POOLSIZE 127

PC_HASHSIZE 31
PC_POOLSIZE 127
PRELOAD_DLL_FILE

STMT_CACHE 0
STMT_CACHE_HITS 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1

USEOSTIME 0
STACKSIZE 32
ALLOW_NEWLINE 0
USELASTCOMMITTED NONE

FILLFACTOR 90
MAX_FILL_DATA_PAGES 0
BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default
ONLIDX_MAXMEM 5120
MAX_PDQPRIORITY 100

DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 128
DATASKIP

OPTCOMPIND 2
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL -1
IFX_FOLDVIEW 0
AUTO_REPREPARE 1
AUTO_STAT_MODE 1
STATCHANGE 10

RA_PAGES   64
RA_THRESHOLD 16
BATCHEDREAD_TABLE   1
BATCHEDREAD_INDEX   1
BATCHEDREAD_KEYONLY 0

EXPLAIN_STAT 1
#SQLTRACE level=low,ntraces=1000,size=2,mode=global

#DBCREATE_PERMISSION informix
#DB_LIBRARY_PATH
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL

PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31

STAGEBLOB
OPCACHEMAX 0

ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH

CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_SUPPRESS_ATSRISWARN
CDR_DELAY_PURGE_DTC   0
CDR_LOG_LAG_ACTION ddrblock
CDR_LOG_STAGING_MAXSIZE 0
CDR_MAX_DYNAMIC_LOGS 0

DRAUTO                  0
DRINTERVAL            30
DRTIMEOUT               30
HA_ALIAS
DRLOSTFOUND             $INFORMIXDIR/etc/dr.lostfound
DRIDXAUTO               0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT             20
SDS_TEMPDBS
SDS_PAGING
UPDATABLE_SECONDARY   0
FAILOVER_CALLBACK
FAILOVER_TX_TIMEOUT   0
TEMPTAB_NOLOG         0
DELAY_APPLY             0
STOP_APPLY            0
LOG_STAGING_DIR         
ENABLE_SNAPSHOT_COPY    0
SMX_COMPRESS            0

ON_RECVRY_THREADS1
OFF_RECVRY_THREADS 10

DUMPDIR $INFORMIXDIR/tmp
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1

ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3
SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh

EILSEQ_COMPAT_MODE0

QSTATS 0
WSTATS 0

USERMAPPING OFF

SP_AUTOEXPAND 1
SP_THRESHOLD 0
SP_WAITTIME 30

DEFAULTESCCHAR \

#VPCLASS         MQ,noyield
MQSERVER
MQCHLLIB
MQCHLTAB

#VPCLASS      jvp,num=1   
#JVPJAVAHOME   $INFORMIXDIR/extend/krakatoa/jre
#JVPHOME         $INFORMIXDIR/extend/krakatoa
JVPPROPFILE   $INFORMIXDIR/extend/krakatoa/.jvpprops
JVPLOGFILE      $INFORMIXDIR/tmp/jvp.log
#JDKVERSION      1.5
#JVPJAVALIB      /bin
#JVPJAVAVM       jvm
#JVPARGS      -verbose:jni
#JVPCLASSPATH$INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar
JVPCLASSPATH$INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar

BUFFERPOOL      default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
BUFFERPOOL      size=2K,buffers=50000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
AUTO_LRU_TUNING 1

liaosnet 发表于 2011-04-26 20:23

ISK INITIALIZATION ABORTED: potential instance overwrite detected.
To disable this check, set FULL_DISK_INIT to 1 in your config file and retry.


在11.70中加入了FULL_DISK_INIT 这个参数,对当前已经初始化的dbspace进行保护,若是需要初始化dbspace,需要更改这个参数为 1 .

y331044508 发表于 2011-04-26 22:19

回复 2# liaosnet


    多谢指点,将FULL_DISK_INIT参数修改为1,然后初始化oninit -iv就会成功。

   但还有个问题,我关闭onmode -ky后,从新初始化时FULL_DISK_INIT又会自动变为0;

再次请教如何将FULL_DISK_INIT参数写死,不用每次启动的时候都去修改???

liaosnet 发表于 2011-04-26 23:43

本帖最后由 liaosnet 于 2011-04-26 23:45 编辑

回复liaosnet


    多谢指点,将FULL_DISK_INIT参数修改为1,然后初始化oninit -iv就会成功。

   ...
y331044508 发表于 2011-04-26 22:19 http://bbs.chinaunix.net/images/common/back.gif


    只要初始化成功了,该参数就自动变为0.
    BTW: 以后启动就不需要使用-i 这个命令了,直接使用oninit -v 就行了。 -i 只需要在第一次初始化的时候使用。。

y331044508 发表于 2011-04-27 13:24

回复 4# liaosnet


    多谢指点,问题已经解决,谢谢了。

zxe 发表于 2011-07-28 14:30

学习!!!!

jww3000 发表于 2011-12-05 15:04

学习了

sychangchun 发表于 2012-01-29 21:33

学习了啊。

nickle88 发表于 2016-05-05 18:54

回复 4# liaosnet


    18:04:21Cannot Open Primary Chunk '/home/informix/dbslinks/rootdbs', errno = 6
oninit: Fatal error in shared memory initialization
18:04:21IBM Informix Dynamic Server Stopped.

18:04:21mt_shm_remove: WARNING: may not have removed all/correct segments



大神你能帮我看看嘛!

nickle88 发表于 2016-05-05 18:55

回复 4# liaosnet


    我也是初始化informix11.10 报这个错的1

系统是AIX5.3
页: [1] 2
查看完整版本: 初始化报错oninit: Fatal error in shared memory initialization