ORA-12516: TNS:listener could not find available handler with matching protocol stack
protocol, presentation, and session.
Check that the service handlers (e.g. dispatchers) for given SERVICE_NAME are registered with the listener, and that they are properly configured to support the desired protocols and presentations, and are accepting connections.
You might also want to check if the number of connections reaches the database's PROCESSES parameter using following Unix command:
ps -ef | grep oracleSID | grep -v grep | wc -l
or
ps aux | grep oracleSID | grep -v grep | wc -l
If the value found is close to the value of the PROCESSES database parameter value, you might want to augment this value using following command:
alter system set processes=new value [scope=spfile];
A database bounce is required to let the new value become active.
Welcome to our forum for Oracle error: ORA-12516 Add your own message
Execute following select:
select count(*) from gv$session
To know the exact number of sessions in your database.
If it is close to 731 at some moment, increase the value of sessions parameter
i have came accross this problem i am a new dba and just i have join the company i got this error ora-12516 and regarding my parameters it is set sessions=731 and processes=660 sga_target=5gb,sga_max_size=7gb and my ram is 16gb. This is my configuration and plz let me know on which basis we have to set the no of sessions and process
I am using ASP.NET web application and db is Oracle 10g XE.I am getting again and again
ORA-12516:TNS:Listener could not find available handler with matching protocol
how can i get rid of this error
while logging to SFMS(NEFT) system is giving error as "unable to get database connection to user SFMSFGW with Password".how to resolve this issue as the same is getting arised frequently?
You will need to increase the value of the processes parameter.
alter system set processes=500 scope=spfile;
And restart your database instance.
restart the listener service in the database server this will fix the issue
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.