user4566776 wrote:tnsping doesn't do what you think it does. It only confirms name resolution and an open net link to the listener.
I am getting the following error when I am connecting from my client box (Linux x86_64) with oracle client 11.1 installed onto my Solaris-SPARC DB server which has an oracle 11.2 installed
ORA-12520: TNS:listener could not find available handler for requested type of
I checked a lot of stuff online. They all said.
1. Check your Listner service
The listener service seems to be fine because I ca connect to it using the listner from my local Solaris SPARC box and also from another Soalris SPARC box which has an 10 g oracle client
2. The process limit must have got saturated.
However that is not the case either I have checked the v$resource limit view and confirmed, I have also increased the process count
However when I do an TNSPING from my linux box using the service name of the Solaris DB I am able to get a successful ping.
I need your help to fix it.Yes it absolutely can.
I presume Oracle client and DB server can be on a heterogeneous distributed system ?
user4566776 wrote:I can't recall the last time I personally faced your specific error message. I'd have to research it, which is something you can do. Else wait for someone else to contribute to the thread.
Thanks for the reply, can yoy let me know how to troubleshoot / resolve it.
user4566776 wrote:when was last time this client successfully connected?
Any suggestions on how can this be troubleshooted.
user4566776 wrote:since you choose to ignore my request, I choose to not waste more time with you.
The client connection was setup just yesterday, so it does not have a track record of working fine before but other client connections from here to linux DB's are working fine.
The error message is the same ora-12520 as pasted above.