SQL Developer 4.1.1 Status : Failure -Test Failed Vendor Code 17002 (Doc ID 2038401.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 4.1 to 4.1 [Release 4]
Information in this document applies to any platform.
It works fine with lower versions of sql*developer from 4.0.3.
It fails with the version 4.1.1

Symptoms

When the global name of a database contains hyphens, if you define a connection with SERVICE_NAME instead of SID, it will cause the following error when testing the connection :

"Status : Failure -Test failed: IO Error: Invalid connection string format, a valid format is: "host:port:sid"

If you use SID instead of SERVICE NAME, the connection will succeed.

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