OWB 11g Remote Runtime Service Connecting to SCAN Address Fails to Start With Error: ORA-12516, TNS:listener could not find available handler with matching protocol stack
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 18.104.22.168 and later
Information in this document applies to any platform.
The attempt to start an OWB 11g remote runtime service with a connection to a SCAN address, fails with:
SQL*Plus connection from the remote runtime server to the same SCAN address works fine.
OWB setup had been completed with a runtime service running on a different server than the repository database server.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms