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 JULY 21, 2023

Applies to:

Oracle Warehouse Builder - Version 11.1.0.6 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.

	To view full details, 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 a vibrant support community of peers and Oracle experts.