Client connections from linux to Solaris DB server failing
Hello,
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
server
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.
I presume Oracle client and DB server can be on a heterogeneous distributed system ?
Regards,
Valli