log in to oracle database
[oracle@arpit]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 12 14:34:37 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
check the current display process
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- --------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 4
log_archive_max_processes integer 2
processes integer 40
change the value to 300
SQL> alter system set processes = 300 scope = spfile;
System altered.
Restart the database and issue is gone.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 348127232 bytes
Fixed Size 1258824 bytes
Variable Size 104860344 bytes
Database Buffers 239075328 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.
