My Oracle Support Banner

End To End Examples of using SSL With Oracle's JDBC THIN Driver (Doc ID 762286.1)

Last updated on DECEMBER 06, 2023

Applies to:

Oracle WebLogic Server - Version 12.1.1.0 and later
JDBC - Version 10.2.0.4 and later
Information in this document applies to any platform.

Goal

The following how-to demonstrates, creating a self signed oracle wallet for the server and client, configuring the database to use TCPS with the server key, configuring an SQL client to connect to TCPS and create simple java clients that shows how to connect through to TCPS in several different examples.

This note is NOT intended to describe a secure production SSL environment.

The steps below are intended to enable the reader to configure and become familiar with the steps required to configure JDBC SSL connection using TCPS.

For IBM JDK, please refer to:

<Document: 1424544.1> JDBC Connections Over Ssl Fail with IBM JDK

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Creating the server and client keys using orapki.
 Configuring the database to use tcps with the server key.
 Configure an SQL*Plus client to connect to the database using the client key through TCPS.
 Java Client Side Tests
 Verifying SSL Encryption
 Common Runtime Error Messages
 More Information
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.