How about cleaning up Shared memory segments using ipcs
> and (ipcrm -s <shared mem process> for unix and ipcrm sem <shared mem
> process> for linux).
>
> HTH
> GovindanK
>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org
>> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Guang Mei
>> Sent: Wednesday, February 25, 2004 4:04 PM
>> To: Oracle-L-freelists
>> Subject: 9i : ORA-00020: maximum number of processes (%s) exceeded
>>
>>
>> Hi:
>>
>> In 8i, when I got the above error, I always could launch svrmgrl,
>> connected
>> as intenal and bounce the DB. Now in 9i without svrmgrl, how do we
>> bounce
>> the db if we have the above error?
>>
>> I did the following test on a 9204 db on Solaris 9:
>>
>> 1. I set up processes=12 in init.ora, and started the db, everything
>> is OK.
>> ps -ef|grep ora_ gave me:
>>
>> oracle 9209 1 0 13:59:20 ? 0:00 ora_pmon_YPD
>> oracle 9217 1 0 13:59:21 ? 0:01 ora_smon_YPD
>> oracle 9211 1 0 13:59:20 ? 0:00 ora_dbw0_YPD
>> oracle 14801 14800 0 15:44:56 pts/3 0:00 ps -ef
>> oracle 9223 1 0 13:59:21 ? 0:01 ora_qmn0_YPD
>> oracle 14800 14787 0 15:44:56 pts/3 0:00 grep oracle
>> oracle 9215 1 0 13:59:21 ? 0:02 ora_ckpt_YPD
>> oracle 9219 1 0 13:59:21 ? 0:00 ora_reco_YPD
>> oracle 9213 1 0 13:59:21 ? 0:02 ora_lgwr_YPD
>> oracle 9221 1 0 13:59:21 ? 0:00 ora_cjq0_YPD
>>
>> 2. I opened two seperated sql sessions, connected as regular user. No
>> problem. So I left them idle.
>>
>> 3. When I tried the 3rd session, I got
>>
>> essex$ sqlplus user/password
>>
>> SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 25 15:46:31 2004
>>
>> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>>
>> ERROR:
>> ORA-00020: maximum number of processes (%s) exceeded
>>
>>
>> Enter user-name:
>> ERROR:
>> ORA-01017: invalid username/password; logon denied
>>
>>
>> Enter user-name:
>> ERROR:
>> ORA-01017: invalid username/password; logon denied
>>
>>
>> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
>> essex$ sqlplus '/ as sysdba'
>>
>> SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 25 15:46:57 2004
>>
>> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>>
>> Connected.
>> SQL> shutdown immediate
>> ORA-24324: service handle not initialized
>> ORA-24323: value not allowed
>> ORA-00020: maximum number of processes (%s) exceeded
>>
>>
>> I can not shut down the DB. The other two sessions are still working as
>> normal. I don't want to do "kill -9" to another sqlplus connection if I
>> don't have to. Do I have another choice if I want to bounce the db?
>>
>> TIA.
>>
>> Guang
>>
>>
>>
>
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 13:01:59 CST
