ORA-00018: maximum number of sessions exceeded

How to Fix ORA-00018: maximum number of sessions exceeded

Cause: All session state objects are in use.

Action: Increase the value of the SESSIONS initialization Parameter.

Steps.

Login to your database as sysdba

sqlplus / as sysdba

SQL: show parameter sessions

500

SQL: create pfile='/tmp/initORCL.ora' from spfile;

SQL: Alter System set sessions= 700 scope=both;

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

How to Resolve ORA-00020: maximum number of processes (string) exceeded

Cause: All process state objects are in use.

Action: Increase the value of the PROCESSES initialization Parameter.

Steps:

Login to your database as sysdba

sqlplus / as sysdba

SQL: show parameter processes

300

Backup your init file before changing the Parameter

SQL: create pfile='/tmp/initORCL.ora' from spfile;

SQL: Alter System set processes= 600 scope=spfile;

SQL: shutdown immediate

SQL: Startup

Note:- Since processes is an static Parameter you must restart the DB / Instance to bring the modified value in effect