My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle SQL Developer - Version 4.1 to 4.1 [Release 4]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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


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.




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

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