Skip to Main Content
Forums

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: I cannot connect / as sysdba?!?!

cayenneOct 22 2009 — edited Oct 27 2009
Hello all,

I've got a database instance that has apparently run out of processes, however, I cannot even seem to log on as sys to fix things..!!

SQL> connect / as sysdba
ERROR:
ORA-00020: maximum number of processes (%s) exceeded


SQL> connect sys as sysdba
Enter password:
ERROR:
ORA-00020: maximum number of processes (%s) exceeded



Any suggestions? How can I fix things if I cannot get in?

Thank you in advance,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2009
Added on Oct 22 2009
#general-database-discussions
5 comments
24,932 views