SSL (TCPS) Connections from OHS/mod_plsql or SQL*Plus to Database Fails with "ORA-12560: TNS:protocol Adapter Error"
(Doc ID 2122646.1)
Last updated on OCTOBER 02, 2023
Applies to:Oracle HTTP Server - Version 18.104.22.168.0 to 22.214.171.124.0 [Release Oracle11g to 12c]
Oracle Fusion Middleware - Version 126.96.36.199.0 to 188.8.131.52.0 [Release Oracle11g to 12c]
Information in this document applies to any platform.
- Applies to Oracle Database Clients 184.108.40.206 and 220.127.116.11 installed in Oracle Fusion Middleware 18.104.22.168, 12.1.2, and 12.1.3 homes
- The same 22.214.171.124 is installed in 126.96.36.199 -188.8.131.52 homes, however mod_plsql was deprecated and no longer supplied in 12.2.1. This document and patches are only applicable up to OHS 12.1.3.
This issue can occur for SQL*Plus and OHS/mod_plsql connecting to the database over TCPS. It could be any client using sqlnet layer for TCPS that experiences this problem.
- When the pl/sql procedures are using a secure connection between Oracle HTTP Server and an Oracle Database, the pl/sql procedures fail with the following errors:
This issue only occurs when using an Secure Connection between Oracle client application and an Oracle Database Server (ie. PROTOCOL=TCPS). When mod_plsql is *not* secured from Oracle HTTP Server and the Oracle Database (ie. PROTOCOL=TCP), the pl/slql procedure works. This issues also occurs when using a simple SQL*Plus connection to the database using TCPS.
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.