Today, when the database is locked in the test environment, shutdownimmediate cannot be used to shut down the database, so I use ps-fuoracle | grepecds | awk.
Today, when the database is locked in the test environment, shutdown immediate cannot be normally used to shut down the database, so I use ps-fu oracle | grep ecds | awk
The database is locked in the test environment today, and the database cannot be shut down through shutdown immediate normally ,, so I used ps-fu Oracle | grep ecds | awk '{print $2}' | xargs kill-9 to forcibly Delete All oracle processes. Now, when I enter sqlplus to start the database, the database will run again. Execute shutdown immediate to shut down the database and report the following error:
WH7620_2:/home/db/oracle/OraHome_1/dbs/> sqlplus/as sysdba
SQL * Plus: Release 10.2.0.5.0-Production on Mon May 20 15:35:50 2013
Copyright (c) 1982,201 0, Oracle. All Rights Reserved.
Connected.
SQL> shutdown immediate
The ORA-24324: service handle not initialized.
ORA-24323: value not allowed
ORA-00020: maximum number of processes (% s) exceeded
SQL> quit
Disconnected
Solution: view shared memory resources
WH7620_2:/home/db/oracle/OraHome_1/dbs/> ipcs-pmb
IPC status from/dev/kmem as of Mon May 20 15:36:28 2013
T ID KEY MODE OWNER GROUP SEGSZ CPID LPID
Shared Memory:
M 0 0x411c01a9 -- rw-root 348 940 940
M 1 0x4e0c0002 -- rw-root 61760 940
M 2 0x41200d18 -- rw-root 8192 940 942
M 163843 0x00a5c581 -- rw ------- sfmdb users 10469376 23673 23677
M 4 0x411c10cf -- rw ------- root 4096 1982 2645
M 2392069 0x00000000 -- rw-r ----- oracle dba 16777216 4212 5423
M 425990 0x01200ce2 -- rw-r -- root 4192 5398 5398
M 65543 0x06347849 -- rw-root sys 65544 5460 685
M 8 0x0000b212 -- rw-r -- root 22912 2196 8298
M 65545 0x00000000 -- rw-r ----- oracle dba 1073741824 4212 5423
M 10 0xa90c0292 ----------- root 1 2463 2464
M 1409035 0xbea746bc -- rw-r ----- oracle dba 553656320 4212 5423
M 12 0x01200cea -- rw-r -- root 4192 2510 2510
M 13 0x01200c44 -- rw-r -- root 4192 2512 2512
M 14 0x01200cfa -- rw-r -- root 4192 2516 2555
M 65551 0x01200d1a -- rw-r -- root 4192 2601 2601
M 163864 0x0001e240 -- rw-tuxedo 442976 24529 24677
M 131102 0x01108f85 -- rw-csspkm 47532 20662
M 360482 0x01108129 -- rw-nettrack informix 50432104 4371
M 229411 0x01100d01 -- rw-nettrack informix 262272104 4371 4385
M 229412 0x01107934 -- rw-nettrack informix 51584104 4371
M 393253 0x52614806 -- rw-rw ---- informix 8388608 29904
M 524326 0x01108133 -- rw-nettrack informix 1360000 4371
M 524327 0x0110812b -- rw-nettrack informix 1520000 4371 4371
M 524328 0x01107602 -- rw-nettrack informix 3360000 4371
M 41 0x52614801 -- rw-rw ---- root informix 119341056 29904
M 42 0x52614802 -- rw-rw ---- root informix 33439744 29904
M 43 0x52614803 -- rw-root informix 561152 29904
M 44 0x52614804 -- rw-rw ---- informix 8388608 29904
M 458797 0x011009ee -- rw-nettrack informix 3360000 4371 4371
M 458798 0x01100b02 -- rw-nettrack informix 3360000 4371 4371
M 458799 0x0110793f -- rw-nettrack informix 50432104 4375 4379
M 458800 0x01108136 -- rw-nettrack informix 1360000 4375
M 458801 0x0110812f -- rw-nettrack informix 1520000 4375 4375
M 458802 0x01108138 -- rw-nettrack informix 3360000 4375
M 458803 0x0110813a -- rw-nettrack informix 3360000 4375 4375
M 458804 0x01108148 -- rw-nettrack informix 3360000 4375
M 458805 0x01100da0 -- rw-nettrack informix 304128052 4391 4385
M 458806 0x01100a81 -- rw-nettrack informix 190080052 4397 4385
M 458807 0x01100dbe -- rw-nettrack informix 190080052 4421 4385
M 458808 0x01100db1 -- rw-nettrack informix 190080052 4412 4418
M 458809 0x01100df0 -- rw-nettrack informix 190080052 4447 4385
M 458810 0x01100de9 -- rw-nettrack informix 190080052 4441 4385
M 458811 0x01100db9 -- rw-nettrack informix 95040052 4432 4427
M 458812 0x01100e12 -- rw-nettrack informix 190080052 4453 4456
M 458813 0x01100ecf -- rw-nettrack informix 95040052 4486 4489
M 458814 0x01100mcm -- rw-nettrack informix 95040052 4480 4483
M 458815 0x01100e14 -- rw-nettrack informix 190080052 4385 4465
M 458816 0x01100eca -- rw-nettrack informix 95040052 4385 4477
M 458817 0x01100ed1 -- rw-nettrack informix 190080052 4385 4495
M 458818 0x01100ed6 -- rw-nettrack informix 190080052 4385 4504
M 458819 0x01100ed8 -- rw-nettrack informix 190080052 4385 4522
M 458820 0x01100eda -- rw-nettrack informix 95040052 4385 4531
M 458821 0x01100ee1 -- rw-nettrack informix 190080052 4385 4543
M 458822 0x01100ee3 -- rw-nettrack informix 190080052 4385 4540
M 73 0x52614805 -- rw-rw ---- informix 8388608 29904
M 65615 0x0c6629c9 -- rw-r ----- root dba 17869240 685 8298