Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00020: maximum number of processes (200) exceeded

940673Dec 15 2012 — edited Dec 16 2012

Hi All,

I am not able to login to my database as a sysdba. It's throwing the below error:-

oracle@blrvqorasdb01:ARSUATDB [home/oracle] > sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 15 19:21:12 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-00020: maximum number of processes (200) exceeded

In init.ora file I found that oracle process parameter is set to 200 which I have to increase. The database is up and running as I see from the below command.

oracle@blrvqorasdb01:ARSUATDB [home/oracle] > ps -ef|grep pmon
oracle 23268 23119 0 19:25:14 pts/1 0:00 grep pmon
oracle 25762 760 0 Dec 14 ? 8:33 ora_pmon_ARSUATDB
oracle 1556 760 0 Oct 26 ? 25:16 asm_pmon_+ASM

Please suggest me how can I login to the database. Other applications connected to this database are facing connection problems.

Please assisit.

Regards,
Arijit

This post has been answered by sb92075 on Dec 15 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 13 2013

Added on Dec 15 2012

#general-database-discussions

4 comments

764 views