oninit -ivy 起不来数据库 帮忙看下

television

执行oninit -ivy的结果
[/home/db/informix]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查看日志的结果
[/home/db/informix]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:53  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'tempdbs'
09:19:53  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'tempdbs1'
09:19:53  Checkpoint Completed:  duration was 0 seconds.
09:19:53  Checkpoint loguniq 1, logpos 0xf8, timestamp: 0x60

09:19:53  Maximum server connections 0
09:19:53  Dataskip is now OFF for all dbspaces
09:19:53  On-Line Mode
09:19:53  Building 'sysmaster' database ...
09:19:56  Logical Log 2 Complete, timestamp: 0x720e.
09:19:56  Process 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:57  Checkpoint Completed:  duration was 0 seconds.
09:19:57  Checkpoint loguniq 3, logpos 0x18, timestamp: 0x722f

09:19:57  Maximum server connections 1
09:19:57  Error building 'sysmaster' database.
09:19:57  See '/tmp/buildsmi.127130'.
09:19:57  Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 3 6 "Internal Subsystem failure: 'SMI'" "Error building 'sysmaster'

liaosnet

先把环境里的DBSPACESTEMP 这个环境参数关闭~
重新初始化~~

[ 本帖最后由 liaosnet 于 2008-1-16 09:26 编辑 ]

television

初始化好几次了
都一样的报错

television

关了那个参数还是不行
没有warning了
building数据库的时候错了

[/home/db/informix]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:58  IBM Informix Dynamic Server Version 9.40.FC5     Software Serial Number AAA#B000000
10:26:08  IBM Informix Dynamic Server Initialized -- Complete Disk Initialized.
10:26:08  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'tempdbs'
10:26:08  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'tempdbs1'
10:26:09  Checkpoint Completed:  duration was 0 seconds.
10:26:09  Checkpoint loguniq 1, logpos 0xf8, timestamp: 0x60

10:26:09  Maximum server connections 0
10:26:09  Dataskip is now OFF for all dbspaces
10:26:09  On-Line Mode
10:26:09  Building 'sysmaster' database ...
10:26:11  Logical Log 2 Complete, timestamp: 0x720e.
10:26:11  Checkpoint Completed:  duration was 0 seconds.
10:26:11  Checkpoint loguniq 3, logpos 0x18, timestamp: 0x722f

10:26:11  Maximum server connections 1
10:26:12  Error building 'sysmaster' database.
10:26:12  See '/tmp/buildsmi.143534'.



cat /tmp/buildsmi.143534的结果


将其中的报错部分粘了出来
#[/home/db/informix]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 编辑 ]

liaosnet

奇怪了~~你用什么用户初始化的??怎么会没有权限建表?

television

问题已经解决

链接如下 http://hi.baidu.com/jybbh/blog/item/a3db8d130f89dad2f7039e8c.html

liaosnet

原帖由 television 于 2008-1-16 17:24 发表
问题已经解决

链接如下 http://hi.baidu.com/jybbh/blog/item/a3db8d130f89dad2f7039e8c.html

  安装的时候怎么会出现权限不对的???自己修改过权限???

cloudflashes

1.
10:26:08  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'tempdbs'
10:26:08  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
                   in DBSPACETEMP: 'tempdbs1'

你的tempdbs没有建立起来。数据库第一次初始化的时候，只有rootdbs存在。要么把DBSPACETEMP指向到rootdbs，要么关闭此参数。

2.
10:26:09  Maximum server connections 0
10:26:09  Dataskip is now OFF for all dbspaces

你初始化数据库的时候，有没有调整ONCONFIG文件中的NETTYPE设置？该项参数指定了数据库启动时，是使用共享内存方式(onipcshm)还是网络协议(ontlitcp)来访问。其第三列指定了允许的数据库连接用户数量。请修改此项为合适数值。

3.
后面的部分是sql执行中的错误。可能是因为你的权限不够而导致表没有建立成功；或者是表之间有依赖关系，而建表顺序不对而导致建表失败。