- 论坛徽章:
- 0
|
数据库可以正常启动,就是停不掉,救命啊!!
[informix@isp ~]$ oninit -viy
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/onconfig.test'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 51084 kbytes...succeeded
Allocating 100016 kbytes for buffer pool of 2K page size...succeeded
Creating infos file "/home/informix/etc/.infos.test_sys"...succeeded
Linking conf file "/home/informix/etc/.conf.test_sys"...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 'soctcp' listener threads...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Validating chunks...succeeded
Creating database partition...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5
[informix@isp ~]$ onstat
IBM Informix Dynamic Server Version 11.50.UC5 -- On-Line -- Up 00:02:59 -- 185428 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
4d743018 ---P--D 1 informix - 0 0 0 3 55015
4d74361c ---P--F 0 informix - 0 0 0 0 21
4d743c20 ---P--F 0 informix - 0 0 0 0 0
4d744224 ---P--F 0 informix - 0 0 0 0 0
4d744828 ---P--F 0 informix - 0 0 0 0 0
4d744e2c ---P--F 0 informix - 0 0 0 0 0
4d745430 ---P--F 0 informix - 0 0 0 0 0
4d745a34 ---P--F 0 informix - 0 0 0 0 0
4d746038 ---P--F 0 informix - 0 0 0 0 0
4d74663c ---P--- 8 informix - 0 0 0 0 0
4d746c40 ---P--B 9 informix - 0 0 0 0 0
4d747244 ---P--D 10 informix - 0 0 0 0 0
4d747848 ---P--D 11 informix - 0 0 0 2 0
4d747e4c ---P--- 14 informix - 0 0 0 0 0
4d748450 ---P--- 13 informix - 0 0 0 0 0
15 active, 128 total, 16 maximum concurrent
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
5 5 168 97.02 140 55036 107 0.00
isamtot open start read write rewrite delete commit rollbk
174 57 56 0 0 0 0 2 0
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 0.13 6.33 2 2
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
1 0 19 0 0 1 3 0
ixda-RA idx-RA da-RA RA-pgsused lchwaits
0 0 0 0 75
启动都成功了,而且数据库可以使用,但是我用oninit -ky 停止数据库就出错
[informix@isp ~]$ oninit -ky
oninit: Fatal error in shared memory creation
WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.
[informix@isp ~]$ cat tmp/online.log
23:10:56 Get Shadow Password for user [informix] failed!
23:10:56 Check for password aging/account lock-out.
23:10:56 listener-thread: err = -951: oserr = 0: errstr = informix@isp: Incorrect password or user informix@isp is not known on the database server.
23:11:01 IBM Informix Dynamic Server Started.
23:11:01 shmget: [EEXIST][17]: key 52564801: shared memory already exists
23:11:01 mt_shm_init: can't create resident segment
[informix@isp ~]$ ipcs
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x52564801 0 informix 660 155893760 8
0x52564802 32769 informix 660 33439744 8
0x52564803 65538 informix 666 544768 8
------ Semaphore Arrays --------
key semid owner perms nsems
0x00000000 0 informix 660 9
0x00000000 32769 informix 666 52
------ Message Queues --------
key msqid owner perms used-bytes messages
那位高人能指点下吗? |
|