Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-00020: maximum number of processes (%s) exceeded

Re: ORA-00020: maximum number of processes (%s) exceeded

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 25 Feb 2004 17:32:08 -0400
Message-ID: <013101c3fbe6$d24f5450$2501a8c0@dazasoftware.com>


are you using the "as sysdba" option?
do this

sqlplus /nolog
conn sys/xxx_at_aaa.world as sysdba;

> 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
> -----------------------------------------------------------------
>



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 Wed Feb 25 2004 - 15:32:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US