My Oracle Support Banner

OWB 11.2 Test of Location of type SQL*Net Fails with Invalid connection string format, a valid format is: “host_port:dsid” (Doc ID 1927139.1)

Last updated on FEBRUARY 06, 2019

Applies to:

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

Symptoms

Oracle Warehouse Builder and Database have been upgraded from 10.2 to 11.2.0.4.

When attempting to test the connection for Locations defined as type “SQL*Net” the following error occurs:


The above only occurs when the service name contains a dot (.). Also, fixes the error message when the service name does not contain a dot (.).

Changes

Upgrade from 10.2 to 11.2.0.4.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.