ORA-12516 Error TNS:listener could not find available 11g Windows 64 Bit
Hi all
We use Oracle 11g 64 Bit ver on windows 2008 Standard Server 64 Bit.
We have around 100 concurrent users
Users are able to connect and work without any problem from all machines
we use following connection string thru VB6
provider = msdaora,userid = ??,password=??, server = oracle server name
Now approx once or twice in a day we get following error
ORA-12516 Error TNS:listener could not find available handler with matching protocol stack.
Then users are not able to make fresh connection.
After that we stop the listner service at the server and start listner again -> Problem gets resolved.
We did not find such problem any time when we used Oracle 10g Database on 32 Bit as well as 64 Bit machine.
Kindly advise some method so that we donot get this listner not working problem again and again
Suresh Bansal