Sql developer custom connection string

Question

How to use custom connection string in Oracle sql developer to connect?

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=147.22.109.218)(port=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=147.22.109.219)(port=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=147.22.109.220)(port=1521)))
(FAILOVER=on)(LOAD_BALANCE=on)
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=cmphpd)))

Please help. Thanks

Answer 1

To us a TNS connection string, in the New / Select Database Connection window where you configure the connection:

1. Set Connection Type to TNS
2. Under the Details tab select Connect Identifier
3. Put the connection string into the text box next to Connect Identifier
4. Click Test if you'd like, to make sure it works
5. Click Save

Similarly, under Connection Type there also seems to be an option for a custom JDBC URL if that's what you prefer.

(Instructions and screenshot from version 19.4, in case it makes a difference)