Solution to ORA-24324 errors

Source: Internet
Author: User
Tags informix
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.