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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms