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”
How can I resolve this issue?
Answer / Solution:
Add the port after your host, along with : so it looks like host:1521