9i : ORA-00020: maximum number of processes (%s) exceeded 2004-02-26 - By GovindanK
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@(protected)
> > [mailto:oracle-l-bounce@(protected)]On Behalf Of Guang Mei
> > Sent: Wednesday, February 25, 2004 4:04 PM
> > To: Oracle-L-freelists
> > Subject: 9i : ORA-00020 (See ORA-00020.ora-code.com): 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 (See ORA-00020.ora-code.com): maximum number of processes (%s) exceeded
> >
> >
> > Enter user-name:
> > ERROR:
> > ORA-01017 (See ORA-01017.ora-code.com): invalid username/password; logon denied
> >
> >
> > Enter user-name:
> > ERROR:
> > ORA-01017 (See ORA-01017.ora-code.com): 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 (See ORA-24324.ora-code.com): service handle not initialized
> > ORA-24323 (See ORA-24323.ora-code.com): value not allowed
> > ORA-00020 (See ORA-00020.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
