after the increasing the Number processes in the Oracle database, it solved the problem.
But Before this , i am gonna show you some steps to check the process via OS and Database LETS BEGIN :
- check if the number of connections reaches the database’s process parameter using following Unix command:
ps -ef | grep oracleSID | grep -v grep | wc -l
or
ps aux | grep oracleSID | grep -v grep | wc -l
- check if the number of connections reaches the database’s process parameter using following Database Command :
SQL> show parameter processes
NAME TYPE VALUE
------------------ ----------- -------
processes integer 150
SQL> select count(*) from v$process;
COUNT(*)
----------
149
SQL> show parameter sessions
NAME TYPE VALUE
------------------ ----------- -------
Session integer 150
SQL> select count(*) from v$session;
COUNT(*)
----------
149
Now We need To Increase the Both Parameter By :
SQL> alter system set processes=300 scope=spfile;
System altered.SQL> alter system set Session=300 scope=spfile;
System altered.
If this Solution Not Work For you , Try this One :
SQL> alter system set local_listener=“(ADDRESS=(PROTOCOL=tcp)(HOST=10.122.28.12)(PORT=1521))” sid=’ORCL1′;System altered.
SQL> show parameter local
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.122.28.12)(PORT=1521))
Thank you
Osama Mustafa
Technology Geek 
Database should be restarted after the modification of processes parameter.
LikeLike
Depend on the Scope Memory or Spfile
LikeLike
alter system set Session=300 scope=spfile;”sessions” not session
LikeLike
what is the significance of local_listener in this case ? plz explain Thanks in advance. 🙂
LikeLike
local listener to help manage connections across all database instances, If you set the parameter to null then the default local address of TCP/IP, port 1521 is assumed But in our we used this way or you set Listener Name
LikeLike
it really worked well, thanks
LikeLike
ORA-12516: TNS:listener could not find available handler with matching protocol stack ;connString=”Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.108)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));user id=db_fc1;password=db_fc1;”أحيانا يحدث الخطأ أعلاه مع العلم أنني أستخدم في جهازي oracle10g والاصدار المحمل على السرفر هو oracle 11g
LikeLike
define “أحيانا”
LikeLike
How I am supposed to run these commands ? please urgent help needed….
LikeLike
Using oracle 10g express edition
LikeLike
thank you mr.osama
LikeLike