Search code examples
oracleoracle-sqldeveloper

How to connect to SSL enabled Oracle database using SQL Developer

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.

Solution

  • 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)))