oninit -ivy 起不来数据库 帮忙看下
执行oninit -ivy的结果oninit -ivy
Checking group membership to determine server run modesucceeded
Reading configuration file '/home/db/informix/etc/onconfig.vssdb'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/home/db/informix/etc/.infos.vssdb" ... "/home/db/informix/etc/.conf.vssdb" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 194988 kbytes...succeeded
Creating buffer pool 1600000 kbytes...succeeded
Creating buffer pool 8 kbytes...succeeded
Initializing rhead structure...succeeded
Initializing ASF ...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 1 additional cpu vps...succeeded
Onlining 4 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 16 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Creating database partition
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
onstat -m查看日志的结果
onstat -m
IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line -- Up 00:00:21 -- 2307552 Kbytes
Message Log File: /home/db/informix/online.log
09:19:53Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs'
09:19:53Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs1'
09:19:53Checkpoint Completed:duration was 0 seconds.
09:19:53Checkpoint loguniq 1, logpos 0xf8, timestamp: 0x60
09:19:53Maximum server connections 0
09:19:53Dataskip is now OFF for all dbspaces
09:19:53On-Line Mode
09:19:53Building 'sysmaster' database ...
09:19:56Logical Log 2 Complete, timestamp: 0x720e.
09:19:56Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 2 Complete, timestamp: 0x720e." "Logical Log 2 Com
09:19:57Checkpoint Completed:duration was 0 seconds.
09:19:57Checkpoint loguniq 3, logpos 0x18, timestamp: 0x722f
09:19:57Maximum server connections 1
09:19:57Error building 'sysmaster' database.
09:19:57See '/tmp/buildsmi.127130'.
09:19:57Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 3 6 "Internal Subsystem failure: 'SMI'" "Error building 'sysmaster' 先把环境里的DBSPACESTEMP 这个环境参数关闭~
重新初始化~~
[ 本帖最后由 liaosnet 于 2008-1-16 09:26 编辑 ] 初始化好几次了
都一样的报错 关了那个参数还是不行
没有warning了
building数据库的时候错了
onstat -m
IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line -- Up 00:01:12 -- 2307552 Kbytes
Message Log File: /home/db/informix/online.log
10:25:58IBM Informix Dynamic Server Version 9.40.FC5 Software Serial Number AAA#B000000
10:26:08IBM Informix Dynamic Server Initialized -- Complete Disk Initialized.
10:26:08Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs'
10:26:08Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs1'
10:26:09Checkpoint Completed:duration was 0 seconds.
10:26:09Checkpoint loguniq 1, logpos 0xf8, timestamp: 0x60
10:26:09Maximum server connections 0
10:26:09Dataskip is now OFF for all dbspaces
10:26:09On-Line Mode
10:26:09Building 'sysmaster' database ...
10:26:11Logical Log 2 Complete, timestamp: 0x720e.
10:26:11Checkpoint Completed:duration was 0 seconds.
10:26:11Checkpoint loguniq 3, logpos 0x18, timestamp: 0x722f
10:26:11Maximum server connections 1
10:26:12Error building 'sysmaster' database.
10:26:12See '/tmp/buildsmi.143534'.
cat /tmp/buildsmi.143534的结果
将其中的报错部分粘了出来
#cat /tmp/buildsmi.143534
275: No INSERT permission.
Error in line 1667
Near character position 24
964 row(s) inserted.
206: The specified table (sysrstcb) is not in the database.
111: ISAM error:no record found.
Error in line 2046
Near character position 17
206: The specified table (sysseswts) is not in the database.
111: ISAM error:no record found.
Error in line 2050
Near character position 31
206: The specified table (syschfree) is not in the database.
111: ISAM error:no record found.
Error in line 2055
Near character position 56
206: The specified table (syschkextents) is not in the database.
111: ISAM error:no record found.
Error in line 2056
Near character position 35
206: The specified table (sysptnbit) is not in the database.
111: ISAM error:no record found.
Error in line 2060
Near character position 62
206: The specified table (systabpagtypes) is not in the database.
111: ISAM error:no record found.
Error in line 2061
Near character position 36
206: The specified table (syslogfil) is not in the database.
111: ISAM error:no record found.
Error in line 2073
Near character position 2
206: The specified table (syslogs) is not in the database.
111: ISAM error:no record found.
Error in line 2074
Near character position 29
206: The specified table (syschktab) is not in the database.
111: ISAM error:no record found.
Error in line 2089
Near character position 18
206: The specified table (syschunks) is not in the database.
111: ISAM error:no record found.
Error in line 2092
Near character position 31
206: The specified table (sysdbstab) is not in the database.
111: ISAM error:no record found.
Error in line 2102
Near character position 2
206: The specified table (sysdbspaces) is not in the database.
111: ISAM error:no record found.
Error in line 2103
Near character position 33
206: The specified table (syslcktab) is not in the database.
111: ISAM error:no record found.
Error in line 2110
Near character position 18
206: The specified table (syslocks) is not in the database.
111: ISAM error:no record found.
Error in line 2118
Near character position 30
206: The specified table (syslcktab) is not in the database.
111: ISAM error:no record found.
Error in line 2126
Near character position 62
206: The specified table (syslocktab) is not in the database.
111: ISAM error:no record found.
Error in line 2127
Near character position 32
206: The specified table (sysscblst) is not in the database.
111: ISAM error:no record found.
Error in line 2144
Near character position 18
206: The specified table (syssessions) is not in the database.
111: ISAM error:no record found.
Error in line 2147
Near character position 33
206: The specified table (sysrstcb) is not in the database.
111: ISAM error:no record found.
Error in line 2166
Near character position 10
206: The specified table (syssesprof) is not in the database.
111: ISAM error:no record found.
Error in line 2169
Near character position 32
206: The specified table (sysvplst) is not in the database.
111: ISAM error:no record found.
Error in line 2175
Near character position 17
206: The specified table (sysvpprof) is not in the database.
111: ISAM error:no record found.
Error in line 2179
Near character position 31
206: The specified table (systabnames) is not in the database.
111: ISAM error:no record found.
Error in line 2193
Near character position 20
206: The specified table (sysptprof) is not in the database.
111: ISAM error:no record found.
Error in line 2195
Near character position 31
206: The specified table (sysshmhdr) is not in the database.
111: ISAM error:no record found.
Error in line 2202
Near character position 2
206: The specified table (sysprofile) is not in the database.
111: ISAM error:no record found.
Error in line 2203
Near character position 32
206: The specified table (syscfgtab) is not in the database.
111: ISAM error:no record found.
Error in line 2210
Near character position 9
206: The specified table (sysconfig) is not in the database.
111: ISAM error:no record found.
Error in line 2211
Near character position 31
206: The specified table (systabnames) is not in the database.
111: ISAM error:no record found.
Error in line 2217
Near character position 20
206: The specified table (sysextents) is not in the database.
111: ISAM error:no record found.
Error in line 2219
Near character position 32
206: The specified table (sysptnext) is not in the database.
111: ISAM error:no record found.
Error in line 2225
Near character position 17
206: The specified table (systabextents) is not in the database.
111: ISAM error:no record found.
Error in line 2226
Near character position 35
206: The specified table (sysdrcb) is not in the database.
111: ISAM error:no record found.
Error in line 2232
Near character position 16
206: The specified table (sysdri) is not in the database.
111: ISAM error:no record found.
Error in line 2237
Near character position 28
206: The specified table (sysdbspartn) is not in the database.
111: ISAM error:no record found.
Error in line 2247
Near character position 18
206: The specified table (sysdatabases) is not in the database.
111: ISAM error:no record found.
Error in line 2248
Near character position 34
206: The specified table (systcblst) is not in the database.
111: ISAM error:no record found.
Error in line 2259
Near character position 17
206: The specified table (systhreads) is not in the database.
111: ISAM error:no record found.
Error in line 2260
Near character position 32
206: The specified table (sysmtxlst) is not in the database.
111: ISAM error:no record found.
Error in line 2268
Near character position 17
206: The specified table (sysmutexes) is not in the database.
111: ISAM error:no record found.
Error in line 2269
Near character position 32
206: The specified table (sysconlst) is not in the database.
111: ISAM error:no record found.
Error in line 2276
Near character position 17
206: The specified table (sysconditions) is not in the database.
111: ISAM error:no record found.
Error in line 2277
Near character position 35
206: The specified table (syspoollst) is not in the database.
111: ISAM error:no record found.
Error in line 2284
Near character position 18
206: The specified table (syspools) is not in the database.
111: ISAM error:no record found.
Error in line 2285
Near character position 30
206: The specified table (sysseglst) is not in the database.
111: ISAM error:no record found.
Error in line 2294
Near character position 17
206: The specified table (syssegments) is not in the database.
111: ISAM error:no record found.
Error in line 2295
Near character position 33
206: The specified table (systwaits) is not in the database.
111: ISAM error:no record found.
Error in line 2302
Near character position 16
206: The specified table (systhreadwaits) is not in the database.
111: ISAM error:no record found.
Error in line 2303
Near character position 36
206: The specified table (sysmtxlst) is not in the database.
111: ISAM error:no record found.
Error in line 2311
Near character position 16
206: The specified table (sysmutq) is not in the database.
111: ISAM error:no record found.
Error in line 2312
Near character position 29
206: The specified table (sysconlst) is not in the database.
111: ISAM error:no record found.
Error in line 2320
Near character position 16
206: The specified table (sysconq) is not in the database.
111: ISAM error:no record found.
Error in line 2321
Near character position 29
206: The specified table (sysrstcb) is not in the database.
111: ISAM error:no record found.
Error in line 2346
Near character position 44
206: The specified table (sysuserthreads) is not in the database.
111: ISAM error:no record found.
Error in line 2348
Near character position 37
206: The specified table (systxptab) is not in the database.
111: ISAM error:no record found.
Error in line 2360
Near character position 17
206: The specified table (systrans) is not in the database.
111: ISAM error:no record found.
Error in line 2362
Near character position 30
206: The specified table (sysptnhdr) is not in the database.
111: ISAM error:no record found.
Error in line 2375
Near character position 21
206: The specified table (systabinfo) is not in the database.
111: ISAM error:no record found.
Error in line 2377
Near character position 36
206: The specified table (syspaghdr) is not in the database.
111: ISAM error:no record found.
Error in line 2383
Near character position 35
206: The specified table (systabpaghdrs) is not in the database.
111: ISAM error:no record found.
Error in line 2386
Near character position 39
206: The specified table (syspaghdr) is not in the database.
111: ISAM error:no record found.
Error in line 2396
Near character position 23
206: The specified table (sysphyspaghdrs) is not in the database.
111: ISAM error:no record found.
Error in line 2399
Near character position 40
Table created.
Index created.
Permission revoked.
206: The specified table (syschktab) is not in the database.
111: ISAM error:no record found.
Error in line 2431
Near character position 18
206: The specified table (syschkio) is not in the database.
111: ISAM error:no record found.
Error in line 2434
Near character position 30
206: The specified table (systabnames) is not in the database.
111: ISAM error:no record found.
Error in line 2440
Near character position 20
206: The specified table (sysdbslocale) is not in the database.
111: ISAM error:no record found.
Error in line 2442
Near character position 34
206: The specified table (sysdic) is not in the database.
111: ISAM error:no record found.
Error in line 2453
Near character position 18
206: The specified table (sysdiccache) is not in the database.
111: ISAM error:no record found.
Error in line 2454
Near character position 33
206: The specified table (sysdsc) is not in the database.
111: ISAM error:no record found.
Error in line 2464
Near character position 18
206: The specified table (sysdistcache) is not in the database.
111: ISAM error:no record found.
Error in line 2465
Near character position 34
206: The specified table (sysprc) is not in the database.
111: ISAM error:no record found.
Error in line 2475
Near character position 18
206: The specified table (sysproccache) is not in the database.
111: ISAM error:no record found.
Error in line 2476
Near character position 34
206: The specified table (syssqscb) is not in the database.
111: ISAM error:no record found.
Error in line 2485
Near character position 21
206: The specified table (syssqlcurall) is not in the database.
111: ISAM error:no record found.
Error in line 2491
Near character position 34
206: The specified table (syssqscb) is not in the database.
111: ISAM error:no record found.
Error in line 2505
Near character position 17
206: The specified table (syssqlcurses) is not in the database.
111: ISAM error:no record found.
Error in line 2518
Near character position 34
206: The specified table (syssdblock) is not in the database.
111: ISAM error:no record found.
Error in line 2537
Near character position 19
206: The specified table (syssqexplain) is not in the database.
111: ISAM error:no record found.
Error in line 2543
Near character position 34
Table created.
Index created.
Permission revoked.
Permission granted.
Routine created.
706: Execute privilege denied on procedure (informix.start_onpload).
111: ISAM error:no record found.
Error in line 2588
Near character position 48
Routine created.
Routine created.
Routine created.
Routine created.
Routine created.
706: Execute privilege denied on procedure (informix.dbexp).
111: ISAM error:no record found.
Error in line 2632
Near character position 40
Routine created.
706: Execute privilege denied on procedure (informix.dbimp).
111: ISAM error:no record found.
Error in line 2655
Near character position 40
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
1 row(s) updated.
2 row(s) updated.
2 row(s) updated.
Permission granted.
Statistics updated.
Database closed.
Cleaning up whatever was successfully created
Database selected.
274: No DELETE permission.
Error in line 1
Near character position 27
274: No DELETE permission.
Error in line 1
Near character position 27
Database closed.
Database dropped.
[ 本帖最后由 television 于 2008-1-16 10:37 编辑 ] 奇怪了~~你用什么用户初始化的??怎么会没有权限建表? 问题已经解决
链接如下 http://hi.baidu.com/jybbh/blog/item/a3db8d130f89dad2f7039e8c.html 原帖由 television 于 2008-1-16 17:24 发表 http://bbs.chinaunix.net/images/common/back.gif
问题已经解决
链接如下 http://hi.baidu.com/jybbh/blog/item/a3db8d130f89dad2f7039e8c.html
:em06: :em06:安装的时候怎么会出现权限不对的???自己修改过权限??? 1.
10:26:08Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs'
10:26:08Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'tempdbs1'
你的tempdbs没有建立起来。数据库第一次初始化的时候，只有rootdbs存在。要么把DBSPACETEMP指向到rootdbs，要么关闭此参数。
2.
10:26:09Maximum server connections 0
10:26:09Dataskip is now OFF for all dbspaces
你初始化数据库的时候，有没有调整ONCONFIG文件中的NETTYPE设置？该项参数指定了数据库启动时，是使用共享内存方式(onipcshm)还是网络协议(ontlitcp)来访问。其第三列指定了允许的数据库连接用户数量。请修改此项为合适数值。
3.
后面的部分是sql执行中的错误。可能是因为你的权限不够而导致表没有建立成功；或者是表之间有依赖关系，而建表顺序不对而导致建表失败。
页:
[1]
2