Skip to Main Content

Database Software

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-12518: TNS:listener could not hand off client connection

Rafiq DSep 18 2016 — edited Sep 21 2016

Platform: Windows 7 professional 64-bit 8gb Ram HP 700gb free space on hd

Database version: 12c multitenant with 1 pdb

My listener is configured and running

tnsnames.ora has entries for the root and the pdb services

When I check the listener status, the services are not dynamically registered and so I am unable to connect to the pdb using the listener. I also tried direct connection by specifying all parameters in the connect string but still got the same error. I statically registered the two services to the listener but that didn't help. I checked v$services and saw the two services there but the root and the pdb services both have the same service_id. Could this be the reason? How do I resolve this? There is nothing about this in the alert logs either.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2016
Added on Sep 18 2016
3 comments
3,569 views