My Oracle Support Banner

A Simple Example of a TCPS Loopback Connection Using OpenSSL. (Doc ID 262394.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Advanced Networking Option - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.


To provide a complete example of enabling a TCPS SQLNet connection. This note is NOT intended to describe a secure SSL environment. The steps below are intended to enable reader to become familiar the steps required to configure a client server SQLNet connection using TCPS.

In a real time SSL environment it is not recommended to use a self signed certificated .
Also it is a best practice to test SSL setup between a client and server ,  instead of testing a loop back connection i.e using a same instance as both server and client.



The note has been written using OpenSSL provided with UnitedLinux 1.0 and RDBMS.  This note is valid for other database server versions .

In this note the client and server share the same ORACLE_HOME and therefore the  same wallet. The connection only authenticates the database server.

If you have your own certficate authority such as Oracle Certificate Authority, OCA, replace the CA creation and certificate signing steps with the correct steps for your CA package or certficate provider.

Oracle's primary reference for SSL is the Oracle Advanced Security Administrator's Guide. This guide describes Oracle's SSL solution and configuration in greater detail, see Configuring Secure Sockets Layer
Authentication. The guide is available on the documentation CD and at:


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

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

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