Gorakshnath

Process Increase due to error sometimes : SQL> connect / as sysdba ERROR: ORA-00020: maximum number of processes (300) exceeded or java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found Steps to increase the number for processes/sessions at database level in Oracle is as follows   1.  Log on to the database as system administrator  In SQL Plus enter:  " connect / as sysdba "   2. Set the number of processes to be desired value  In SQL Plus  " alter system set processes=  scope=spfile "   3. Unset the number of sessions to remove the default session limit In SQLPlus  " alter system reset sessions scope=spfile sid='*'  "   4. Shutdown the database In SQL Plus  " shutdown immediate "   5. Startup the database  In SQL Plus  " startup "    6. Check the changes have taken effect. In SQL Plus...