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

y331044508

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

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

06:24:08  IBM Informix Dynamic Server Stopped.

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


配置文件内容onconfig

1. 
   
2. ROOTNAME rootdbs
   
3. ROOTPATH /home/informix/app/ol_informix1170/dbspaces/online_root
   
4. ROOTOFFSET 0
   
5. ROOTSIZE 200000
   
6. MIRROR 0
   
7. MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror
   
8. MIRROROFFSET 0
   
9. 
   
10. PHYSFILE 50000
    
11. PLOG_OVERFLOW_PATH  $INFORMIXDIR/tmp
    
12. PHYSBUFF 128
    
13. 
    
14. LOGFILES 6
    
15. LOGSIZE 10000
    
16. DYNAMIC_LOGS 2
    
17. LOGBUFF 64
    
18. 
    
19. LTXHWM 70
    
20. LTXEHWM 80
    
21. 
    
22. MSGPATH /home/informix/app/online.log
    
23. CONSOLE $INFORMIXDIR/tmp/online.con
    
24. 
    
25. TBLTBLFIRST 0
    
26. TBLTBLNEXT 0
    
27. TBLSPACE_STATS 1
    
28. 
    
29. DBSPACETEMP
    
30. SBSPACETEMP
    
31. 
    
32. SBSPACENAME
    
33. SYSSBSPACENAME
    
34. ONDBSPACEDOWN 2
    
35. 
    
36. SERVERNUM 0
    
37. DBSERVERNAME demo_on
    
38. DBSERVERALIASES
    
39. FULL_DISK_INIT 0
    
40. 
    
41. NETTYPE ipcshm,1,50,CPU
    
42. LISTEN_TIMEOUT 60
    
43. MAX_INCOMPLETE_CONNECTIONS 1024
    
44. FASTPOLL 1
    
45. NS_CACHE host=900,service=900,user=900,group=900
    
46. 
    
47. MULTIPROCESSOR 0
    
48. VPCLASS cpu,num=1,noage
    
49. VP_MEMORY_CACHE_KB 0
    
50. SINGLE_CPU_VP 0
    
51. 
    
52. #VPCLASS aio,num=1
    
53. CLEANERS 8
    
54. AUTO_AIOVPS 1
    
55. DIRECT_IO 0
    
56. 
    
57. LOCKS 20000
    
58. DEF_TABLE_LOCKMODE page
    
59. RESIDENT 0
    
60. SHMBASE 0x44000000L
    
61. SHMVIRTSIZE 32656
    
62. SHMADD 8192
    
63. EXTSHMADD 8192
    
64. SHMTOTAL 0
    
65. SHMVIRT_ALLOCSEG 0,3
    
66. SHMNOACCESS
    
67. 
    
68. CKPTINTVL 300
    
69. AUTO_CKPTS 1
    
70. RTO_SERVER_RESTART 0
    
71. BLOCKTIMEOUT 3600
    
72. 
    
73. CONVERSION_GUARD 2
    
74. RESTORE_POINT_DIR $INFORMIXDIR/tmp
    
75. 
    
76. TXTIMEOUT 300
    
77. DEADLOCK_TIMEOUT 60
    
78. HETERO_COMMIT 0
    
79. 
    
80. TAPEDEV /dev/tapedev
    
81. TAPEBLK 32
    
82. TAPESIZE 0
    
83. 
    
84. LTAPEDEV /dev/null
    
85. LTAPEBLK 32
    
86. LTAPESIZE 0
    
87. 
    
88. BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log
    
89. BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log
    
90. BAR_DEBUG 0
    
91. BAR_MAX_BACKUP 0
    
92. BAR_RETRY 1
    
93. BAR_NB_XPORT_COUNT 20
    
94. BAR_XFER_BUF_SIZE 31
    
95. RESTARTABLE_RESTORE ON
    
96. BAR_PROGRESS_FREQ 0
    
97. BAR_BSALIB_PATH
    
98. BACKUP_FILTER
    
99. RESTORE_FILTER
    
100. BAR_PERFORMANCE 0
     
101. BAR_CKPTSEC_TIMEOUT 15
     
102. 
     
103. ISM_DATA_POOL ISMData
     
104. ISM_LOG_POOL ISMLogs
     
105. 
     
106. DD_HASHSIZE 31
     
107. DD_HASHMAX  10
     
108. 
     
109. DS_HASHSIZE 31
     
110. DS_POOLSIZE 127
     
111. 
     
112. PC_HASHSIZE 31
     
113. PC_POOLSIZE 127
     
114. PRELOAD_DLL_FILE
     
115. 
     
116. STMT_CACHE 0
     
117. STMT_CACHE_HITS 0
     
118. STMT_CACHE_SIZE 512
     
119. STMT_CACHE_NOLIMIT 0
     
120. STMT_CACHE_NUMPOOL 1
     
121. 
     
122. USEOSTIME 0
     
123. STACKSIZE 32
     
124. ALLOW_NEWLINE 0
     
125. USELASTCOMMITTED NONE
     
126. 
     
127. FILLFACTOR 90
     
128. MAX_FILL_DATA_PAGES 0
     
129. BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default
     
130. ONLIDX_MAXMEM 5120
     
131. MAX_PDQPRIORITY 100
     
132. 
     
133. DS_MAX_QUERIES
     
134. DS_TOTAL_MEMORY
     
135. DS_MAX_SCANS 1048576
     
136. DS_NONPDQ_QUERY_MEM 128
     
137. DATASKIP
     
138. 
     
139. OPTCOMPIND 2
     
140. DIRECTIVES 1
     
141. EXT_DIRECTIVES 0
     
142. OPT_GOAL -1
     
143. IFX_FOLDVIEW 0
     
144. AUTO_REPREPARE 1
     
145. AUTO_STAT_MODE 1
     
146. STATCHANGE 10
     
147. 
     
148. RA_PAGES     64
     
149. RA_THRESHOLD 16
     
150. BATCHEDREAD_TABLE   1
     
151. BATCHEDREAD_INDEX   1
     
152. BATCHEDREAD_KEYONLY 0
     
153. 
     
154. EXPLAIN_STAT 1
     
155. #SQLTRACE level=low,ntraces=1000,size=2,mode=global
     
156. 
     
157. #DBCREATE_PERMISSION informix
     
158. #DB_LIBRARY_PATH
     
159. IFX_EXTEND_ROLE 1
     
160. SECURITY_LOCALCONNECTION
     
161. UNSECURE_ONSTAT
     
162. ADMIN_USER_MODE_WITH_DBSA
     
163. ADMIN_MODE_USERS
     
164. SSL_KEYSTORE_LABEL
     
165. 
     
166. PLCY_POOLSIZE 127
     
167. PLCY_HASHSIZE 31
     
168. USRC_POOLSIZE 127
     
169. USRC_HASHSIZE 31
     
170. 
     
171. STAGEBLOB
     
172. OPCACHEMAX 0
     
173. 
     
174. ENCRYPT_HDR
     
175. ENCRYPT_SMX
     
176. ENCRYPT_CDR 0
     
177. ENCRYPT_CIPHERS
     
178. ENCRYPT_MAC
     
179. ENCRYPT_MACFILE
     
180. ENCRYPT_SWITCH
     
181. 
     
182. CDR_EVALTHREADS 1,2
     
183. CDR_DSLOCKWAIT 5
     
184. CDR_QUEUEMEM 4096
     
185. CDR_NIFCOMPRESS 0
     
186. CDR_SERIAL 0
     
187. CDR_DBSPACE
     
188. CDR_QHDR_DBSPACE
     
189. CDR_QDATA_SBSPACE
     
190. CDR_SUPPRESS_ATSRISWARN
     
191. CDR_DELAY_PURGE_DTC     0
     
192. CDR_LOG_LAG_ACTION ddrblock
     
193. CDR_LOG_STAGING_MAXSIZE 0
     
194. CDR_MAX_DYNAMIC_LOGS 0
     
195. 
     
196. DRAUTO                  0
     
197. DRINTERVAL              30
     
198. DRTIMEOUT               30
     
199. HA_ALIAS
     
200. DRLOSTFOUND             $INFORMIXDIR/etc/dr.lostfound
     
201. DRIDXAUTO               0
     
202. LOG_INDEX_BUILDS
     
203. SDS_ENABLE
     
204. SDS_TIMEOUT             20
     
205. SDS_TEMPDBS
     
206. SDS_PAGING
     
207. UPDATABLE_SECONDARY     0
     
208. FAILOVER_CALLBACK
     
209. FAILOVER_TX_TIMEOUT     0
     
210. TEMPTAB_NOLOG           0
     
211. DELAY_APPLY             0
     
212. STOP_APPLY              0
     
213. LOG_STAGING_DIR         
     
214. ENABLE_SNAPSHOT_COPY    0
     
215. SMX_COMPRESS            0
     
216. 
     
217. ON_RECVRY_THREADS  1
     
218. OFF_RECVRY_THREADS 10
     
219. 
     
220. DUMPDIR $INFORMIXDIR/tmp
     
221. DUMPSHMEM 1
     
222. DUMPGCORE 0
     
223. DUMPCORE 0
     
224. DUMPCNT 1
     
225. 
     
226. ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh
     
227. ALRM_ALL_EVENTS 0
     
228. STORAGE_FULL_ALARM 600,3
     
229. SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh
     
230. 
     
231. EILSEQ_COMPAT_MODE  0
     
232. 
     
233. QSTATS 0
     
234. WSTATS 0
     
235. 
     
236. USERMAPPING OFF
     
237. 
     
238. SP_AUTOEXPAND 1
     
239. SP_THRESHOLD 0
     
240. SP_WAITTIME 30
     
241. 
     
242. DEFAULTESCCHAR \
     
243. 
     
244. #VPCLASS         MQ,noyield
     
245. MQSERVER
     
246. MQCHLLIB
     
247. MQCHLTAB
     
248. 
     
249. #VPCLASS        jvp,num=1   
     
250. #JVPJAVAHOME     $INFORMIXDIR/extend/krakatoa/jre
     
251. #JVPHOME         $INFORMIXDIR/extend/krakatoa
     
252. JVPPROPFILE     $INFORMIXDIR/extend/krakatoa/.jvpprops
     
253. JVPLOGFILE      $INFORMIXDIR/tmp/jvp.log  
     
254. #JDKVERSION      1.5
     
255. #JVPJAVALIB      /bin
     
256. #JVPJAVAVM       jvm
     
257. #JVPARGS        -verbose:jni
     
258. #JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa_g.jar:$INFORMIXDIR/extend/krakatoa/jdbc_g.jar
     
259. JVPCLASSPATH  $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar
     
260. 
     
261. BUFFERPOOL      default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
     
262. BUFFERPOOL      size=2K,buffers=50000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
     
263. AUTO_LRU_TUNING 1

复制代码

liaosnet

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

回复 2# liaosnet


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

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

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

liaosnet

回复  liaosnet


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

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

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

y331044508

回复 4# liaosnet


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

zxe

学习！！！！

jww3000

学习了

sychangchun

学习了啊。

nickle88

回复 4# liaosnet


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

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



大神你能帮我看看嘛！

nickle88

回复 4# liaosnet


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

系统是AIX5.3