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 (Doc ID 1584886.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

OWB setup had been completed with a runtime service running on a different server than the repository database server.

Cause

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