Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12516: TNS:listener could not find available handler with matching protocol stack

Sheng WangJan 26 2017 — edited Jan 27 2017

Hello,

We created a shared db link, it works fineĀ  to connect to another database.

The problem is, when client opened many sessions at same time (for example, simulation of 30 or so users all using the DBLINK at the same time) , we get error: ORA-12516:TNS:listener could not find available handler with matching protocol stack

database is 12.1.0.2 in windows server.
any idea?

Thank you very much!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2017
Added on Jan 26 2017
6 comments
965 views