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...
gorakshnath@gmail.com



















































Comments