How to connect to SSL enabled Oracle database using SQL Developer

Question

I am trying to connect to Oracle database through SQL Developer. Our database is SSL enabled and runs with TCPS. In SQL Developer, I could not find any option where I can configure SSL parameters.

Does SQL developer support connecting to SSL enabled databases? If yes, how. I searched a lot about this, but could not find any relevant solution.

Answer 1

Find sqldeveloper.conf and add lines

    AddVMOption -Djavax.net.ssl.trustStore=point to your keystore.jks with Oracle certificate
    AddVMOption -Djavax.net.ssl.trustStoreType=JKS
    AddVMOption -Djavax.net.ssl.trustStorePassword=your keystore password

In the developer use custom JDBC URL like

    jdbc:oracle:thin:@(description=(address=(protocol=tcps)(host=your dbhost)(port=2484))(connect_data=(service_name=your db_service)))