Skip to Main Content

SQL & PL/SQL

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!

SQLPLUS - Bouncing a database.

CodebreakerAug 30 2016 — edited Aug 31 2016

Hi,

I have been getting this error "ORA-00020 maximum number of processes exceeded" each time I am trying to connect to the instance

through sqlplus.

Yes I understand I need to increase the processes parameter, that's fine. . which in turn requires a database bounce to take effect.

The issue I am facing is how to bounce the database as I am not able to login as sysdba through SQLPLUS as it gives the said error. ?

I do know I can bounce the database using "srvctl stop database command", is there any other way I can do it through sqlplus ?

Thanks for helping!

Just a learner.

This post has been answered by AndrewSayer on Aug 30 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2016
Added on Aug 30 2016
10 comments
2,073 views