Why would you set processes = 12? Are you trying to OFF you databse? Was this some kind of a bad experiment? What worked for 8i doesn't necessarily work for 9i. Use the kill command and just kill the SQL*Plus sessions, log in as SYSDBA and shutdown the DB, and call it a day. Or use "kill" to kill the database. Dealer's choice. ============================================================================================================ Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) reginald.w.bailey@xxxxxxxxxxxx baileyre@xxxxxxxxxx ============================================================================================================ gmei@xxxxxxxxxx Sent by: To: oracle-l@xxxxxxxxxxxxx oracle-l-bounce@fre cc: elists.org Subject: 9i : ORA-00020: maximum number of processes (%s) exceeded 02/25/2004 03:03 PM Please respond to oracle-l 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------