Invalid Connection String Format Error when adding an Oracle Database

Question / Problem:

When trying to connect to an Oracle Database in Management Console the following error occurs:

“Error connecting to the database: IO Error: Invalid Connection String Format, a valid format is host:port:sid”

invalid connection string.jpg

How can I resolve this issue?

Add the port after your host, along with : so it looks like host:1521

connection successfully established.jpg